mysql> show innodb status\G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 090311 5:29:56 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 6 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1475108, signal count 1317434 Mutex spin waits 0, rounds 140737985, OS waits 1137073 RW-shared spins 129952, OS waits 53972; RW-excl spins 179691, OS waits 72118 ------------------------ LATEST DETECTED DEADLOCK ------------------------ 090311 3:51:58 *** (1) TRANSACTION: TRANSACTION 0 239776383, ACTIVE 5 sec, process no 26345, OS thread id 1181935952 starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 368, 1 row lock(s) MySQL thread id 1531153, query id 14484011 192.168.0.49 plurk-root Updating UPDATE `timelines_active` SET `response_count`=1 WHERE plurk_id=31974779 AND user_id=owner_id *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 171 page no 441899 n bits 704 index `plurk_user` of table `plurk_group013_tls`.`timelines_active` trx id 0 239776383 lock_mode X waiting Record lock, heap no 309 PHYSICAL RECORD: n_fields 4; compact format; info bits 0 0: len 4; hex 01e7e57b; asc {;; 1: len 4; hex 0032e68f; asc 2 ;; 2: len 8; hex 80001245a3da48f8; asc E H ;; 3: len 4; hex 01589e54; asc X T;; *** (2) TRANSACTION: TRANSACTION 0 239775796, ACTIVE 6 sec, process no 26345, OS thread id 1190586704 inserting, thread declared inside InnoDB 498 mysql tables in use 1, locked 1 3 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 3 MySQL thread id 1529856, query id 14482562 192.168.0.249 plurk-root update INSERT IGNORE INTO timelines_active (plurk_id, qualifier, content, posted, owner_id, limited_to, lang, no_comments, user_id, response_count, responses_seen, content_raw, is_unread, plurk_type) VALUES (31974779, "", null, "2009-03-11 03:51:28", 411020, null, null, 0, 3341343, 0, 0, null, 0, 0),(31974779, "", null, "2009-03-11 03:51:28", 411020, null, null, 0, 3335823, 0, 0, null, 0, 0),(31974779, "", null, "2009-03-11 03:51:28", 411020, null, null, 0, 3320533, 0, 0, null, 0, 0),(31974779, "", null, "2009-03-11 03:51:28", 411020, null, null, 0, 3317090, 0, 0, null, 0, 0),(31974779, "", null, "2009-03-11 03:51:28", 411020, null, null, 0, 3287801, 0, 0, null, 0, 0),(31974779, "", null, "2009-03-11 03:51:28", 411020, null, null, 0, 3251739, 0, 0, null, 0, 0),(31974779, "", null, "2009-03-11 03:51:28", 411020, null, null, 0, 3250805, 0, 0, null, 0, 0),(31974779, "", null, "2009-03-11 03:51:28", 411020, null, null, 0, 3235613, 0, 0, null, 0, *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 171 page no 441899 n bits 704 index `plurk_user` of table `plurk_group013_tls`.`timelines_active` trx id 0 239775796 lock_mode X locks rec but not gap Record lock, heap no 309 PHYSICAL RECORD: n_fields 4; compact format; info bits 0 0: len 4; hex 01e7e57b; asc {;; 1: len 4; hex 0032e68f; asc 2 ;; 2: len 8; hex 80001245a3da48f8; asc E H ;; 3: len 4; hex 01589e54; asc X T;; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 171 page no 441899 n bits 704 index `plurk_user` of table `plurk_group013_tls`.`timelines_active` trx id 0 239775796 lock_mode X locks gap before rec insert intention waiting Record lock, heap no 309 PHYSICAL RECORD: n_fields 4; compact format; info bits 0 0: len 4; hex 01e7e57b; asc {;; 1: len 4; hex 0032e68f; asc 2 ;; 2: len 8; hex 80001245a3da48f8; asc E H ;; 3: len 4; hex 01589e54; asc X T;; *** WE ROLL BACK TRANSACTION (1) ------------ TRANSACTIONS ------------ Trx id counter 0 250215864 Purge done for trx's n:o < 0 250215163 undo n:o < 0 0 History list length 18 ... truncated... 8.0.51 plurk statistics select * from users WHERE `id`=3338730 LIMIT 1 ---TRANSACTION 0 250215461, ACTIVE 622 sec, process no 26345, OS thread id 1081735504 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002897, query id 38025140 192.168.0.51 plurk statistics select * from users WHERE `id`=23283 LIMIT 1 Trx read view will not see trx with id >= 0 250215462, sees < 0 250215092 ---TRANSACTION 0 250215460, ACTIVE 622 sec, process no 26345, OS thread id 1168283984 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002896, query id 38025136 192.168.0.49 plurk statistics select * from users WHERE `id`=3187685 LIMIT 1 Trx read view will not see trx with id >= 0 250215461, sees < 0 250215092 ---TRANSACTION 0 250215459, ACTIVE 623 sec, process no 26345, OS thread id 1181665616 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002895, query id 38025132 192.168.0.49 plurk Sending data select COUNT(*) from notifications WHERE status in (0, -2) AND `to_uid`=3214251 LIMIT 1 Trx read view will not see trx with id >= 0 250215460, sees < 0 250215092 ---TRANSACTION 0 250215458, ACTIVE 624 sec, process no 26345, OS thread id 1178691920 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002894, query id 38025127 192.168.0.49 plurk-root statistics select * from timelines_keep WHERE `plurk_id`=31922423 AND `user_id`=18757 AND `owner_id`=18757 LIMIT 1 Trx read view will not see trx with id >= 0 250215459, sees < 0 250215092 ---TRANSACTION 0 250215457, ACTIVE 626 sec, process no 26345, OS thread id 1164769616 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002893, query id 38025122 192.168.0.49 plurk statistics select * from users WHERE `id`=3239077 LIMIT 1 Trx read view will not see trx with id >= 0 250215458, sees < 0 250215092 ---TRANSACTION 0 250215456, ACTIVE 632 sec, process no 26345, OS thread id 1082562896 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002891, query id 38025117 192.168.0.49 plurk statistics select * from users WHERE `id`=3163075 LIMIT 1 ---TRANSACTION 0 250215455, ACTIVE 633 sec, process no 26345, OS thread id 1171392848 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002890, query id 38025113 192.168.0.49 plurk-root Sending data select * from timelines_keep WHERE plurk_id IN (31955456,31915523,31948293,31877129,31914506,31875671,31751693,31885331,31917077,31928854,31747610,31784478,31763493,31903782,30963121,31775272,31917609,31966250,31892011,31976493,31848498,31839797,31928379,31733820,31748669,31974464,31907905,31958594,31895108,31855689,31777354,31743567,31798115,31914071,31968857,31936603,31800415,31914597,31902822,31887464,31730793,31917164,31811185,31869015,31758527,31877653,31950464,31893636,31944214,31904705,31783560,31906953,31825547,31961231,31723665,31971993,31891101,31750814,31910049,31849122,31896264,3 Trx read view will not see trx with id >= 0 250215456, sees < 0 250215092 ---TRANSACTION 0 250215454, ACTIVE 634 sec, process no 26345, OS thread id 1074071888 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002888, query id 38025104 192.168.0.51 plurk statistics select * from users WHERE `id`=3184320 LIMIT 1 Trx read view will not see trx with id >= 0 250215455, sees < 0 250215092 ---TRANSACTION 0 250215453, ACTIVE 636 sec, process no 26345, OS thread id 1086650704 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002887, query id 38025100 192.168.0.49 plurk statistics select * from users WHERE `id`=3279586 LIMIT 1 Trx read view will not see trx with id >= 0 250215454, sees < 0 250215092 ---TRANSACTION 0 250215452, ACTIVE 639 sec, process no 26345, OS thread id 1084123472 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002885, query id 38025092 192.168.0.51 plurk statistics select * from users WHERE `id`=755120 LIMIT 1 Trx read view will not see trx with id >= 0 250215453, sees < 0 250215092 ---TRANSACTION 0 250215451, ACTIVE 642 sec, process no 26345, OS thread id 1081506128 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002884, query id 38025088 192.168.0.49 plurk statistics select * from users WHERE `id`=176628 LIMIT 1 Trx read view will not see trx with id >= 0 250215452, sees < 0 250215092 ---TRANSACTION 0 250215450, ACTIVE 644 sec, process no 26345, OS thread id 1167472976 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002883, query id 38025084 192.168.0.49 plurk statistics select * from users WHERE id=3125366 LIMIT 1 Trx read view will not see trx with id >= 0 250215451, sees < 0 250215092 ---TRANSACTION 0 250215449, ACTIVE 644 sec, process no 26345, OS thread id 1163553104 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002882, query id 38025080 192.168.0.49 plurk-root Sending data select id, plurk_id, posted, user_id, owner_id, response_count, responses_seen, no_comments, is_unread, plurk_type from timelines_keep WHERE `plurk_id`=31988077 LIMIT 1 Trx read view will not see trx with id >= 0 250215450, sees < 0 250215092 ---TRANSACTION 0 250215448, ACTIVE 646 sec, process no 26345, OS thread id 1193019728 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002881, query id 38025075 192.168.0.49 plurk statistics select * from users WHERE `id`=4145 LIMIT 1 Trx read view will not see trx with id >= 0 250215449, sees < 0 250215092 ---TRANSACTION 0 250215447, ACTIVE 648 sec, process no 26345, OS thread id 1185450320 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002880, query id 38025071 192.168.0.50 plurk-root Sending data select id, plurk_id, posted, user_id, owner_id, response_count, responses_seen, no_comments, is_unread, plurk_type from timelines_keep WHERE `plurk_id`=31981519 LIMIT 1 Trx read view will not see trx with id >= 0 250215448, sees < 0 250215092 ---TRANSACTION 0 250215446, ACTIVE 651 sec, process no 26345, OS thread id 1160984912 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002879, query id 38025066 192.168.0.51 plurk statistics select * from users WHERE `id`=3185667 LIMIT 1 ---TRANSACTION 0 250215445, ACTIVE 653 sec, process no 26345, OS thread id 1087514960 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002878, query id 38025062 192.168.0.49 plurk statistics select * from users WHERE `id`=3353420 LIMIT 1 Trx read view will not see trx with id >= 0 250215446, sees < 0 250215092 ---TRANSACTION 0 250215444, ACTIVE 654 sec, process no 26345, OS thread id 1076808016 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002877, query id 38025058 192.168.0.51 plurk-root Sending data select * from timelines_keep WHERE posted > "2009-03-11 05:11:27" AND `user_id`=308140 order by posted DESC LIMIT 20 Trx read view will not see trx with id >= 0 250215445, sees < 0 250215092 ---TRANSACTION 0 250215443, ACTIVE 654 sec, process no 26345, OS thread id 1181935952 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002875, query id 38025053 192.168.0.49 plurk statistics select * from users WHERE `id`=3276589 LIMIT 1 ---TRANSACTION 0 250215442, ACTIVE 654 sec, process no 26345, OS thread id 1174907216 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002876, query id 38025052 192.168.0.49 plurk statistics select * from users WHERE `id`=3335962 LIMIT 1 Trx read view will not see trx with id >= 0 250215443, sees < 0 250215092 ---TRANSACTION 0 250215441, ACTIVE 656 sec, process no 26345, OS thread id 1178962256 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002874, query id 38025045 192.168.0.51 plurk statistics select * from users WHERE `id`=3374337 LIMIT 1 Trx read view will not see trx with id >= 0 250215442, sees < 0 250215092 ---TRANSACTION 0 250215440, ACTIVE 656 sec, process no 26345, OS thread id 1160714576 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002873, query id 38025041 192.168.0.49 plurk statistics select * from users WHERE `id`=1391445 LIMIT 1 Trx read view will not see trx with id >= 0 250215441, sees < 0 250215092 ---TRANSACTION 0 250215439, ACTIVE 662 sec, process no 26345, OS thread id 1188964688 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002872, query id 38025037 192.168.0.50 plurk statistics select * from users WHERE `id`=3142681 LIMIT 1 Trx read view will not see trx with id >= 0 250215440, sees < 0 250215092 ---TRANSACTION 0 250215438, ACTIVE 663 sec, process no 26345, OS thread id 1185044816 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002871, query id 38025033 192.168.0.49 plurk statistics select * from users WHERE `id`=3197926 LIMIT 1 Trx read view will not see trx with id >= 0 250215439, sees < 0 250215092 ---TRANSACTION 0 250215437, ACTIVE 663 sec, process no 26345, OS thread id 1188288848 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002870, query id 38025029 192.168.0.50 plurk statistics select * from users WHERE `id`=3383882 LIMIT 1 Trx read view will not see trx with id >= 0 250215438, sees < 0 250215092 ---TRANSACTION 0 250215436, ACTIVE 664 sec, process no 26345, OS thread id 1183828304 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002868, query id 38025021 192.168.0.49 plurk statistics select * from users WHERE `id`=3311894 LIMIT 1 Trx read view will not see trx with id >= 0 250215437, sees < 0 250215092 ---TRANSACTION 0 250215435, ACTIVE 666 sec, process no 26345, OS thread id 1189370192 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002867, query id 38025017 192.168.0.50 plurk statistics select * from users WHERE `id`=3269496 LIMIT 1 ---TRANSACTION 0 250215434, ACTIVE 667 sec, process no 26345, OS thread id 1186937168 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002866, query id 38025013 192.168.0.49 plurk statistics select * from users WHERE `id`=3156991 LIMIT 1 Trx read view will not see trx with id >= 0 250215435, sees < 0 250215092 ---TRANSACTION 0 250215433, ACTIVE 668 sec, process no 26345, OS thread id 1189099856 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002865, query id 38025009 192.168.0.51 plurk statistics select * from users WHERE `id`=3143202 LIMIT 1 Trx read view will not see trx with id >= 0 250215434, sees < 0 250215092 ---TRANSACTION 0 250215432, ACTIVE 671 sec, process no 26345, OS thread id 1075956048 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002864, query id 38025005 192.168.0.51 plurk-root Sending data select id, plurk_id, posted, user_id, owner_id, response_count, responses_seen, no_comments, is_unread, plurk_type from timelines_keep WHERE `plurk_id`=31899585 LIMIT 1 Trx read view will not see trx with id >= 0 250215433, sees < 0 250215092 ---TRANSACTION 0 250215431, ACTIVE 673 sec, process no 26345, OS thread id 1087109456 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002863, query id 38025000 192.168.0.49 plurk statistics select * from users WHERE `id`=3250562 LIMIT 1 ---TRANSACTION 0 250215430, ACTIVE 673 sec, process no 26345, OS thread id 1089960272 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002862, query id 38024996 192.168.0.51 plurk statistics select * from users WHERE `id`=31130 LIMIT 1 Trx read view will not see trx with id >= 0 250215431, sees < 0 250215092 ---TRANSACTION 0 250215429, ACTIVE 674 sec, process no 26345, OS thread id 1179908432 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002861, query id 38024992 192.168.0.49 plurk-root Sending data select id, plurk_id, posted, user_id, owner_id, response_count, responses_seen, no_comments, is_unread, plurk_type from timelines_keep WHERE `plurk_id`=31946759 LIMIT 1 Trx read view will not see trx with id >= 0 250215430, sees < 0 250215092 ---TRANSACTION 0 250215428, ACTIVE 674 sec, process no 26345, OS thread id 1183693136 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002860, query id 38024987 192.168.0.49 plurk-root Sending data select * from timelines_keep WHERE plurk_id IN (31962368,31574017,31971075,31985670,31743361,31974920,31895980,31972106,31971851,31912974,31798543,31981840,31977750,31982616,31977499,29389852,31985182,31978783,31955233,31957028,31957034,31973421,31981106,31978805,31982135,31974715,31964223,31950400,31945026,31958852,31981125,31988550,31928903,31983178,31947083,31974989,31959120,31914833,31918681,31983706,31940444,31956317,31749983,31972705,31682405,31980135,31827817,31987050,31934571,31942035,31979373,31977838,31980656,31965042,31932307,31934072,31974777,31970426,31968379,31932284,31980413,3 Trx read view will not see trx with id >= 0 250215429, sees < 0 250215092 ---TRANSACTION 0 250215427, ACTIVE 677 sec, process no 26345, OS thread id 1193560400 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002859, query id 38024982 192.168.0.49 plurk statistics select * from users WHERE `id`=3166718 LIMIT 1 ---TRANSACTION 0 250215426, ACTIVE 677 sec, process no 26345, OS thread id 1181124944 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002858, query id 38024978 192.168.0.50 plurk statistics select * from users WHERE `id`=3270108 LIMIT 1 ---TRANSACTION 0 250215425, ACTIVE 678 sec, process no 26345, OS thread id 1081870672 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002857, query id 38024974 192.168.0.50 plurk Sending data select COUNT(*) from notifications WHERE status in (0, -2) AND `to_uid`=3123993 LIMIT 1 Trx read view will not see trx with id >= 0 250215426, sees < 0 250215092 ---TRANSACTION 0 250215424, ACTIVE 681 sec, process no 26345, OS thread id 1187477840 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002856, query id 38024970 192.168.0.50 plurk statistics select * from users WHERE `id`=3292858 LIMIT 1 Trx read view will not see trx with id >= 0 250215425, sees < 0 250215092 ---TRANSACTION 0 250215423, ACTIVE 683 sec, process no 26345, OS thread id 1075206480 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002855, query id 38024966 192.168.0.49 plurk statistics select * from users WHERE `id`=3174087 LIMIT 1 ---TRANSACTION 0 250215422, ACTIVE 685 sec, process no 26345, OS thread id 1178556752 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002851, query id 38024948 192.168.0.51 plurk statistics select * from users WHERE `id`=3167578 LIMIT 1 Trx read view will not see trx with id >= 0 250215423, sees < 0 250215092 ---TRANSACTION 0 250215421, ACTIVE 687 sec, process no 26345, OS thread id 1088637264 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002850, query id 38024944 192.168.0.49 plurk statistics select * from users WHERE `id`=3159701 LIMIT 1 Trx read view will not see trx with id >= 0 250215422, sees < 0 250215092 ---TRANSACTION 0 250215420, ACTIVE 688 sec, process no 26345, OS thread id 1180854608 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002849, query id 38024940 192.168.0.51 plurk-root Sending data select id, plurk_id, posted, user_id, owner_id, response_count, responses_seen, no_comments, is_unread, plurk_type from timelines_keep WHERE `plurk_id`=31982424 AND `user_id`=673760 LIMIT 1 Trx read view will not see trx with id >= 0 250215421, sees < 0 250215092 ---TRANSACTION 0 250215419, ACTIVE 690 sec, process no 26345, OS thread id 1091361104 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002848, query id 38024935 192.168.0.51 plurk statistics select * from users WHERE `id`=432975 LIMIT 1 Trx read view will not see trx with id >= 0 250215420, sees < 0 250215092 ---TRANSACTION 0 250215418, ACTIVE 692 sec, process no 26345, OS thread id 1087650128 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002847, query id 38024931 192.168.0.50 plurk statistics select * from users WHERE `id`=3269695 LIMIT 1 ---TRANSACTION 0 250215417, ACTIVE 693 sec, process no 26345, OS thread id 1169500496 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002846, query id 38024927 192.168.0.49 plurk statistics select * from users WHERE `id`=3176736 LIMIT 1 Trx read view will not see trx with id >= 0 250215418, sees < 0 250215092 ---TRANSACTION 0 250215416, ACTIVE 694 sec, process no 26345, OS thread id 1074583888 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002844, query id 38024919 192.168.0.49 plurk statistics select * from users WHERE `id`=3199858 LIMIT 1 Trx read view will not see trx with id >= 0 250215417, sees < 0 250215092 ---TRANSACTION 0 250215415, ACTIVE 694 sec, process no 26345, OS thread id 1179232592 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002843, query id 38024915 192.168.0.49 plurk-root Sending data select * from timelines_keep WHERE plurk_id IN (31972106,31979631,31869834,31987050) AND `user_id`=13453 Trx read view will not see trx with id >= 0 250215416, sees < 0 250215092 ---TRANSACTION 0 250215414, ACTIVE 696 sec, process no 26345, OS thread id 1188694352 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002842, query id 38024910 192.168.0.50 plurk statistics select * from users WHERE `id`=3342353 LIMIT 1 Trx read view will not see trx with id >= 0 250215415, sees < 0 250215092 ---TRANSACTION 0 250215413, ACTIVE 697 sec, process no 26345, OS thread id 1192884560 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002841, query id 38024906 192.168.0.49 plurk statistics select * from users WHERE `id`=35531 LIMIT 1 Trx read view will not see trx with id >= 0 250215414, sees < 0 250215092 ---TRANSACTION 0 250215412, ACTIVE 702 sec, process no 26345, OS thread id 1090627920 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002840, query id 38024902 192.168.0.51 plurk statistics select * from users WHERE `id`=43809 LIMIT 1 ---TRANSACTION 0 250215411, ACTIVE 703 sec, process no 26345, OS thread id 1188153680 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002839, query id 38024898 192.168.0.49 plurk statistics select * from users WHERE `id`=132464 LIMIT 1 ---TRANSACTION 0 250215410, ACTIVE 705 sec, process no 26345, OS thread id 1190992208 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002838, query id 38024894 192.168.0.49 plurk Sending data select * from responses WHERE `plurk_id`=31939335 order by id Trx read view will not see trx with id >= 0 250215411, sees < 0 250215092 ---TRANSACTION 0 250215409, ACTIVE 705 sec, process no 26345, OS thread id 1173825872 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002837, query id 38024890 192.168.0.49 plurk-root Sending data select id, plurk_id, posted, user_id, owner_id, response_count, responses_seen, no_comments, is_unread, plurk_type from timelines_keep WHERE `plurk_id`=31977604 LIMIT 1 Trx read view will not see trx with id >= 0 250215410, sees < 0 250215092 ---TRANSACTION 0 250215408, ACTIVE 705 sec, process no 26345, OS thread id 1165039952 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002836, query id 38024885 192.168.0.49 plurk-root Sending data select * from timelines_keep WHERE plurk_id IN (31938051,31765510,31967751,31842312,31823020,31851020,31822861,31876624,31723096,31878674,31878676,31910427,31894558,31957028,31708197,31847974,31775272,31712725,31872555,31967790,31866745,31979568,31905843,31893563,31730237,31823934,31816257,31981068,31818826,31743055,31928891,31864404,31856725,31885398,31833341,31799896,31680402,31877220,31773804,31831662,31967347,31952404,31782525,31825023,31885441,31807619,31965830,31939720,31917164,30549646,31834255,31799441,31860371,31948142,31778971,31886495,31808368,31831715,31902375,31887016,31926956,3 Trx read view will not see trx with id >= 0 250215409, sees < 0 250215092 ---TRANSACTION 0 250215407, ACTIVE 705 sec, process no 26345, OS thread id 1087998288 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002835, query id 38024880 192.168.0.49 plurk-root Sending data select * from timelines_keep WHERE plurk_id IN (31855590,31915724,31824620,31986643,31917908,31642677,30869559,31629146,31862395,31988172) AND `user_id`=3351078 Trx read view will not see trx with id >= 0 250215408, sees < 0 250215092 ---TRANSACTION 0 250215406, ACTIVE 706 sec, process no 26345, OS thread id 1083705680 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002833, query id 38024871 192.168.0.49 plurk-root Sending data select * from timelines_keep WHERE plurk_id IN (31788803,31948548,31881734,31961609,31724043,31970061,31949073,31091218,31762222,31968790,31905817,31951131,31978629,31977760,31941409,31949090,30987302,31839019,31940651,31844403,31983160,31643193,31957563,31956031,31963974,31944267,31946062,31950733,31987280,31984211,31983188,31397620,31984470,31903578,31924060,31848798,31544420,31340901,30995302,31964012,31881599,31947905,31957014,31900807,31923052,31978381,31908845,31971729,31941781,31950743,31937182,31978283,31988138,31830444,31985839,31954352,31955634,31902649,31910591,31951553,31951814,3 Trx read view will not see trx with id >= 0 250215407, sees < 0 250215092 ---TRANSACTION 0 250215405, ACTIVE 706 sec, process no 26345, OS thread id 1162877264 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002832, query id 38024866 192.168.0.49 plurk-root Sending data select * from timelines_keep WHERE plurk_id IN (31917822,31979013,31912456,31962121,31974410,31956495,31812573,31932444,31966238,31966752,31940130,31963685,31980461,31887914,31869484,31980077,31932974,31944239,31934512,31911988,31874142,31789111,31965244,31902986,31903806,31865408,31969860,29764168,31930441,31791692,31803472,31872594,31976532,31888990,31978768,31899747,31979621,31783019,31827053,31920240,31884401,31957113,31732860,31966845,31796862,31951487,31890050,31973507,31936651,31848574,31919246,31846548,31957654,31949465,31899291,31779997,31916702,31838881,31963761,31961372,31911085,3 Trx read view will not see trx with id >= 0 250215406, sees < 0 250215092 ---TRANSACTION 0 250215404, ACTIVE 706 sec, process no 26345, OS thread id 1166256464 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002831, query id 38024861 192.168.0.49 plurk statistics select * from users WHERE `id`=3115158 LIMIT 1 ---TRANSACTION 0 250215403, ACTIVE 706 sec, process no 26345, OS thread id 1186666832 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002830, query id 38024857 192.168.0.49 plurk-root Sending data select * from timelines_keep WHERE plurk_id IN (31977984,31975339,31325701,31893510,31960071,31947272,31864841,31979020,31983629,31847950,31961615,31987365,31966228,31975963,31978757,31836710,31956520,31964718,31956016,31988273,31773234,31982259,31971384,31982139,31987261,31986238,31922239,31891530,31975501,31984719,31983696,31965265,31986772,31969294,31850582,31969880,31987295,31980642,31965283,31882852,31977579,31947372,31938670,31977584,31962737,31984242,31982707,31980660,31347317,31984148,31982714,31945854,31754944,31891076,31637125,31962759,31950474,31868109,31983245,31575703,31897753,3 Trx read view will not see trx with id >= 0 250215404, sees < 0 250215092 ---TRANSACTION 0 250215402, ACTIVE 707 sec, process no 26345, OS thread id 1191938384 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002829, query id 38024852 192.168.0.50 plurk statistics select * from users WHERE `id`=30500 LIMIT 1 Trx read view will not see trx with id >= 0 250215403, sees < 0 250215092 ---TRANSACTION 0 250215401, ACTIVE 707 sec, process no 26345, OS thread id 1078045008 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002828, query id 38024848 192.168.0.49 plurk statistics select * from users WHERE `id`=3208066 LIMIT 1 ---TRANSACTION 0 250215400, ACTIVE 707 sec, process no 26345, OS thread id 1160579408 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002827, query id 38024844 192.168.0.51 plurk statistics select * from users WHERE `id`=3311734 LIMIT 1 Trx read view will not see trx with id >= 0 250215401, sees < 0 250215092 ---TRANSACTION 0 250215399, ACTIVE 708 sec, process no 26345, OS thread id 1089689936 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002826, query id 38024838 192.168.0.49 plurk-root Sending data select * from timelines_keep WHERE plurk_id IN (31678628,31967095,31982172,31681260,31870007) AND `user_id`=3214270 Trx read view will not see trx with id >= 0 250215400, sees < 0 250215092 ---TRANSACTION 0 250215398, ACTIVE 709 sec, process no 26345, OS thread id 1187883344 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002824, query id 38024828 192.168.0.49 plurk statistics select * from users WHERE `id`=1079100 LIMIT 1 Trx read view will not see trx with id >= 0 250215399, sees < 0 250215092 ---TRANSACTION 0 250215397, ACTIVE 709 sec, process no 26345, OS thread id 1180313936 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002823, query id 38024824 192.168.0.49 plurk statistics select * from users WHERE `id`=3250933 LIMIT 1 ---TRANSACTION 0 250215396, ACTIVE 709 sec, process no 26345, OS thread id 1187072336 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002822, query id 38024820 192.168.0.49 plurk statistics select * from users WHERE id=196048 LIMIT 1 Trx read view will not see trx with id >= 0 250215397, sees < 0 250215092 ---TRANSACTION 0 250215395, ACTIVE 710 sec, process no 26345, OS thread id 1080207696 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002821, query id 38024816 192.168.0.49 plurk statistics select * from users WHERE `id`=3360874 LIMIT 1 Trx read view will not see trx with id >= 0 250215396, sees < 0 250215092 ---TRANSACTION 0 250215394, ACTIVE 710 sec, process no 26345, OS thread id 1075652944 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002820, query id 38024812 192.168.0.49 plurk-root Sending data select id, plurk_id, posted, user_id, owner_id, response_count, responses_seen, no_comments, is_unread, plurk_type from timelines_keep WHERE `plurk_id`=31955730 LIMIT 1 Trx read view will not see trx with id >= 0 250215395, sees < 0 250215092 ---TRANSACTION 0 250215393, ACTIVE 710 sec, process no 26345, OS thread id 1177475408 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002818, query id 38024802 192.168.0.249 plurk Sending data select * from friends WHERE `friend_with`=485766 AND `following_tl`=1 Trx read view will not see trx with id >= 0 250215394, sees < 0 250215092 ---TRANSACTION 0 250215392, ACTIVE 710 sec, process no 26345, OS thread id 1171933520 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002817, query id 38024798 192.168.0.50 plurk Sending data select COUNT(*) from notifications WHERE status in (0, -2) AND `to_uid`=3262704 LIMIT 1 Trx read view will not see trx with id >= 0 250215393, sees < 0 250215092 ---TRANSACTION 0 250215391, ACTIVE 710 sec, process no 26345, OS thread id 1182071120 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002816, query id 38024793 192.168.0.51 plurk Sending data select * from responses WHERE `plurk_id`=31981725 order by id Trx read view will not see trx with id >= 0 250215392, sees < 0 250215092 ---TRANSACTION 0 250215390, ACTIVE 710 sec, process no 26345, OS thread id 1077733712 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002815, query id 38024789 192.168.0.50 plurk-root Sending data select * from timelines_keep WHERE posted > "2009-03-11 02:19:23" AND `user_id`=3234832 order by posted DESC LIMIT 20 Trx read view will not see trx with id >= 0 250215391, sees < 0 250215092 ---TRANSACTION 0 250215389, ACTIVE 710 sec, process no 26345, OS thread id 1173285200 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002814, query id 38024784 192.168.0.49 plurk-root Sending data select * from timelines_keep WHERE posted > "2009-03-11 05:13:33" AND `user_id`=3479123 order by posted DESC LIMIT 20 Trx read view will not see trx with id >= 0 250215390, sees < 0 250215092 ---TRANSACTION 0 250215388, ACTIVE 710 sec, process no 26345, OS thread id 1189775696 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002813, query id 38024779 192.168.0.51 plurk statistics select * from users WHERE `id`=3115350 LIMIT 1 ---TRANSACTION 0 250215387, ACTIVE 710 sec, process no 26345, OS thread id 1184639312 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002812, query id 38024764 192.168.0.51 plurk Sending data select * from responses WHERE `plurk_id`=31986963 order by id Trx read view will not see trx with id >= 0 250215388, sees < 0 250215092 ---TRANSACTION 0 250215386, ACTIVE 710 sec, process no 26345, OS thread id 1188424016 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002725, query id 38024759 192.168.0.51 plurk-root Sending data select * from timelines_active WHERE plurk_id IN (31988418) AND `user_id`=3248191 Trx read view will not see trx with id >= 0 250215387, sees < 0 250215092 ---TRANSACTION 0 250215384, ACTIVE 710 sec, process no 26345, OS thread id 1076537680, thread declared inside InnoDB 499 mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1 MySQL thread id 4002772, query id 38024632 192.168.0.50 plurk end UPDATE users SET last_visit=UTC_TIMESTAMP() WHERE id=3313441 ---TRANSACTION 0 250215381, ACTIVE 710 sec, process no 26345, OS thread id 1077193040 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002733, query id 38024756 192.168.0.50 plurk-root Sending data select * from timelines_active WHERE posted > "2009-03-11 04:58:27" AND `user_id`=3491657 order by posted DESC LIMIT 20 ---TRANSACTION 0 250215379, ACTIVE 710 sec, process no 26345, OS thread id 1081370960 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002728, query id 38024755 192.168.0.51 plurk statistics select * from settings WHERE `user_id`=159032 LIMIT 1 Trx read view will not see trx with id >= 0 250215380, sees < 0 250215092 ---TRANSACTION 0 250215374, ACTIVE 710 sec, process no 26345, OS thread id 1174501712 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002811, query id 38024754 192.168.0.51 plurk-root Sending data select id, plurk_id, posted, user_id, owner_id, response_count, responses_seen, no_comments, is_unread, plurk_type from timelines_keep WHERE `plurk_id`=31904319 AND `user_id`=22917 LIMIT 1 Trx read view will not see trx with id >= 0 250215375, sees < 0 250215092 ---TRANSACTION 0 250215373, ACTIVE 710 sec, process no 26345, OS thread id 1175583056 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002810, query id 38024749 192.168.0.49 plurk statistics select COUNT(*) from blocks WHERE `block_uid`=3420602 AND `uid`=3274794 LIMIT 1 Trx read view will not see trx with id >= 0 250215374, sees < 0 250215092 ---TRANSACTION 0 250215372, ACTIVE 710 sec, process no 26345, OS thread id 1170581840 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002809, query id 38024745 192.168.0.50 plurk-root Sending data select id, plurk_id, posted, user_id, owner_id, response_count, responses_seen, no_comments, is_unread, plurk_type from timelines_keep WHERE `plurk_id`=31875343 AND `user_id`=3482432 LIMIT 1 Trx read view will not see trx with id >= 0 250215373, sees < 0 250215092 ---TRANSACTION 0 250215371, ACTIVE 710 sec, process no 26345, OS thread id 1170041168 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002808, query id 38024740 192.168.0.49 plurk statistics select * from users WHERE `id`=3162059 LIMIT 1 ---TRANSACTION 0 250215370, ACTIVE 710 sec, process no 26345, OS thread id 1189640528 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002807, query id 38024736 192.168.0.50 plurk statistics select * from users WHERE `id`=3373139 LIMIT 1 Trx read view will not see trx with id >= 0 250215371, sees < 0 250215092 ---TRANSACTION 0 250215369, ACTIVE 710 sec, process no 26345, OS thread id 1168013648 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002805, query id 38024727 192.168.0.249 plurk Sending data select * from friends WHERE `friend_with`=3152646 AND `following_tl`=1 Trx read view will not see trx with id >= 0 250215370, sees < 0 250215092 ---TRANSACTION 0 250215368, ACTIVE 710 sec, process no 26345, OS thread id 1184368976 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002804, query id 38024723 192.168.0.50 plurk statistics select COUNT(*) from blocks WHERE `block_uid`=3284123 AND `uid`=3221745 LIMIT 1 Trx read view will not see trx with id >= 0 250215369, sees < 0 250215092 ---TRANSACTION 0 250215367, ACTIVE 710 sec, process no 26345, OS thread id 1190181200 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002732, query id 38024718 192.168.0.51 plurk statistics select COUNT(*) from blocks WHERE `block_uid`=3232804 AND `uid`=3374726 LIMIT 1 Trx read view will not see trx with id >= 0 250215368, sees < 0 250215092 ---TRANSACTION 0 250215366, ACTIVE 710 sec, process no 26345, OS thread id 1178827088 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002731, query id 38024715 192.168.0.51 plurk-root Sending data select * from timelines_active WHERE plurk_id IN (31809826,31982883) AND `user_id`=3486471 ---TRANSACTION 0 250215365, ACTIVE 710 sec, process no 26345, OS thread id 1176664400 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002803, query id 38024714 192.168.0.51 plurk-root Sending data select * from timelines_keep WHERE posted > "2009-03-11 05:12:42" AND `user_id`=3488015 order by posted DESC LIMIT 20 Trx read view will not see trx with id >= 0 250215366, sees < 0 250215092 ---TRANSACTION 0 250215364, ACTIVE 710 sec, process no 26345, OS thread id 1164904784 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002802, query id 38024709 192.168.0.49 plurk-root Sending data select * from timelines_keep WHERE plurk_id IN (31422518) AND `user_id`=3169741 Trx read view will not see trx with id >= 0 250215365, sees < 0 250215092 ---TRANSACTION 0 250215363, ACTIVE 710 sec, process no 26345, OS thread id 1191262544 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002800, query id 38024699 192.168.0.50 plurk-root Sending data select * from timelines_keep WHERE posted > "2009-03-11 05:04:47" AND `user_id`=3456387 order by posted DESC LIMIT 20 Trx read view will not see trx with id >= 0 250215364, sees < 0 250215092 ---TRANSACTION 0 250215362, ACTIVE 710 sec, process no 26345, OS thread id 1192073552 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002799, query id 38024694 192.168.0.50 plurk-root Sending data select * from timelines_keep WHERE posted > "2009-03-11 05:12:56" AND `user_id`=3356187 order by posted DESC LIMIT 20 Trx read view will not see trx with id >= 0 250215363, sees < 0 250215092 ---TRANSACTION 0 250215361, ACTIVE 710 sec, process no 26345, OS thread id 1076992336 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002798, query id 38024689 192.168.0.249 plurk-root Sending data select id, plurk_id, posted, user_id, owner_id, response_count, responses_seen, no_comments, is_unread, plurk_type from timelines_keep WHERE `plurk_id`=31981796 LIMIT 1 Trx read view will not see trx with id >= 0 250215362, sees < 0 250215092 ---TRANSACTION 0 250215360, ACTIVE 710 sec, process no 26345, OS thread id 1078720848 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002797, query id 38024688 192.168.0.50 plurk-root Sending data select * from timelines_keep WHERE posted > "2009-03-11 05:05:51" AND `user_id`=3247581 order by posted DESC LIMIT 20 Trx read view will not see trx with id >= 0 250215361, sees < 0 250215092 ---TRANSACTION 0 250215359, ACTIVE 710 sec, process no 26345, OS thread id 1080502608 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002795, query id 38024676 192.168.0.51 plurk statistics select COUNT(*) from blocks WHERE `block_uid`=3165353 AND `uid`=3165353 LIMIT 1 Trx read view will not see trx with id >= 0 250215360, sees < 0 250215092 ---TRANSACTION 0 250215358, ACTIVE 710 sec, process no 26345, OS thread id 1169770832 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002756, query id 38024671 192.168.0.49 plurk Sending data select * from responses WHERE `plurk_id`=31984017 order by id Trx read view will not see trx with id >= 0 250215359, sees < 0 250215092 ---TRANSACTION 0 250215357, ACTIVE 710 sec, process no 26345, OS thread id 1170311504 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002794, query id 38024670 192.168.0.51 plurk statistics select COUNT(*) from blocks WHERE `block_uid`=3454465 AND `uid`=1592745 LIMIT 1 Trx read view will not see trx with id >= 0 250215358, sees < 0 250215092 ---TRANSACTION 0 250215356, ACTIVE 710 sec, process no 26345, OS thread id 1180719440 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002709, query id 38024669 192.168.0.51 plurk Sending data select COUNT(*) from notifications WHERE status in (0, -2) AND `to_uid`=3489405 LIMIT 1 Trx read view will not see trx with id >= 0 250215357, sees < 0 250215092 ---TRANSACTION 0 250215355, ACTIVE 710 sec, process no 26345, OS thread id 1175312720 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002640, query id 38024665 192.168.0.49 plurk-root statistics select * from timelines_keep WHERE `plurk_id`=31982618 AND `user_id`=3185180 AND `owner_id`=3185180 LIMIT 1 Trx read view will not see trx with id >= 0 250215356, sees < 0 250215092 ---TRANSACTION 0 250215354, ACTIVE 710 sec, process no 26345, OS thread id 1190046032 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002789, query id 38024663 192.168.0.51 plurk statistics select * from settings WHERE `user_id`=481968 LIMIT 1 Trx read view will not see trx with id >= 0 250215355, sees < 0 250215092 ---TRANSACTION 0 250215353, ACTIVE 710 sec, process no 26345, OS thread id 1181800784 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002779, query id 38024662 192.168.0.50 plurk statistics select * from settings WHERE `user_id`=3134302 LIMIT 1 Trx read view will not see trx with id >= 0 250215354, sees < 0 250215092 ---TRANSACTION 0 250215352, ACTIVE 710 sec, process no 26345, OS thread id 1167337808 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002780, query id 38024661 192.168.0.51 plurk statistics select * from settings WHERE `user_id`=3145514 LIMIT 1 Trx read view will not see trx with id >= 0 250215353, sees < 0 250215092 ---TRANSACTION 0 250215351, ACTIVE 710 sec, process no 26345, OS thread id 1167202640 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002793, query id 38024659 192.168.0.49 plurk statistics select COUNT(*) from friends WHERE `friend_with`=919332 AND `only_fan`=0 AND `user_id`=303687 LIMIT 1 Trx read view will not see trx with id >= 0 250215352, sees < 0 250215092 ---TRANSACTION 0 250215350, ACTIVE 710 sec, process no 26345, OS thread id 1162066256 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002775, query id 38024658 192.168.0.49 plurk statistics select * from settings WHERE `user_id`=821424 LIMIT 1 Trx read view will not see trx with id >= 0 250215351, sees < 0 250215092 ---TRANSACTION 0 250215349, ACTIVE 710 sec, process no 26345, OS thread id 1089554768 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002783, query id 38024657 192.168.0.51 plurk statistics select * from users WHERE `id`=3248082 LIMIT 1 ---TRANSACTION 0 250215348, ACTIVE 710 sec, process no 26345, OS thread id 1178016080 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002774, query id 38024656 192.168.0.50 plurk statistics select * from settings WHERE `user_id`=3193314 LIMIT 1 Trx read view will not see trx with id >= 0 250215349, sees < 0 250215092 ---TRANSACTION 0 250215347, ACTIVE 710 sec, process no 26345, OS thread id 1165850960 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002782, query id 38024655 192.168.0.51 plurk statistics select COUNT(*) from friends WHERE `friend_with`=3167923 AND `following_tl`=1 AND `user_id`=3167923 LIMIT 1 Trx read view will not see trx with id >= 0 250215348, sees < 0 250215092 ---TRANSACTION 0 250215346, ACTIVE 710 sec, process no 26345, OS thread id 1191803216 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002787, query id 38024653 192.168.0.50 plurk-root Sending data select * from timelines_active WHERE plurk_id IN (31988688) AND `user_id`=3327371 Trx read view will not see trx with id >= 0 250215347, sees < 0 250215092 ---TRANSACTION 0 250215345, ACTIVE 710 sec, process no 26345, OS thread id 1090763088 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002730, query id 38024651 192.168.0.49 plurk-root Sending data select id, plurk_id, posted, user_id, owner_id, response_count, responses_seen, no_comments, is_unread, plurk_type from timelines_active WHERE `plurk_id`=31916809 AND `user_id`=3178141 LIMIT 1 ---TRANSACTION 0 250215344, ACTIVE 710 sec, process no 26345, OS thread id 1084258640 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002771, query id 38024648 192.168.0.49 plurk statistics select * from settings WHERE `user_id`=254208 LIMIT 1 Trx read view will not see trx with id >= 0 250215345, sees < 0 250215092 ---TRANSACTION 0 250215343, ACTIVE 710 sec, process no 26345, OS thread id 1191127376 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002788, query id 38024647 192.168.0.50 plurk-root Sending data select id, plurk_id, posted, user_id, owner_id, response_count, responses_seen, no_comments, is_unread, plurk_type from timelines_active WHERE `plurk_id`=31976697 AND `user_id`=3124395 LIMIT 1 ---TRANSACTION 0 250215341, ACTIVE 710 sec, process no 26345, OS thread id 1172744528 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002785, query id 38024642 192.168.0.51 plurk-root Sending data select * from timelines_active WHERE posted > "2009-03-11 04:22:20" AND `user_id`=3182900 order by posted DESC LIMIT 20 Trx read view will not see trx with id >= 0 250215342, sees < 0 250215092 ---TRANSACTION 0 250215340, ACTIVE 710 sec, process no 26345, OS thread id 1090095440 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002773, query id 38024634 192.168.0.51 plurk-root Sending data select id, plurk_id, posted, user_id, owner_id, response_count, responses_seen, no_comments, is_unread, plurk_type from timelines_active WHERE `plurk_id`=31973240 AND `user_id`=3225380 LIMIT 1 Trx read view will not see trx with id >= 0 250215341, sees < 0 250215092 ---TRANSACTION 0 250215339, ACTIVE 710 sec, process no 26345, OS thread id 1183017296 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002763, query id 38024633 192.168.0.50 plurk statistics select * from settings WHERE `user_id`=3157770 LIMIT 1 Trx read view will not see trx with id >= 0 250215340, sees < 0 250215092 ---TRANSACTION 0 250215337, ACTIVE 710 sec, process no 26345, OS thread id 1078315344 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002776, query id 38024636 192.168.0.50 plurk-root Sending data select * from timelines_active WHERE plurk_id IN (31925859) AND `user_id`=3474274 Trx read view will not see trx with id >= 0 250215338, sees < 0 250215092 ---TRANSACTION 0 250215336, ACTIVE 710 sec, process no 26345, OS thread id 1091901776 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002692, query id 38024640 192.168.0.51 plurk-root statistics select * from timelines_keep WHERE `plurk_id`=31983041 AND `user_id`=232708 AND `owner_id`=232708 LIMIT 1 Trx read view will not see trx with id >= 0 250215337, sees < 0 250215092 ---TRANSACTION 0 250215335, ACTIVE 710 sec, process no 26345, OS thread id 1192479056 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002792, query id 38024638 192.168.0.49 plurk-root Sending data select * from timelines_keep WHERE plurk_id IN (31878373,31885638,31941703,31900076,31977612,31934676,31677365,31330840,31962196,31954362,31896442,31750399) AND `user_id`=3345779 Trx read view will not see trx with id >= 0 250215336, sees < 0 250215092 ---TRANSACTION 0 250215333, ACTIVE 710 sec, process no 26345, OS thread id 1164228944 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002781, query id 38024630 192.168.0.50 plurk-root Sending data select * from timelines_active WHERE posted > "2009-03-11 03:45:32" AND `user_id`=3203967 order by posted DESC LIMIT 20 ---TRANSACTION 0 250215332, ACTIVE 710 sec, process no 26345, OS thread id 1083337040 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002759, query id 38024628 192.168.0.50 plurk Sending data select * from notifications WHERE from_uid=2161005 AND to_uid=2161005 AND `n_type`=0 LIMIT 1 Trx read view will not see trx with id >= 0 250215333, sees < 0 250215092 ---TRANSACTION 0 250215331, ACTIVE 710 sec, process no 26345, OS thread id 1164634448 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002768, query id 38024627 192.168.0.51 plurk-root Sending data select * from timelines_active WHERE posted > "2009-03-11 05:07:10" AND `user_id`=3253119 order by posted DESC LIMIT 20 Trx read view will not see trx with id >= 0 250215332, sees < 0 250215092 ---TRANSACTION 0 250215330, ACTIVE 710 sec, process no 26345, OS thread id 1177340240 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002769, query id 38024626 192.168.0.49 plurk-root Sending data select * from timelines_active WHERE plurk_id IN (31968825,31895630) AND `user_id`=213034 Trx read view will not see trx with id >= 0 250215331, sees < 0 250215092 ---TRANSACTION 0 250215329, ACTIVE 710 sec, process no 26345, OS thread id 1185990992 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002577, query id 38024625 192.168.0.51 plurk-root statistics select * from timelines_keep WHERE `plurk_id`=28204833 AND `user_id`=3372845 AND `owner_id`=3372845 LIMIT 1 Trx read view will not see trx with id >= 0 250215330, sees < 0 250215092 ---TRANSACTION 0 250215328, ACTIVE 710 sec, process no 26345, OS thread id 1184098640 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002766, query id 38024623 192.168.0.49 plurk-root Sending data select * from timelines_active WHERE plurk_id IN (31984784,31988874,31973027,31988391,31988111) AND `user_id`=869865 ---TRANSACTION 0 250215327, ACTIVE 710 sec, process no 26345, OS thread id 1173555536 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002684, query id 38024616 192.168.0.49 plurk Sending data select * from notifications WHERE from_uid=3471797 AND to_uid=3471797 AND `n_type`=0 LIMIT 1 Trx read view will not see trx with id >= 0 250215328, sees < 0 250215092 ---TRANSACTION 0 250215326, ACTIVE 710 sec, process no 26345, OS thread id 1161795920 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002770, query id 38024617 192.168.0.49 plurk-root Sending data select * from timelines_active WHERE plurk_id IN (31968461) AND `user_id`=357292 Trx read view will not see trx with id >= 0 250215327, sees < 0 250215092 ---TRANSACTION 0 250215315, ACTIVE 710 sec, process no 26345, OS thread id 1188559184, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 1 lock struct(s), heap size 368, 0 row lock(s), undo log entries 1 MySQL thread id 4002583, query id 38024355 192.168.0.249 plurk-root update INSERT IGNORE INTO timelines_active (plurk_id, qualifier, content, posted, owner_id, limited_to, lang, no_comments, user_id, response_count, responses_seen, content_raw, is_unread, plurk_type) VALUES (31988939, "", null, "2009-03-11 05:17:50", 315105, null, null, 0, 3317478, 0, 0, null, 0, 0) ---TRANSACTION 0 250215308, ACTIVE 710 sec, process no 26345, OS thread id 1186261328 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002791, query id 38024595 192.168.0.249 plurk Sending data select * from friends WHERE `friend_with`=3125541 AND `following_tl`=1 Trx read view will not see trx with id >= 0 250215309, sees < 0 250214931 ---TRANSACTION 0 250215298, ACTIVE 710 sec, process no 26345, OS thread id 1193695568 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002786, query id 38024565 192.168.0.49 plurk Sending data select * from responses WHERE `plurk_id`=31986352 order by id Trx read view will not see trx with id >= 0 250215299, sees < 0 250214821 ---TRANSACTION 0 250215296, ACTIVE 710 sec, process no 26345, OS thread id 1078991184 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002784, query id 38024555 192.168.0.49 plurk-root Sending data select * from timelines_keep WHERE posted > "2009-03-11 04:56:34" AND `user_id`=3477217 order by posted DESC LIMIT 20 Trx read view will not see trx with id >= 0 250215297, sees < 0 250214821 ---TRANSACTION 0 250215268, ACTIVE 710 sec, process no 26345, OS thread id 1162471760, thread declared inside InnoDB 498 mysql tables in use 1, locked 1 4 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 1 MySQL thread id 4002657, query id 38024426 192.168.0.51 plurk-root end UPDATE timelines_active SET responses_seen=12, is_unread=0 WHERE user_id=3124395 AND plurk_id=31976697 AND is_unread != 2 ---TRANSACTION 0 250215263, ACTIVE 710 sec, process no 26345, OS thread id 1170852176, thread declared inside InnoDB 499 mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1 MySQL thread id 4002757, query id 38024407 192.168.0.50 plurk end UPDATE `users` SET `last_seen_plurk`=31946622 WHERE `id`=3480099 ---TRANSACTION 0 250215251, ACTIVE 710 sec, process no 26345, OS thread id 1164499280, thread declared inside InnoDB 499 mysql tables in use 1, locked 1 1 lock struct(s), heap size 368, 0 row lock(s), undo log entries 2 MySQL thread id 4002598, query id 38024383 192.168.0.249 plurk-root update INSERT IGNORE INTO timelines_active (plurk_id, qualifier, content, posted, owner_id, limited_to, lang, no_comments, user_id, response_count, responses_seen, content_raw, is_unread, plurk_type) VALUES (31988938, "", null, "2009-03-11 05:17:50", 204036, null, null, 0, 3135430, 0, 0, null, 0, 0),(31988938, "", null, "2009-03-11 05:17:50", 204036, null, null, 0, 273588, 0, 0, null, 0, 0) ---TRANSACTION 0 250215246, ACTIVE 710 sec, process no 26345, OS thread id 1092348240 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002681, query id 38024369 192.168.0.49 plurk-root Sending data select * from timelines_active WHERE posted > "2009-03-11 05:11:25" AND `user_id`=3118246 order by posted DESC LIMIT 20 Trx read view will not see trx with id >= 0 250215247, sees < 0 250214821 ---TRANSACTION 0 250215243, ACTIVE 710 sec, process no 26345, OS thread id 1171528016, thread declared inside InnoDB 499 mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1 MySQL thread id 4002747, query id 38024316 192.168.0.51 plurk end UPDATE `users` SET `response_count`=`response_count`+(1) WHERE `id`=3175912 ---TRANSACTION 0 250215241, ACTIVE 710 sec, process no 26345, OS thread id 1086785872 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002685, query id 38024353 192.168.0.51 plurk-root Sending data select * from timelines_active WHERE plurk_id IN (31979971,31985047) AND `user_id`=328495 Trx read view will not see trx with id >= 0 250215242, sees < 0 250214821 ---TRANSACTION 0 250215240, ACTIVE 710 sec, process no 26345, OS thread id 1160444240, thread declared inside InnoDB 498 mysql tables in use 1, locked 1 1 lock struct(s), heap size 368, 0 row lock(s), undo log entries 3 MySQL thread id 4002575, query id 38024211 192.168.0.249 plurk-root update INSERT IGNORE INTO timelines_active (plurk_id, qualifier, content, posted, owner_id, limited_to, lang, no_comments, user_id, response_count, responses_seen, content_raw, is_unread, plurk_type) VALUES (31988937, "", null, "2009-03-11 05:17:50", 3192547, null, null, 0, 3252423, 0, 0, null, 0, 0),(31988937, "", null, "2009-03-11 05:17:50", 3192547, null, null, 0, 3217766, 0, 0, null, 0, 0),(31988937, "", null, "2009-03-11 05:17:50", 3192547, null, null, 0, 3192177, 0, 0, null, 0, 0) ---TRANSACTION 0 250215237, ACTIVE 710 sec, process no 26345, OS thread id 1091631440, thread declared inside InnoDB 499 mysql tables in use 1, locked 1 2 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1 MySQL thread id 4002662, query id 38024351 192.168.0.50 plurk end UPDATE users SET last_visit=UTC_TIMESTAMP() WHERE id=3471705 ---TRANSACTION 0 250215223, ACTIVE 710 sec, process no 26345, OS thread id 1078856016 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002749, query id 38024327 192.168.0.49 plurk Sending data select * from responses WHERE `plurk_id`=31986476 order by id Trx read view will not see trx with id >= 0 250215242, sees < 0 250214821 ---TRANSACTION 0 250215214, ACTIVE 710 sec, process no 26345, OS thread id 1172474192 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002739, query id 38024287 192.168.0.49 plurk-root Sending data select * from timelines_keep WHERE plurk_id IN (31596556,31945743,31911440,31957014,31947287,31968285,31728158,31876134,31987239,31440425,31964718,31873075,31555124,31974982,31883198,31734540,31944267,31800908,31970061,31879011,31983188,31937109,31963736,31967835,31800421,31956066,31882852,31973477,31896169,31894636,31818514,31873134,31886959,31950321,31579765,31879800,31852668,31945861,31964295,31847560,31616108,31837328,31974548,31890069,31897753,31442075,31937182,31974049,31966371,31960518,31976102,31980199,31567302,31947036,31882413,31985839,31966896,31807665,31972533,31667894,31944646,3 Trx read view will not see trx with id >= 0 250215215, sees < 0 250214821 ---TRANSACTION 0 250215157, ACTIVE 710 sec, process no 26345, OS thread id 1187748176 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002654, query id 38024205 192.168.0.49 plurk-root Sending data select * from timelines_active WHERE plurk_id IN (31892736,31580930,31050500,31688454,31284234,29994763,30036238,30027279,30412308,30084153,31126041,31855387,29884720,31575077,31672614,30168359,31054381,31325486,31207215,30287920,30433073,30007602,31553331,30188596,31147870,31316537,30666554,31062843,30240010,29852990,29888066,30024930,30607696,30397368,30451026,30033251,30202287,31167033,31416665,30344634,29744222,30651743,30102114,30867043,30615014,30086252,31167086,31111535,30281841,30300274,31867506,30199676,29963389,31580799,30450049,31086472,29998734,29993359,31079058,28080531,30644116 ---TRANSACTION 0 250215133, ACTIVE 711 sec, process no 26345, OS thread id 1074448720 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002706, query id 38024070 192.168.0.49 plurk-root Sending data select * from timelines_keep WHERE plurk_id IN (31262720,30938626,31361541,31869958,31176961,30937098,30711902,30803479,31590938,30566575,31116378,31194459,31346725,31329318,31343659,31908912,30756404,31000158,31894583,30786105,31547453,30907573,31069248,31517765,30636102,31614538,30835788,30767696,31384146,30739543,30754905,31257178,31194203,30590045,31941726,31555680,30094435,30907492,31751782,31972971,31268463,30738033,31662196,31130741,31250038,30676964,30531194,31530621,31912574,30502527,31518343,30742665,31523466,31285387,30764172,31255221,30689219,31454868,31868055,31256728,31301785,3 Trx read view will not see trx with id >= 0 250215134, sees < 0 250214821 ---TRANSACTION 0 250215126, ACTIVE 711 sec, process no 26345, OS thread id 1162201424 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002696, query id 38024024 192.168.0.51 plurk-root Sending data select id, plurk_id, posted, user_id, owner_id, response_count, responses_seen, no_comments, is_unread, plurk_type from timelines_keep WHERE `user_id`=3122923 order by posted DESC LIMIT 22 Trx read view will not see trx with id >= 0 250215127, sees < 0 250214821 ---TRANSACTION 0 250215094, ACTIVE 711 sec, process no 26345, OS thread id 1174366544 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002658, query id 38023848 192.168.0.51 plurk-root Sending data select id, plurk_id, posted, user_id, owner_id, response_count, responses_seen, no_comments, is_unread, plurk_type from timelines_keep WHERE `user_id`=24589 order by posted DESC LIMIT 22 Trx read view will not see trx with id >= 0 250215095, sees < 0 250214821 ---TRANSACTION 0 250215092, ACTIVE 711 sec, process no 26345, OS thread id 1076672848 waiting in InnoDB queue mysql tables in use 1, locked 0 MySQL thread id 4002596, query id 38023838 192.168.0.49 plurk-root Sending data select id, plurk_id, posted, user_id, owner_id, response_count, responses_seen, no_comments, is_unread, plurk_type from timelines_keep WHERE `user_id`=3119767 order by posted DESC LIMIT 10, 10 Trx read view will not see trx with id >= 0 250215093, sees < 0 250214821 -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: complete io for buf page (read thread) ev set I/O thread 3 state: waiting for i/o request (write thread) Pending normal aio reads: 18, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2752205 OS file reads, 1593425 OS file writes, 211001 OS fsyncs 217.36 reads/s, 25096 avg bytes/read, 602.08 writes/s, 103.18 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 49313, free list len 157651, seg size 206965, 1757211 inserts, 4328154 merged recs, 287522 merges Hash table size 48874589, node heap has 21863 buffer(s) 0.00 hash searches/s, 4483.92 non-hash searches/s --- LOG --- Log sequence number 55 2649870734 Log flushed up to 55 2649862763 Last checkpoint at 55 2649855940 0 pending log writes, 0 pending chkp writes 30145 log i/o's done, 34.99 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 27214695360; in additional pool allocated 1048576 Dictionary memory allocated 1358664 Buffer pool size 1507328 Free buffers 0 Database pages 1485465 Modified db pages 37 Pending reads 20 Pending writes: LRU 0, flush list 0, single page 0 Pages read 2992157, created 26960, written 2048581 332.93 reads/s, 0.00 creates/s, 652.07 writes/s Buffer pool hit rate 991 / 1000 -------------- ROW OPERATIONS -------------- 8 queries inside InnoDB, 576 queries in queue 411 read views open inside InnoDB Main thread process no. 26345, id 1160309072, state: doing insert buffer merge Number of rows inserted 1248442, updated 4956140, deleted 39530, read 3046336126 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set, 1 warning (0.01 sec)