any other command to get diagnistic?, I only obtain: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.
Code:
[[email protected] ~]# mysqladmin processlist
+-------+------+-----------+----+---------+------+----------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+------+-----------+----+---------+------+----------+------------------+
| 92639 | root | localhost | | Query | 0 | starting | show processlist |
+-------+------+-----------+----+---------+------+----------+------------------+
[[email protected] ~]#