Hi, Im new, but im hoping someone can help.
Im running mysql4.0.13 on FrreBSD 5.1-release. The problem is MySQL is using 95% of the cpu leaving 0% idle and pushing the load avg up to > 1. This is the output of mysqladmin processlist..
$ mysqladmin -uroot -p processlist;
Enter password:
+--------+------+-----------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+------+-----------+----+---------+------+-------+------------------+
| 387980 | root | localhost | | Query | 0 | | show processlist |
+--------+------+-----------+----+---------+------+-------+------------------+
$ uptime
8:51PM up 82 days, 5:18, 2 users, load averages: 1.03, 1.07, 1.23
I normally would expect a slow query or a table that requires optimisation, but without any hints from the processlist, where can i start looking?
Any help would be great!!
Im running mysql4.0.13 on FrreBSD 5.1-release. The problem is MySQL is using 95% of the cpu leaving 0% idle and pushing the load avg up to > 1. This is the output of mysqladmin processlist..
$ mysqladmin -uroot -p processlist;
Enter password:
+--------+------+-----------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+------+-----------+----+---------+------+-------+------------------+
| 387980 | root | localhost | | Query | 0 | | show processlist |
+--------+------+-----------+----+---------+------+-------+------------------+
$ uptime
8:51PM up 82 days, 5:18, 2 users, load averages: 1.03, 1.07, 1.23
I normally would expect a slow query or a table that requires optimisation, but without any hints from the processlist, where can i start looking?
Any help would be great!!
Comment