How to check mysql version/uptime

Check the mysql version,protocol version as well as mysql uptime to using the following command from the shell but you need to use server root login details to run the command from the shell.
[root@youknowlinux ~]mysqladmin -hlocalhost version
mysqladmin  Ver 8.42 Distrib 5.5.23, for Linux on x86_64
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.

Server version          5.5.23-55
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/lib/mysql/mysql.sock
Uptime:                 12 days 23 hours 54 min 3 sec

Threads: 14  Questions: 789066661  Slow queries: 1463  Opens: 2747102  Flush tables: 1  Open tables: 4096  Queries per second avg: 702.739

Bookmark the permalink.

Comments are closed.