kushal
09-12-2013, 11:49 AM
Over my site I found that there has been a report of severe server load and I get the following errors over the log file:
| Id | User | Host | db | Command | Time | State | Info |
+-----+------------+-----------+----------------+---------+------+-------------------------------+------------------------------------------------------------------------------------------------------+
| 16 | basecaamp1 | localhost | -------- | Query | 5 | Waiting for table level lock | SELECT user.userid, user.username
FROM vb_user AS user
WHERE userid IN (54180) |
| 37 | basecaamp1 | localhost | -------------- | Sleep | 44 | | |
| 107 | basecaamp1 | localhost | --------------- | Sleep | 47 | | |
| 147 | basecaamp1 | localhost | k------------- | Query | 10 | Waiting for table level lock | SELECT bm.userid, bm.permissions, bm.type, user.username
FROM vb_blog_moderator AS bm
INNER JO |
The Server guys are reporting that MySQL is going to sleep often and therefore the server gets down.
Any help or pointer to topic would be appreciated.
| Id | User | Host | db | Command | Time | State | Info |
+-----+------------+-----------+----------------+---------+------+-------------------------------+------------------------------------------------------------------------------------------------------+
| 16 | basecaamp1 | localhost | -------- | Query | 5 | Waiting for table level lock | SELECT user.userid, user.username
FROM vb_user AS user
WHERE userid IN (54180) |
| 37 | basecaamp1 | localhost | -------------- | Sleep | 44 | | |
| 107 | basecaamp1 | localhost | --------------- | Sleep | 47 | | |
| 147 | basecaamp1 | localhost | k------------- | Query | 10 | Waiting for table level lock | SELECT bm.userid, bm.permissions, bm.type, user.username
FROM vb_blog_moderator AS bm
INNER JO |
The Server guys are reporting that MySQL is going to sleep often and therefore the server gets down.
Any help or pointer to topic would be appreciated.