MySQL Resource Usage
Hello :) I suggest using a command such as "mysqladmin processlist" when CPU usage is high to see if any specific databases or tables are responsible for the increase in resource usage. Thank you.
any other command to get diagnistic?, I only obtain:
[root@pepsi ~]# mysqladmin processlist
+-------+------+-----------+----+---------+------+----------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+------+-----------+----+---------+------+----------+------------------+
| 92639 | root | localhost | | Query | 0 | starting | show processlist |
+-------+------+-----------+----+---------+------+----------+------------------+
[root@pepsi ~]#Please sign in to leave a comment.
Comments
0 comments