Sorry for my bad english...
Other services on the same machine, like phpbb, continue to work.
No particular application, cron or at process works in that moment.
Using the commando top, mysqld it uses more 90% of the processor, constant.
The only solution for geeklog is restart mysql.
Using the command "processlist" of the utility mysqladmin, during problem, this is the results:
Text Formatted Code
[ziopino:/Users/robrota] root# mysqladmin -u root -p processlist
Enter password:
+-------+-------------+-----------+----------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-------+-------------+-----------+----------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| 32225 | tevac_geek | localhost | geek2 | Query | 2 | Sending data | SELECT *,unix_timestamp(date) AS day FROM gl_stories WHERE (date <= NOW()) AND (draft_flag = 0) AND |
| 32226 | tevac_geek | localhost | geek2 | Query | 1 | Sending data | SELECT count(*) AS count FROM gl_stories WHERE (date <= NOW()) AND (draft_flag = 0) AND frontpage = |
| 32235 | tevac_geek | localhost | geek2 | Query | 71 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32238 | tevac_geek | localhost | geek2 | Query | 68 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32241 | tevac_geek | localhost | geek2 | Query | 19 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32263 | tevac_geek | localhost | geek2 | Query | 78 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32264 | tevac_geek | localhost | geek2 | Query | 48 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32267 | tevac_geek | localhost | geek2 | Query | 74 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32270 | tevac_geek | localhost | geek2 | Query | 22 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32271 | tevac_geek | localhost | geek2 | Query | 23 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32276 | tevac_geek | localhost | geek2 | Query | 8 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32283 | tevac_geek | localhost | geek2 | Query | 65 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32287 | tevac_geek | localhost | geek2 | Query | 75 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32296 | tevac_geek | localhost | geek2 | Query | 67 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32297 | tevac_geek | localhost | geek2 | Query | 77 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32300 | tevac_geek | localhost | geek2 | Query | 67 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32316 | tevac_geek | localhost | geek2 | Query | 37 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32319 | tevac_geek | localhost | geek2 | Query | 31 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32320 | tevac_geek | localhost | geek2 | Query | 15 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32326 | tevac_geek | localhost | geek2 | Query | 89 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32327 | tevac_geek | localhost | geek2 | Query | 53 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32328 | tevac_geek | localhost | geek2 | Query | 80 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32332 | tevac_geek | localhost | geek2 | Query | 62 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32334 | tevac_geek | localhost | geek2 | Query | 54 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32337 | tevac_geek | localhost | geek2 | Query | 56 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32339 | tevac_geek | localhost | geek2 | Query | 71 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32341 | tevac_geek | localhost | geek2 | Query | 46 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32342 | tevac_geek | localhost | geek2 | Query | 38 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32346 | tevac_geek | localhost | geek2 | Query | 39 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32347 | tevac_geek | localhost | geek2 | Query | 10 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32348 | tevac_geek | localhost | geek2 | Query | 22 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32349 | tevac_geek | localhost | geek2 | Query | 25 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32350 | tevac_geek | localhost | geek2 | Query | 25 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32352 | tevac_geek | localhost | geek2 | Query | 22 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32355 | tevac_geek | localhost | geek2 | Query | 8 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32356 | tevac_geek | localhost | geek2 | Query | 84 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32357 | tevac_geek | localhost | geek2 | Query | 73 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32360 | tevac_geek | localhost | geek2 | Query | 67 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32361 | tevac_geek | localhost | geek2 | Query | 59 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32363 | tevac_geek | localhost | geek2 | Query | 52 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32364 | tevac_geek | localhost | geek2 | Query | 47 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32365 | tevac_geek | localhost | geek2 | Query | 41 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32366 | tevac_geek | localhost | geek2 | Query | 40 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32367 | tevac_geek | localhost | geek2 | Query | 39 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32368 | tevac_geek | localhost | geek2 | Query | 38 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32369 | tevac_geek | localhost | geek2 | Query | 37 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32370 | tevac_geek | localhost | geek2 | Query | 30 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32371 | tevac_geek | localhost | geek2 | Query | 28 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32374 | tevac_geek | localhost | geek2 | Query | 25 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32375 | tevac_geek | localhost | geek2 | Query | 24 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32376 | tevac_geek | localhost | geek2 | Query | 23 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32378 | tevac_geek | localhost | geek2 | Query | 12 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32379 | tevac_geek | localhost | geek2 | Query | 9 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32380 | tevac_geek | localhost | geek2 | Query | 10 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32383 | tevac_geek | localhost | geek2 | Query | 7 | Sending data | SELECT ug_main_grp_id,grp_name FROM gl_group_assignments,gl_groups WHERE grp_id = ug_main_grp_id AND |
| 32384 | tevac_forum | localhost | tevacnew | Sleep | 1 | | |
| 32385 | tevac_forum | localhost | tevacnew | Query | 1 | Sending data | SELECT t.forum_id, t.topic_id, p.post_time
FROM phpbb_topics t, phpbb_posts p
WHERE p.post_i |
| 32386 | root | localhost | | Query | 0 | | show processlist |
+-------+-------------+-----------+----------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
I am not expert of mysql, I do not understand the problem. :-(