How to find MySQL uptime from commandline
If you found this post helpful, kindly share it and show your support :)
You can use any of the below commands to find the MySQL uptime
- mysqladmin version or mysqladmin version | grep -i uptime
Example:
~]$ mysqladmin version
mysqladmin Ver 9.0 Distrib 5.5.68-MariaDB, for Linux on x86_64
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Server version 5.5.68-MariaDB
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 44 days 14 hours 9 min 24 sec
Threads: 5 Questions: 2566552 Slow queries: 0 Opens: 76 Flush tables: 2 Open tables: 101 Queries per second avg: 0.666
~]$ mysqladmin version | grep -i uptime
Uptime: 44 days 14 hours 15 min 29 sec- mysqladmin ver or mysqladmin ver | grep -i uptime
~]$ mysqladmin ver
mysqladmin Ver 9.0 Distrib 5.5.68-MariaDB, for Linux on x86_64
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Server version 5.5.68-MariaDB
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 44 days 14 hours 10 min 39 sec
Threads: 5 Questions: 2566596 Slow queries: 0 Opens: 76 Flush tables: 2 Open tables: 101 Queries per second avg: 0.666
~]$ mysqladmin ver | grep -i uptime
Uptime: 44 days 14 hours 14 min 53 sec- mysqladmin status
~]$ mysqladmin status
Uptime: 3852956 Threads: 1 Questions: 2566794 Slow queries: 0 Opens: 76 Flush tables: 2 Open tables: 101 Queries per second avg: 0.666Note :- Uptime is in seconds
