Forum Subject: Serius problem with mysql and geeklog

Posted on: 02/10/04 06:07pm
By: roberto

Sorry for my bad english...

From a month approximately, geeklog it does not answer more,
approximately to the same hour, the 22-23:30 pm
G4 Dual Processor, Mac OS X 10.2.8, MySQL 4.0.12, PHP 4.3.0, Apache 1.3.29
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:

[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. :-(

Help me??

Tnx in advance
rob