Under 5.0.41 I have having problems of CPU sitting at exactly 100% load
on a single CPU for very long periods of time, like 10 hours.
I traced this command:
mysql> SHOW MUTEX STATUS;
Which returned 1281006 lines, ending with:
+-------------+------+----------+
| File | Line | OS_waits |
+-------------+------+----------+
...
...
| buf0buf.c | 497 | 0 |
| buf0buf.c | 494 | 0 |
| buf0buf.c | 497 | 0 |
| buf0buf.c | 494 | 0 |
| buf0buf.c | 545 | 1159932 |
| fil0fil.c | 1293 | 398 |
| srv0start.c | 1201 | 0 |
| srv0start.c | 1194 | 0 |
| srv0start.c | 1172 | 0 |
| dict0mem.c | 90 | 0 |
| dict0mem.c | 90 | 0 |
| srv0srv.c | 875 | 50886 |
| srv0srv.c | 872 | 113162 |
| thr0loc.c | 229 | 1 |
| mem0pool.c | 205 | 25482 |
| sync0sync.c | 1289 | 0 |
+-------------+------+----------+
(All other lines are as same as first two.)
Is there an InnoDB expert who can tell me whether this is indicating a
problem?
Regards,
Ben
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]