Luis Manson Posted March 26, 2012 Posted March 26, 2012 Right now my server load is in 47..its an 8 core i7 and i have ~600 online users mysql shown in 3 consecutive runs mysql> SHOW PROCESSLIST; +---------+-----------------+-----------------+---------------------+---------+------+--------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+-----------------+-----------------+---------------------+---------+------+--------------------+------------------------------------------------------------------------------------------------------+ | 1462182 | dscvhfswt | localhost:31401 | dbdscvhfswt | Sleep | 351 | | NULL | | 1471348 | dscvhfswt | localhost:32882 | dbdscvhfswt | Sleep | 445 | | NULL | | 1474283 | DBForumUSR | localhost | myForumDB | Query | 128 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(197964 | | 1474288 | DBForumUSR | localhost | myForumDB | Query | 17 | init | INSERT INTO gareputation_cache (`app`,`type`,`type_id`,`rep_points`,`rep_like_cache`) VALUES('forums | | 1474298 | DBForumUSR | localhost | myForumDB | Sleep | 63 | | NULL | | 1474307 | DBForumUSR | localhost | myForumDB | Query | 53 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(120184 | | 1474309 | DBForumUSR | localhost | myForumDB | Query | 13 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(176043 | | 1474312 | DBForumUSR | localhost | myForumDB | Query | 66 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(509510 | | 1474315 | DBForumUSR | localhost | myForumDB | Query | 70 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(555194 | | 1474318 | DBForumUSR | localhost | myForumDB | Query | 75 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(567761 | | 1474319 | DBForumUSR | localhost | myForumDB | Query | 31 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(424239 | | 1474322 | DBForumUSR | localhost | myForumDB | Query | 83 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(443866 | | 1474325 | DBForumUSR | localhost | myForumDB | Query | 83 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(466236 | | 1474328 | DBForumUSR | localhost | myForumDB | Query | 71 | Locked | INSERT INTO gacore_item_markers (`item_key`,`item_member_id`,`item_app`,`item_last_update`,`item_las | | 1474339 | DBForumUSR | localhost | myForumDB | Query | 116 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(443866 | | 1474340 | DBForumUSR | localhost | myForumDB | Query | 122 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(280451 | | 1474341 | DBForumUSR | localhost | myForumDB | Query | 47 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(590346 | | 1474342 | DBForumUSR | localhost | myForumDB | Sleep | 9 | cleaning up | NULL | | 1474346 | DBForumUSR | localhost | myForumDB | Query | 71 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(9082,' | | 1474347 | DBForumUSR | localhost | myForumDB | Query | 129 | update | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(542266 | | 1474349 | DBForumUSR | localhost | myForumDB | Query | 71 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(523539 | | 1474350 | DBForumUSR | localhost | myForumDB | Query | 71 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(537208 | | 1474351 | DBForumUSR | localhost | myForumDB | Query | 71 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(520233 | | 1474356 | DBForumUSR | localhost | myForumDB | Query | 69 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(598934 | | 1474357 | DBForumUSR | localhost | myForumDB | Query | 71 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(502257 | | 1474359 | DBForumUSR | localhost | myForumDB | Query | 66 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(596650 | | 1474360 | DBForumUSR | localhost | myForumDB | Query | 79 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(1144,' | | 1474362 | DBForumUSR | localhost | myForumDB | Query | 70 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(60486, | | 1474364 | DBForumUSR | localhost | myForumDB | Sleep | 55 | cleaning up | NULL | | 1474368 | DBForumUSR | localhost | myForumDB | Sleep | 36 | cleaning up | NULL | | 1474369 | DBForumUSR | localhost | myForumDB | Query | 12 | statistics | SELECT t.*, t.title as topic_title, t.posts as topic_posts, t.last_post as topic_last_post,p.*,m.*,p | | 1474371 | DBForumUSR | localhost | myForumDB | Sleep | 139 | cleaning up | NULL | | 1474375 | DBForumUSR | localhost | myForumDB | Query | 71 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(199525 | | 1474376 | DBForumUSR | localhost | myForumDB | Query | 52 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(457002 | | 1474379 | DBForumUSR | localhost | myForumDB | Sleep | 71 | | NULL | | 1474380 | DBForumUSR | localhost | myForumDB | Query | 46 | Sending data | SELECT post, post_htmlstate FROM gaposts WHERE topic_id='39863' | | 1474381 | DBForumUSR | localhost | myForumDB | Query | 91 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(519289 | | 1474385 | DBForumUSR | localhost | myForumDB | Query | 47 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(529828 | | 1474386 | DBForumUSR | localhost | myForumDB | Query | 121 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(104636 | | 1474387 | DBForumUSR | localhost | myForumDB | Query | 101 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(284758 | | 1474388 | DBForumUSR | localhost | myForumDB | Query | 19 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(591882 | | 1474393 | DBForumUSR | localhost | myForumDB | Query | 21 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(519430 | | 1474394 | DBForumUSR | localhost | myForumDB | Query | 87 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(554961 | | 1474398 | DBForumUSR | localhost | myForumDB | Query | 97 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(24031, | | 1474399 | DBForumUSR | localhost | myForumDB | Query | 28 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(324729 | | 1474401 | DBForumUSR | localhost | myForumDB | Sleep | 158 | | NULL | | 1474402 | DBForumUSR | localhost | myForumDB | Sleep | 132 | cleaning up | NULL | | 1474403 | DBForumUSR | localhost | myForumDB | Query | 70 | logging slow query | SELECT t.*, t.title as topic_title, t.last_post as lastpost, t.last_poster_id as lastposter, t.last_ | | 1474407 | DBForumUSR | localhost | myForumDB | Query | 121 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(536689 | | 1474408 | DBForumUSR | localhost | myForumDB | Sleep | 71 | | NULL | | 1474409 | DBForumUSR | localhost | myForumDB | Query | 115 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(406101 | | 1474410 | DBForumUSR | localhost | myForumDB | Query | 12 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(428975 | | 1474411 | asas | localhost:33428 | betamyForumDB | Sleep | 8 | | NULL | | 1474412 | DBForumUSR | localhost | myForumDB | Sleep | 151 | | NULL | | 1474413 | c14sdfd | localhost | c14ssa | Query | 8 | statistics | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (186,187,188,190,210,220,264,375,38 | | 1474414 | DBForumUSR | localhost | myForumDB | Query | 74 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474416 | DBForumUSR | localhost | myForumDB | Query | 9 | closing tables | INSERT INTO gasearch_visitors (`date`,`member`,`engine`,`keywords`,`url`) VALUES(1332727677,'','Goog | | 1474418 | DBForumUSR | localhost | myForumDB | Query | 7 | NULL | NULL | | 1474419 | DBForumUSR | localhost | myForumDB | Sleep | 141 | cleaning up | NULL | | 1474420 | DBForumUSR | localhost | myForumDB | Sleep | 8 | cleaning up | NULL | | 1474421 | DBForumUSR | localhost | myForumDB | Query | 6 | NULL | NULL | | 1474422 | DBForumUSR | localhost | myForumDB | Query | 18 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474424 | DBForumUSR | localhost | myForumDB | Query | 74 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474426 | DBForumUSR | localhost | myForumDB | Query | 77 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474427 | DBForumUSR | localhost | myForumDB | Sleep | 155 | | NULL | | 1474428 | DBForumUSR | localhost | myForumDB | Sleep | 8 | cleaning up | NULL | | 1474429 | DBForumUSR | localhost | myForumDB | Query | 52 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474430 | DBForumUSR | localhost | myForumDB | Sleep | 42 | | NULL | | 1474431 | DBForumUSR | localhost | myForumDB | Query | 141 | update | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474433 | DBForumUSR | localhost | myForumDB | Query | 62 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474434 | DBForumUSR | localhost | myForumDB | Sleep | 194 | | NULL | | 1474435 | DBForumUSR | localhost | myForumDB | Query | 7 | NULL | NULL | | 1474436 | DBForumUSR | localhost | myForumDB | Query | 58 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474437 | DBForumUSR | localhost | myForumDB | Sleep | 139 | cleaning up | NULL | | 1474438 | DBForumUSR | localhost | myForumDB | Query | 60 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474439 | DBForumUSR | localhost | myForumDB | Query | 7 | NULL | NULL | | 1474442 | DBForumUSR | localhost | myForumDB | Query | 60 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474443 | DBForumUSR | localhost | myForumDB | Query | 27 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474444 | DBForumUSR | localhost | myForumDB | Query | 105 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474445 | c14asasd | localhost | asdasd | Sleep | 118 | | NULL | | 1474446 | DBForumUSR | localhost | myForumDB | Sleep | 151 | cleaning up | NULL | | 1474449 | DBForumUSR | localhost | myForumDB | Query | 57 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474448 | DBForumUSR | localhost | myForumDB | Query | 89 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474450 | DBForumUSR | localhost | myForumDB | Query | 78 | Sending data | SELECT * FROM gacore_item_markers WHERE item_member_id=25973 | | 1474451 | DBForumUSR | localhost | myForumDB | Sleep | 152 | | NULL | | 1474452 | DBForumUSR | localhost | myForumDB | Query | 32 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474453 | DBForumUSR | localhost | myForumDB | Query | 74 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474447 | DBForumUSR | localhost | myForumDB | Sleep | 22 | | NULL | | 1474455 | DBForumUSR | localhost | myForumDB | Query | 63 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474456 | DBForumUSR | localhost | myForumDB | Sleep | 15 | cleaning up | NULL | | 1474457 | DBForumUSR | localhost | myForumDB | Query | 22 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474459 | DBForumUSR | localhost | myForumDB | Query | 26 | update | INSERT INTO gasearch_keywords (keyword, count) VALUES ('liberar atrix', 1) ON DUPLICATE KEY UPDATE c | | 1474460 | DBForumUSR | localhost | myForumDB | Sleep | 217 | | NULL | | 1474461 | DBForumUSR | localhost | myForumDB | Sleep | 34 | | NULL | | 1474462 | DBForumUSR | localhost | myForumDB | Query | 68 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474463 | DBForumUSR | localhost | myForumDB | Sleep | 152 | | NULL | | 1474464 | DBForumUSR | localhost | myForumDB | Query | 57 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474466 | DBForumUSR | localhost | myForumDB | Query | 42 | Sending data | SELECT * FROM gacore_item_markers WHERE item_member_id=25973 | | 1474467 | DBForumUSR | localhost | myForumDB | Query | 27 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474468 | DBForumUSR | localhost | myForumDB | Query | 60 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474469 | DBForumUSR | localhost | myForumDB | Query | 53 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474465 | DBForumUSR | localhost | myForumDB | Query | 135 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474470 | DBForumUSR | localhost | myForumDB | Query | 118 | logging slow query | SELECT f.*,p.*,itemmarking.* FROM gaforums f LEFT JOIN gapermission_index p ON ( p.perm_type='forum | | 1474472 | c14sdf | localhost | c14sd | Sleep | 9 | cleaning up | NULL | | 1474473 | c14sdf | localhost | c14sd | Sleep | 138 | | NULL | | 1474475 | DBForumUSR | localhost | myForumDB | Query | 105 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474476 | DBForumUSR | localhost | myForumDB | Query | 4 | NULL | NULL | | 1474477 | DBForumUSR | localhost | myForumDB | Sleep | 75 | | NULL | | 1474478 | DBForumUSR | localhost | myForumDB | Query | 9 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474481 | DBForumUSR | localhost | myForumDB | Query | 121 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474482 | DBForumUSR | localhost | myForumDB | Query | 10 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474489 | sdsd | localhost | sdsdsd | Init DB | 8 | NULL | NULL | | 1474490 | DBForumUSR | localhost | myForumDB | Sleep | 15 | cleaning up | NULL | | 1474493 | DBForumUSR | localhost | myForumDB | Query | 53 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474494 | DBForumUSR | localhost | myForumDB | Query | 123 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474496 | DBForumUSR | localhost | myForumDB | Query | 47 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474497 | DBForumUSR | localhost | myForumDB | Query | 30 | Sending data | SELECT f.*,p.*,itemmarking.* FROM gaforums f LEFT JOIN gapermission_index p ON ( p.perm_type='forum | | 1474499 | c14dfdf | localhost | c14dfdf | Sleep | 81 | | NULL | | 1474500 | root | localhost | NULL | Query | 9 | NULL | SHOW PROCESSLIST | +---------+-----------------+-----------------+---------------------+---------+------+--------------------+------------------------------------------------------------------------------------------------------+ 119 rows in set (9.28 sec) mysql> kill 1474470; Query OK, 0 rows affected (0.00 sec) mysql> SHOW PROCESSLIST; +---------+-----------------+-----------------+-----------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+-----------------+-----------------+-----------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+ | 1462182 | dscvhfswt | localhost:31401 | dbdscvhfswt | Sleep | 423 | | NULL | | 1471348 | dscvhfswt | localhost:32882 | dbdscvhfswt | Sleep | 517 | | NULL | | 1474283 | DBForumUSR | localhost | myForumDB | Query | 34 | Locked | INSERT INTO gareputation_cache (`app`,`type`,`type_id`,`rep_points`,`rep_like_cache`) VALUES('forums | | 1474288 | DBForumUSR | localhost | myForumDB | Sleep | 89 | | NULL | | 1474298 | DBForumUSR | localhost | myForumDB | Query | 72 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(380850 | | 1474307 | DBForumUSR | localhost | myForumDB | Query | 125 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(120184 | | 1474309 | DBForumUSR | localhost | myForumDB | Query | 85 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(176043 | | 1474312 | DBForumUSR | localhost | myForumDB | Query | 138 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(509510 | | 1474315 | DBForumUSR | localhost | myForumDB | Query | 142 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(555194 | | 1474318 | DBForumUSR | localhost | myForumDB | Sleep | 147 | | NULL | | 1474319 | DBForumUSR | localhost | myForumDB | Query | 103 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(424239 | | 1474322 | DBForumUSR | localhost | myForumDB | Query | 34 | Locked | INSERT INTO gareputation_cache (`app`,`type`,`type_id`,`rep_points`,`rep_like_cache`) VALUES('forums | | 1474325 | DBForumUSR | localhost | myForumDB | Query | 31 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(471154 | | 1474328 | DBForumUSR | localhost | myForumDB | Query | 143 | Locked | INSERT INTO gacore_item_markers (`item_key`,`item_member_id`,`item_app`,`item_last_update`,`item_las | | 1474339 | DBForumUSR | localhost | myForumDB | Query | 34 | Locked | INSERT INTO gareputation_cache (`app`,`type`,`type_id`,`rep_points`,`rep_like_cache`) VALUES('forums | | 1474340 | DBForumUSR | localhost | myForumDB | Query | 49 | update | INSERT INTO gareputation_cache (`app`,`type`,`type_id`,`rep_points`,`rep_like_cache`) VALUES('forums | | 1474341 | DBForumUSR | localhost | myForumDB | Query | 119 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(590346 | | 1474342 | DBForumUSR | localhost | myForumDB | Query | 21 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(461317 | | 1474346 | DBForumUSR | localhost | myForumDB | Query | 143 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(9082,' | | 1474347 | DBForumUSR | localhost | myForumDB | Query | 3 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(542272 | | 1474349 | DBForumUSR | localhost | myForumDB | Query | 143 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(523539 | | 1474350 | DBForumUSR | localhost | myForumDB | Query | 143 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(537208 | | 1474351 | DBForumUSR | localhost | myForumDB | Query | 143 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(520233 | | 1474356 | DBForumUSR | localhost | myForumDB | Query | 141 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(598934 | | 1474357 | DBForumUSR | localhost | myForumDB | Query | 143 | update | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(502257 | | 1474359 | DBForumUSR | localhost | myForumDB | Query | 138 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(596650 | | 1474360 | DBForumUSR | localhost | myForumDB | Query | 15 | statistics | SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM gamembers m LEFT JOIN g | | 1474362 | DBForumUSR | localhost | myForumDB | Query | 142 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(60486, | | 1474364 | DBForumUSR | localhost | myForumDB | Query | 72 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(560949 | | 1474368 | DBForumUSR | localhost | myForumDB | Query | 68 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(270875 | | 1474369 | DBForumUSR | localhost | myForumDB | Query | 22 | Sending data | SELECT p.*,m.*,pp.* FROM gaposts p LEFT JOIN gamembers m ON ( m.member_id=p.author_id ) LEFT JOIN | | 1474371 | DBForumUSR | localhost | myForumDB | Query | 52 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(335435 | | 1474375 | DBForumUSR | localhost | myForumDB | Query | 143 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(199525 | | 1474376 | DBForumUSR | localhost | myForumDB | Query | 124 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(457002 | | 1474380 | DBForumUSR | localhost | myForumDB | Query | 118 | Sending data | SELECT post, post_htmlstate FROM gaposts WHERE topic_id='39863' | | 1474381 | DBForumUSR | localhost | myForumDB | Query | 2 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(519430 | | 1474385 | DBForumUSR | localhost | myForumDB | Query | 119 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(529828 | | 1474386 | DBForumUSR | localhost | myForumDB | Query | 49 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(104641 | | 1474387 | DBForumUSR | localhost | myForumDB | Query | 29 | Locked | INSERT INTO gareputation_cache (`app`,`type`,`type_id`,`rep_points`,`rep_like_cache`) VALUES('forums | | 1474388 | DBForumUSR | localhost | myForumDB | Query | 91 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(591882 | | 1474393 | DBForumUSR | localhost | myForumDB | Query | 93 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(519430 | | 1474394 | DBForumUSR | localhost | myForumDB | Query | 21 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(554962 | | 1474398 | DBForumUSR | localhost | myForumDB | Query | 14 | Locked | INSERT INTO gareputation_cache (`app`,`type`,`type_id`,`rep_points`,`rep_like_cache`) VALUES('forums | | 1474399 | DBForumUSR | localhost | myForumDB | Query | 100 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(324729 | | 1474401 | DBForumUSR | localhost | myForumDB | Query | 64 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(583109 | | 1474402 | DBForumUSR | localhost | myForumDB | Query | 40 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(590340 | | 1474403 | DBForumUSR | localhost | myForumDB | Query | 33 | Sending data | SELECT m.*, m.member_id as my_member_id,p.*,pp.*,g.*,ccb.cache_content FROM gamembers m LEFT JOIN g | | 1474407 | DBForumUSR | localhost | myForumDB | Query | 50 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(537030 | | 1474408 | DBForumUSR | localhost | myForumDB | Query | 69 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(595796 | | 1474409 | DBForumUSR | localhost | myForumDB | Query | 28 | Locked | INSERT INTO gareputation_cache (`app`,`type`,`type_id`,`rep_points`,`rep_like_cache`) VALUES('forums | | 1474410 | DBForumUSR | localhost | myForumDB | Query | 84 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(428975 | | 1474412 | DBForumUSR | localhost | myForumDB | Sleep | 14 | | NULL | | 1474413 | c14dffg | localhost | csjtrc | Query | 14 | statistics | SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN (220,186,210,190,264,187,384, | | 1474414 | DBForumUSR | localhost | myForumDB | Query | 146 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474419 | DBForumUSR | localhost | myForumDB | Sleep | 14 | | NULL | | 1474420 | DBForumUSR | localhost | myForumDB | Query | 56 | Locked | INSERT INTO gasearch_keywords (keyword, count) VALUES ('claro apk', 1) ON DUPLICATE KEY UPDATE count | | 1474421 | DBForumUSR | localhost | myForumDB | Sleep | 78 | | NULL | | 1474422 | DBForumUSR | localhost | myForumDB | Query | 90 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474424 | DBForumUSR | localhost | myForumDB | Query | 146 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474426 | DBForumUSR | localhost | myForumDB | Query | 149 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474427 | DBForumUSR | localhost | myForumDB | Sleep | 26 | | NULL | | 1474429 | DBForumUSR | localhost | myForumDB | Query | 124 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474430 | DBForumUSR | localhost | myForumDB | Query | 39 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474431 | DBForumUSR | localhost | myForumDB | Sleep | 0 | | NULL | | 1474433 | DBForumUSR | localhost | myForumDB | Query | 134 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474434 | DBForumUSR | localhost | myForumDB | Query | 2 | Writing to net | SELECT * FROM gaskin_cache WHERE cache_set_id=34 AND cache_type IN ('css', 'replacements') | | 1474436 | DBForumUSR | localhost | myForumDB | Query | 130 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474437 | DBForumUSR | localhost | myForumDB | Query | 34 | Locked | INSERT INTO gacache_store (`cs_array`,`cs_key`,`cs_value`,`cs_updated`,`cs_rebuild`) VALUES(1,'syste | | 1474438 | DBForumUSR | localhost | myForumDB | Query | 132 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474439 | DBForumUSR | localhost | myForumDB | Query | 79 | update | INSERT INTO gasearch_keywords (keyword, count) VALUES ('contactos blackberry a samsung ace', 1) ON D | | 1474442 | DBForumUSR | localhost | myForumDB | Query | 132 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474443 | DBForumUSR | localhost | myForumDB | Query | 99 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474444 | DBForumUSR | localhost | myForumDB | Query | 177 | update | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474445 | c14dffga | localhost | asjtrc | Sleep | 190 | | NULL | | 1474446 | DBForumUSR | localhost | myForumDB | Sleep | 3 | | NULL | | 1474449 | DBForumUSR | localhost | myForumDB | Query | 129 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474448 | DBForumUSR | localhost | myForumDB | Query | 161 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474450 | DBForumUSR | localhost | myForumDB | Query | 41 | Writing to net | SELECT f.*,p.*,itemmarking.* FROM gaforums f LEFT JOIN gapermission_index p ON ( p.perm_type='forum | | 1474451 | DBForumUSR | localhost | myForumDB | Query | 14 | logging slow query | UPDATE ganexus_ads SET ad_impressions=25663829 WHERE ad_id=2 | | 1474452 | DBForumUSR | localhost | myForumDB | Query | 104 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474453 | DBForumUSR | localhost | myForumDB | Query | 146 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474455 | DBForumUSR | localhost | myForumDB | Query | 135 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474456 | DBForumUSR | localhost | myForumDB | Query | 12 | Locked | INSERT INTO gasearch_keywords (keyword, count) VALUES ('actualizar lg gt540 android 2.1', 1) ON DUPL | | 1474457 | DBForumUSR | localhost | myForumDB | Query | 94 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474459 | DBForumUSR | localhost | myForumDB | Query | 34 | Locked | INSERT INTO gacache_store (`cs_array`,`cs_key`,`cs_value`,`cs_updated`,`cs_rebuild`) VALUES(1,'syste | | 1474460 | DBForumUSR | localhost | myForumDB | Query | 62 | Sending data | SELECT f.*,p.*,itemmarking.* FROM gaforums f LEFT JOIN gapermission_index p ON ( p.perm_type='forum | | 1474461 | DBForumUSR | localhost | myForumDB | Sleep | 34 | | NULL | | 1474462 | DBForumUSR | localhost | myForumDB | Query | 140 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474463 | DBForumUSR | localhost | myForumDB | Query | 3 | Locked | INSERT INTO gasearch_keywords (keyword, count) VALUES ('actualizar lg gt540 android 2.1', 1) ON DUPL | | 1474464 | DBForumUSR | localhost | myForumDB | Query | 129 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474466 | DBForumUSR | localhost | myForumDB | Query | 45 | Writing to net | SELECT f.*,p.*,itemmarking.* FROM gaforums f LEFT JOIN gapermission_index p ON ( p.perm_type='forum | | 1474467 | DBForumUSR | localhost | myForumDB | Query | 99 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474468 | DBForumUSR | localhost | myForumDB | Query | 132 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474469 | DBForumUSR | localhost | myForumDB | Query | 125 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474465 | DBForumUSR | localhost | myForumDB | Sleep | 14 | | NULL | | 1474473 | c14zenphoto | localhost | c14zenphoto | Sleep | 210 | | NULL | | 1474475 | DBForumUSR | localhost | myForumDB | Query | 177 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474476 | DBForumUSR | localhost | myForumDB | Query | 76 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474477 | DBForumUSR | localhost | myForumDB | Query | 47 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474478 | DBForumUSR | localhost | myForumDB | Query | 81 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474481 | DBForumUSR | localhost | myForumDB | Query | 4 | statistics | SELECT * FROM ganexus_ads WHERE ad_id=1 | | 1474482 | DBForumUSR | localhost | myForumDB | Query | 82 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474489 | dscvhfswt | localhost | dbdscvhfswt | Query | 22 | updating | DELETE FROM monitor_data WHERE type ='os_info' AND created < 1332727484 | | 1474490 | DBForumUSR | localhost | myForumDB | Sleep | 71 | | NULL | | 1474493 | DBForumUSR | localhost | myForumDB | Query | 125 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474494 | DBForumUSR | localhost | myForumDB | Sleep | 195 | | NULL | | 1474496 | DBForumUSR | localhost | myForumDB | Query | 119 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474497 | DBForumUSR | localhost | myForumDB | Query | 102 | Sending data | SELECT f.*,p.*,itemmarking.* FROM gaforums f LEFT JOIN gapermission_index p ON ( p.perm_type='forum | | 1474499 | c14dffgasjtrc | localhost | c14dffgasjtrc | Query | 13 | checking permissions | SHOW TABLES | | 1474500 | root | localhost | NULL | Query | 0 | NULL | SHOW PROCESSLIST | | 1474501 | dscvhfswt | localhost:33453 | dbdscvhfswt | Sleep | 16 | | NULL | | 1474502 | c14dffgasjtrc | localhost | c14dffgasjtrc | Sleep | 30 | | NULL | | 1474504 | DBForumUSR | localhost | myForumDB | Query | 30 | Sending data | SELECT * FROM gacache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navi | | 1474503 | c14dffgasjtrc | localhost | c14dffgasjtrc | Sleep | 22 | | NULL | | 1474505 | DBForumUSR | localhost | myForumDB | Query | 30 | Writing to net | SELECT * FROM gacache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navi | | 1474506 | dscvhfswt | localhost:33454 | dbdscvhfswt | Sleep | 22 | | NULL | | 1474507 | dscvhfswt | localhost:33455 | dbdscvhfswt | Sleep | 16 | | NULL | | 1474508 | DBForumUSR | localhost | myForumDB | Query | 5 | Sending data | SELECT * FROM gacache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navi | +---------+-----------------+-----------------+-----------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+ 118 rows in set (0.00 sec) mysql> SHOW PROCESSLIST; +---------+-----------------+-----------------+-----------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +---------+-----------------+-----------------+-----------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+ | 1462182 | dscvhfswt | localhost:31401 | dbdscvhfswt | Sleep | 498 | | NULL | | 1471348 | dscvhfswt | localhost:32882 | dbdscvhfswt | Sleep | 592 | | NULL | | 1474283 | DBForumUSR | localhost | myForumDB | Query | 62 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(198068 | | 1474288 | DBForumUSR | localhost | myForumDB | Query | 75 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(279105 | | 1474298 | DBForumUSR | localhost | myForumDB | Query | 147 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(380850 | | 1474307 | DBForumUSR | localhost | myForumDB | Sleep | 200 | cleaning up | NULL | | 1474309 | DBForumUSR | localhost | myForumDB | Query | 160 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(176043 | | 1474312 | DBForumUSR | localhost | myForumDB | Query | 16 | statistics | SELECT * FROM gacore_like_cache WHERE like_cache_id='ed273b7bba3ea3ca2247dd2e69f7733e' | | 1474315 | DBForumUSR | localhost | myForumDB | Query | 34 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(555332 | | 1474318 | DBForumUSR | localhost | myForumDB | Query | 73 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(567764 | | 1474319 | DBForumUSR | localhost | myForumDB | Query | 178 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(424239 | | 1474322 | DBForumUSR | localhost | myForumDB | Query | 56 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(443891 | | 1474325 | DBForumUSR | localhost | myForumDB | Query | 106 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(471154 | | 1474328 | DBForumUSR | localhost | myForumDB | Query | 218 | Locked | INSERT INTO gacore_item_markers (`item_key`,`item_member_id`,`item_app`,`item_last_update`,`item_las | | 1474339 | DBForumUSR | localhost | myForumDB | Query | 49 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(443891 | | 1474340 | DBForumUSR | localhost | myForumDB | Query | 38 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(280468 | | 1474341 | DBForumUSR | localhost | myForumDB | Query | 194 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(590346 | | 1474342 | DBForumUSR | localhost | myForumDB | Query | 96 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(461317 | | 1474346 | DBForumUSR | localhost | myForumDB | Query | 55 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(9088,' | | 1474347 | DBForumUSR | localhost | myForumDB | Query | 78 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(542272 | | 1474349 | DBForumUSR | localhost | myForumDB | Query | 45 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(524142 | | 1474350 | DBForumUSR | localhost | myForumDB | Query | 54 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(537921 | | 1474351 | DBForumUSR | localhost | myForumDB | Query | 51 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(520266 | | 1474356 | DBForumUSR | localhost | myForumDB | Query | 49 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(598948 | | 1474357 | DBForumUSR | localhost | myForumDB | Query | 48 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(502271 | | 1474359 | DBForumUSR | localhost | myForumDB | Query | 213 | logging slow query | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(596650 | | 1474360 | DBForumUSR | localhost | myForumDB | Query | 46 | logging slow query | SELECT tid, title, title_seo FROM gatopics WHERE forum_id=46 AND approved=1 | | 1474362 | DBForumUSR | localhost | myForumDB | Query | 53 | logging slow query | SELECT r.member_id, r.rep_rating,m.members_display_name, m.members_seo_name FROM gareputation_index | | 1474364 | DBForumUSR | localhost | myForumDB | Query | 147 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(560949 | | 1474368 | DBForumUSR | localhost | myForumDB | Query | 143 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(270875 | | 1474369 | DBForumUSR | localhost | myForumDB | Query | 26 | logging slow query | UPDATE gasearch_sessions SET session_updated=1332727796,session_data='a:1:{s:18:\"search_app_filters | | 1474371 | DBForumUSR | localhost | myForumDB | Query | 127 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(335435 | | 1474375 | DBForumUSR | localhost | myForumDB | Query | 53 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(199603 | | 1474376 | DBForumUSR | localhost | myForumDB | Query | 199 | update | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(457002 | | 1474380 | DBForumUSR | localhost | myForumDB | Query | 193 | logging slow query | SELECT post, post_htmlstate FROM gaposts WHERE topic_id='39863' | | 1474381 | DBForumUSR | localhost | myForumDB | Query | 77 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(519430 | | 1474385 | DBForumUSR | localhost | myForumDB | Query | 194 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(529828 | | 1474386 | DBForumUSR | localhost | myForumDB | Query | 124 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(104641 | | 1474387 | DBForumUSR | localhost | myForumDB | Query | 56 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(284927 | | 1474388 | DBForumUSR | localhost | myForumDB | Query | 166 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(591882 | | 1474393 | DBForumUSR | localhost | myForumDB | Query | 168 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(519430 | | 1474394 | DBForumUSR | localhost | myForumDB | Query | 96 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(554962 | | 1474398 | DBForumUSR | localhost | myForumDB | Query | 57 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(24058, | | 1474399 | DBForumUSR | localhost | myForumDB | Query | 175 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(324729 | | 1474401 | DBForumUSR | localhost | myForumDB | Query | 139 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(583109 | | 1474402 | DBForumUSR | localhost | myForumDB | Query | 115 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(590340 | | 1474403 | DBForumUSR | localhost | myForumDB | Query | 12 | closing tables | UPDATE gaccs_blocks SET block_cache_output='<div class=\'general_box\'>\r\n <h3>Ultimos temas del fo | | 1474407 | DBForumUSR | localhost | myForumDB | Query | 125 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(537030 | | 1474408 | DBForumUSR | localhost | myForumDB | Query | 144 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(595796 | | 1474409 | DBForumUSR | localhost | myForumDB | Query | 57 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(406156 | | 1474410 | DBForumUSR | localhost | myForumDB | Query | 159 | Locked | INSERT INTO gacontent_cache_posts (`cache_content_id`,`cache_content`,`cache_updated`) VALUES(428975 | | 1474412 | DBForumUSR | localhost | myForumDB | Query | 64 | Locked | INSERT INTO gacache_store (`cs_array`,`cs_key`,`cs_value`,`cs_updated`,`cs_rebuild`) VALUES(1,'syste | | 1474413 | c14dffgasjtrc | localhost | c14dffgasjtrc | Query | 45 | logging slow query | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (217,419) AND wp_posts.post_type = | | 1474414 | DBForumUSR | localhost | myForumDB | Query | 19 | Updating | UPDATE ganexus_ads SET ad_impressions=257909 WHERE ad_id=1 | | 1474419 | DBForumUSR | localhost | myForumDB | Query | 67 | Locked | INSERT INTO gasearch_keywords (keyword, count) VALUES ('no me anda la camara del samsung galaxy i900 | | 1474420 | DBForumUSR | localhost | myForumDB | Query | 131 | logging slow query | INSERT INTO gasearch_keywords (keyword, count) VALUES ('claro apk', 1) ON DUPLICATE KEY UPDATE count | | 1474421 | DBForumUSR | localhost | myForumDB | Query | 11 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474422 | DBForumUSR | localhost | myForumDB | Query | 165 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474424 | DBForumUSR | localhost | myForumDB | Query | 221 | logging slow query | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474426 | DBForumUSR | localhost | myForumDB | Query | 16 | logging slow query | SELECT * FROM gacache_store WHERE cs_key IN ( 'nexus_ads' ) | | 1474427 | DBForumUSR | localhost | myForumDB | Query | 54 | Locked | INSERT INTO gacache_store (`cs_array`,`cs_key`,`cs_value`,`cs_updated`,`cs_rebuild`) VALUES(1,'syste | | 1474429 | DBForumUSR | localhost | myForumDB | Query | 199 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474430 | DBForumUSR | localhost | myForumDB | Query | 114 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474431 | DBForumUSR | localhost | myForumDB | Query | 70 | Locked | INSERT INTO gacache_store (`cs_array`,`cs_key`,`cs_value`,`cs_updated`,`cs_rebuild`) VALUES(1,'syste | | 1474433 | DBForumUSR | localhost | myForumDB | Query | 209 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474434 | DBForumUSR | localhost | myForumDB | Query | 28 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474436 | DBForumUSR | localhost | myForumDB | Query | 205 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474437 | DBForumUSR | localhost | myForumDB | Query | 109 | Locked | INSERT INTO gacache_store (`cs_array`,`cs_key`,`cs_value`,`cs_updated`,`cs_rebuild`) VALUES(1,'syste | | 1474438 | DBForumUSR | localhost | myForumDB | Query | 207 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474439 | DBForumUSR | localhost | myForumDB | Sleep | 14 | cleaning up | NULL | | 1474442 | DBForumUSR | localhost | myForumDB | Query | 207 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474443 | DBForumUSR | localhost | myForumDB | Query | 174 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474444 | DBForumUSR | localhost | myForumDB | Query | 39 | logging slow query | SELECT * FROM ganexus_ads WHERE ad_id=1 | | 1474446 | DBForumUSR | localhost | myForumDB | Query | 42 | Locked | INSERT INTO gacache_store (`cs_array`,`cs_key`,`cs_value`,`cs_updated`,`cs_rebuild`) VALUES(1,'syste | | 1474449 | DBForumUSR | localhost | myForumDB | Query | 204 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474448 | DBForumUSR | localhost | myForumDB | Sleep | 236 | | NULL | | 1474450 | DBForumUSR | localhost | myForumDB | Query | 31 | Sending data | SELECT * FROM gaskin_cache WHERE cache_set_id=34 AND cache_type IN ('css', 'replacements') | | 1474451 | DBForumUSR | localhost | myForumDB | Query | 21 | logging slow query | INSERT INTO gasessions (`id`,`member_name`,`member_id`,`member_group`,`login_type`,`running_time`,`i | | 1474452 | DBForumUSR | localhost | myForumDB | Query | 179 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474453 | DBForumUSR | localhost | myForumDB | Query | 221 | update | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474455 | DBForumUSR | localhost | myForumDB | Query | 210 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474456 | DBForumUSR | localhost | myForumDB | Query | 87 | update | INSERT INTO gasearch_keywords (keyword, count) VALUES ('actualizar lg gt540 android 2.1', 1) ON DUPL | | 1474457 | DBForumUSR | localhost | myForumDB | Query | 169 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474459 | DBForumUSR | localhost | myForumDB | Query | 109 | Locked | INSERT INTO gacache_store (`cs_array`,`cs_key`,`cs_value`,`cs_updated`,`cs_rebuild`) VALUES(1,'syste | | 1474460 | DBForumUSR | localhost | myForumDB | Query | 137 | logging slow query | SELECT f.*,p.*,itemmarking.* FROM gaforums f LEFT JOIN gapermission_index p ON ( p.perm_type='forum | | 1474461 | DBForumUSR | localhost | myForumDB | Query | 72 | Locked | INSERT INTO gasearch_keywords (keyword, count) VALUES ('actualizar lg gt540 android 2.1', 1) ON DUPL | | 1474462 | DBForumUSR | localhost | myForumDB | Query | 215 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474463 | DBForumUSR | localhost | myForumDB | Query | 78 | Locked | INSERT INTO gasearch_keywords (keyword, count) VALUES ('actualizar lg gt540 android 2.1', 1) ON DUPL | | 1474464 | DBForumUSR | localhost | myForumDB | Query | 204 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474466 | DBForumUSR | localhost | myForumDB | Sleep | 120 | | NULL | | 1474467 | DBForumUSR | localhost | myForumDB | Query | 174 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474468 | DBForumUSR | localhost | myForumDB | Query | 207 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474469 | DBForumUSR | localhost | myForumDB | Query | 200 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474465 | DBForumUSR | localhost | myForumDB | Query | 17 | statistics | SELECT s.s_id, s_enable, s.s_items, s.s_align, s.s_sep, s.s_rotate,i.* FROM gadp3_adv_sections s LE | | 1474473 | c14zenphoto | localhost | c14zenphoto | Sleep | 285 | | NULL | | 1474475 | DBForumUSR | localhost | myForumDB | Query | 9 | statistics | SELECT * FROM gacache_store WHERE cs_key IN ( 'nexus_ads' ) | | 1474476 | DBForumUSR | localhost | myForumDB | Query | 151 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474477 | DBForumUSR | localhost | myForumDB | Query | 122 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474478 | DBForumUSR | localhost | myForumDB | Query | 156 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474481 | DBForumUSR | localhost | myForumDB | Query | 19 | logging slow query | UPDATE ganexus_ads SET ad_impressions=25663831 WHERE ad_id=2 | | 1474482 | DBForumUSR | localhost | myForumDB | Query | 157 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474489 | dscvhfswt | localhost | dbdscvhfswt | Query | 48 | logging slow query | INSERT INTO monitor_data (server_id, type, created, data, state) VALUES (1, 'ispc_info', 1332727772, | | 1474490 | DBForumUSR | localhost | myForumDB | Query | 35 | Locked | INSERT INTO gacache_store (`cs_array`,`cs_key`,`cs_value`,`cs_updated`,`cs_rebuild`) VALUES(1,'syste | | 1474493 | DBForumUSR | localhost | myForumDB | Query | 200 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474494 | DBForumUSR | localhost | myForumDB | Query | 52 | Locked | INSERT INTO gacache_store (`cs_array`,`cs_key`,`cs_value`,`cs_updated`,`cs_rebuild`) VALUES(1,'syste | | 1474496 | DBForumUSR | localhost | myForumDB | Query | 194 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474497 | DBForumUSR | localhost | myForumDB | Query | 25 | Locked | INSERT INTO gaerror_logs (`log_member`,`log_date`,`log_error`,`log_error_code`,`log_ip_address`,`log | | 1474499 | c14dffgasjtrc | localhost | c14dffgasjtrc | Sleep | 88 | | NULL | | 1474500 | root | localhost | NULL | Query | 5 | NULL | SHOW PROCESSLIST | | 1474502 | c14dffgasjtrc | localhost | c14dffgasjtrc | Query | 6 | Opening tables | SHOW TABLES | | 1474504 | DBForumUSR | localhost | myForumDB | Query | 105 | Sending data | SELECT * FROM gacache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navi | | 1474503 | c14dffgasjtrc | localhost | c14dffgasjtrc | Query | 14 | checking permissions | SHOW TABLES | | 1474505 | DBForumUSR | localhost | myForumDB | Query | 105 | Sending data | SELECT * FROM gacache_store WHERE cs_key IN ( 'systemvars','login_methods','vnums','app_cache','navi | | 1474508 | DBForumUSR | localhost | myForumDB | Query | 15 | statistics | SELECT * FROM gacore_item_markers WHERE item_member_id=90623 | | 1474509 | c14dffgasjtrc | localhost | c14dffgasjtrc | Query | 36 | checking permissions | SHOW TABLES | | 1474510 | dscvhfswt | localhost | dbdscvhfswt | Query | 40 | statistics | select * from web_traffic where hostname='itar.net' and traffic_date='2012-03-25' | +---------+-----------------+-----------------+-----------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+ 116 rows in set (4.46 sec) mysql> quit; any ideas where is this staring
Grumpy Posted March 26, 2012 Posted March 26, 2012 Looks like you're hitting huge table locks on your forum. (and my computer is lagging looking at your post...) Do you have alternative caching solutions setup? Like apc/memcached/xcache for your IPB?
Rhett Posted March 26, 2012 Posted March 26, 2012 Can you provide the output from "top" and also run "sar" and provide that output too Both ran from the command line.
Luis Manson Posted March 26, 2012 Author Posted March 26, 2012 well...after i found some bug in templates all seems to be stable... i had a "mixed collations" issue in the reputation tables
Recommended Posts
Archived
This topic is now archived and is closed to further replies.