| |
How to find MySQL server uptime
|
|
Tutorials >
Database Management Systems >
MySQL >
Tips And Tricks >
How to find MySQL server uptime
|
|
Discuss this tutorial here |
Search www.geeksww.com for more tutorials here
|
|
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
|
|
| |
|
Discuss this tutorial here |
Search www.geeksww.com for more tutorials here
|
| |
Similar Tutorials:
|
| |
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.
|
| |