How to find MySQL server uptime

Tutorials > Database Management Systems > MySQL > Tips And Tricks > How to find MySQL server uptime

You can use mysqladmin utility to find MySQL server's uptime. Run the following command from command line.

mysqladmin -u<user> -p<password> -h<host name/IP> version

Replace <user> with MySQL username, <password> with password (you can enter invisible password later by using -p only and entering password at the password prompt). The command above not only tells you server's version but also tells you server uptime.

Here is sample output from my server

> mysqladmin -uroot -p -hlocalhost  version
Enter password: ********
mysqladmin  Ver 8.41 Distrib 5.0.84, for Win32 on ia32
Copyright (C) 2000-2006 MySQL AB
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.0.84-community-nt
Protocol version        10
Connection              localhost via TCP/IP
TCP port                3306
Uptime:                 14 hours 39 min 25 sec

Threads: 9  Questions: 5109  Slow queries: 0  Opens: 47  Flush tables: 1  Open t
ables: 0  Queries per second avg: 0.097

Similar Tutorials:

• MySQL Performance Optimization Part I
• How to find all tables of a particular storage engine in MySQL
• Seeing indexes in a MySQL table
• MySQL table_cache, information_schema, and open files limit
• SQL: Union and Union All

Support Geeks Worldwide:

Link to us:

You can support us by putting a link to our website on your blog or website (code is below).

<a href="http://www.geeksww.com/">
Geeks Worldwide - Tutorials about Software Installation,
Configuration, Administration, Monitoring, Tools, Tips &
Tricks
</a>

OR a simple one.

<a href="http://www.geeksww.com/">
Geeks Worldwide - IT related Tutorials
</a>

Feedbacks:

We appreciate feedbacks and suggestions about our tutorials and Geeks Worldwide from readers. Please contact us using the form here and let us know what you think about the tutorial and the website in general.

Bookmark Us:

We are working on new features for the website, please keep visiting or bookmark us using your favourite bookmarking service.

Subscribe to RSS:

You can subscribe to our RSS feed here.