000

Well-Known Member
Jun 3, 2008
317
14
68
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:
Code:
[[email protected] ~]# mysqladmin processlist
+-------+------+-----------+----+---------+------+----------+------------------+
| Id    | User | Host      | db | Command | Time | State    | Info             |
+-------+------+-----------+----+---------+------+----------+------------------+
| 92639 | root | localhost |    | Query   | 0    | starting | show processlist |
+-------+------+-----------+----+---------+------+----------+------------------+
[[email protected] ~]#