[es] - MySQL Server Uptime

after
Ajvanho, ING

Član broj: 276962
Poruke: 97
*.dynamic.sbb.rs.

+6 Profil

^{12.10.2011. u 20:09 - pre 152 meseci}

Pozdrav svima,

Nakon restartovanja linux hosta, mysql se podize i radi bez problema. Medjutim, mysql server pokazuje nenormalno uptime vreme - stotine (hiljada) godina? Uptime na linux hostu pokazuje ispravno vreme (~30min).

Code:

mysql> status;
--------------
mysql  Ver 14.14 Distrib 5.1.52, for redhat-linux-gnu (x86_64) using readline 5.1

.....
.....
Uptime:                 --------------

mysql> show global status like 'uptime';
+---------------+----------------------+
| Variable_name | Value                |
+---------------+----------------------+
| Uptime        | 18446744073709549338 |
+---------------+----------------------+
1 row in set (0.00 sec)

[root@retc]# mysqladmin -u root -p version
Enter password:
mysqladmin  Ver 8.42 Distrib 5.1.52, for redhat-linux-gnu on x86_64
Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version          5.1.52
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:

[root@retc]# mysqladmin -u root -p status
Enter password:
Uptime: 18446744073709549593  Threads: 12  Questions: 3342  Slow queries: 0  Opens: 136  Flush tables: 1  Open tables: 64  Queries per second avg: 0.0

[root@retc]# mysqladmin -u root -p  extended-status | grep Uptime
Enter password:
| Uptime                            | 18446744073709549412 |

U error logu nema nekih posebnih poruka. Da li je neko imao iskustva sa ovakvim ponasanjem mysql-a?

Odgovor na temu

bogdan.kecman
Bogdan Kecman
"specialist"
Oracle
srbistan

Član broj: 201406
Poruke: 15887
*.com
Via: [es] mailing liste

Sajt: mysql.rs

+2377 Profil

Re: MySQL Server Uptime

^{12.10.2011. u 20:13 - pre 152 meseci}

proveri da li ti je verrzija klijenta i servera ista, ako jeste - prijavi bug

arhimed
http://www.mysql.rs/ | http://elco.crsndoo.com/

Odgovor na temu

after
Ajvanho, ING

Član broj: 276962
Poruke: 97
*.dynamic.sbb.rs.

+6 Profil

Re: MySQL Server Uptime

^{12.10.2011. u 20:48 - pre 152 meseci}

Hvala na savetu. Logovao sam se na server da probam da nadjem verziju klijenta i vreme je sada (skoro) ok. Sada pokazuje nekih 5h uptime, iako mysql radi nekih 7 sati. Pogledacu sutra detaljnije u vezi toga. Da nisam iskopirao danas uptime, mislio bih da mi se samo ucinilo. Tako da ova tema moze i u brisanje :)

Inace, kako da vidm samo verziju mysql klijenta? Takodje u vezi klijenta, za instalaciju samo klijenta znam da postoji RMP mysql klijent paket, dok nisam nasao neki binary paket koji instalira samo klijent mysql (sada mi pade na pamet, da mozda ima opcija samo klijent/server).

Odgovor na temu

after
Ajvanho, ING

Član broj: 276962
Poruke: 97
*.dynamic.sbb.rs.

+6 Profil

Re: MySQL Server Uptime

^{12.10.2011. u 20:58 - pre 152 meseci}

Da li prvi deo output-a: mysqladmin Ver 8.42 Distrib 5.1.52, for redhat-linux-gnu on x86_64 pretstavlja client verziju (mysql/mysqladmin)?

Code:

[root@retc]# mysqladmin -u root -p version
Enter password:
mysqladmin  Ver 8.42 Distrib 5.1.52, for redhat-linux-gnu on x86_64
Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version          5.1.52
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:

Odgovor na temu

bogdan.kecman
Bogdan Kecman
"specialist"
Oracle
srbistan

Član broj: 201406
Poruke: 15887
*.31.24.217.adsl2.beograd.com.

Sajt: mysql.rs

+2377 Profil

Re: MySQL Server Uptime

^{13.10.2011. u 12:29 - pre 152 meseci}

najsigurniji nacin da vidis verziju server "show variables like 'version'" .. za klijent "$> mysql --version " pa pogledas dal su isti ...

arhimed
http://www.mysql.rs/ | http://elco.crsndoo.com/

Odgovor na temu