Apr 24 2014 
Support Center » Knowledgebase » Linux VPS » How do I check for the status of MySQL and what it is doing?
 How do I check for the status of MySQL and what it is doing?
Solution To check MySQL Status via WHM:

WHM -> Server Status -> CPU/Memory/Mysql Usage

Or you can check the MySQL usage using the command "mysqladmin status" and "mysqladmin processlist" using SSH.

root@host [~]# mysqladmin status
Uptime: 7947 Threads: 1 Questions: 48285 Slow queries: 9 Opens: 510 Flush tables: 1 Open tables: 92 Queries per second avg: 6.076


root@host [~]# mysqladmin processlist
+------+------+-----------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+------+-----------+----+---------+------+-------+------------------+
| 3485 | root | localhost | | Query | 0 | | show processlist |
+------+------+-----------+----+---------+------+-------+------------------+
root@host [~]#



Article Details
Article ID: 98
Created On: Jan 23 2009 05:44 PM

 This answer was helpful  This answer was not helpful

 Back
 Login [Lost Password] 
Email:
Password:
Remember Me:
 
 Search
 Article Options
Home | Register | Knowledgebase
Language:

Help Desk Software By Kayako eSupport v3.60.02