Welcome to Geeklog, Anonymous Friday, November 29 2024 @ 04:46 am EST
Geeklog Forums
Serius problem with mysql and geeklog
Status: offline
roberto
Forum User
Chatty
Registered: 12/01/03
Posts: 43
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
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:
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. :-(
Help me??
Tnx in advance
rob
6
7
Quote
All times are EST. The time is now 04:46 am.
- Normal Topic
- Sticky Topic
- Locked Topic
- New Post
- Sticky Topic W/ New Post
- Locked Topic W/ New Post
- View Anonymous Posts
- Able to post
- Filtered HTML Allowed
- Censored Content