How to know the MySQL uptime from commandline


jugulinux

In some situations, we need to check the uptime for MySQL in your server. The following command will give you the MySQL version along with the uptime of MySQL process.

Method 1:

# mysqladmin  version


For example:

root@server [~]# mysqladmin version

mysqladmin Ver 8.42 Distrib 5.1.72, for unknown-linux-gnu on x86_64
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Server version 5.1.72-cll
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 5 days 1 hour 28 min 23 sec

Method II:

# mysqladmin  ver

For example:

#mysqladmin ver

mysqladmin Ver 8.42 Distrib 5.1.72, for unknown-linux-gnu on x86_64
Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

..

..

Server version 5.1.72-cll
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 5 days 1 hour 29 min 27 sec

Method III:

Switch into mysql and type s

For example:

View original post 95 more words