This is INNODB MONITOR OUTPUT when mysqld's memory is 2.3G. When mysqld have a fatal error ( can not allocate memory), mysqld's client can not work for error. So, I can not receive "the show innodb status()"'s data. ===================================== 051125 17:35:39 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 24 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 25407969, signal count 20340017 Mutex spin waits 727979904, rounds 371014229, OS waits 14282624 RW-shared spins 2540558, OS waits 1327392; RW-excl spins 698427, OS waits 388236 ------------------------ LATEST FOREIGN KEY ERROR ------------------------ 051124 19:21:58 Transaction: TRANSACTION 1 326152057, ACTIVE 0 sec, process no 25308, OS thread id 913462 inserting, thread decl ared inside InnoDB 500 mysql tables in use 1, locked 1 5 lock struct(s), heap size 320, undo log entries 1 MySQL thread id 5997, query id 13141372 210.254.80.137 taon update insert into article (wuserid, title, nickname, avatar_code, regdt, regtm, attach_filename, content_ type, message, open_type, scrap_type, category1_code, category2_code, clothes, hpid, menu_code, fld id, aid) values ('satouyui0728', 'ﾋﾞﾊﾞ☆方言王国!?　ＩＮ山形(*´∀｀)ﾉ', 'Ïƒï ¼ˆÂ Foreign key constraint fails for table `hp/article`: , CONSTRAINT `article_ibfk_2` FOREIGN KEY (`fldid`, `category1_code`, `category2_code`) REFERENCES `folder_category` (`fldid`, `category1_code`, `category2_code`) ON DELETE CASCADE ON UPDATE CASCADE Trying to add in child table, in index `IDX_article5` tuple: DATA TUPLE: 6 fields; 0: len 6; hex 656e71756574; asc enquet;; 1: len 10; hex 656e71756574655f3035; asc enquete_05;; 2: len 12; hex 656e71756574655f30313031; asc enquete_0101;; 3: len 12; hex 7361746f7579756930373238; a sc satouyui0728;; 4: len 6; hex 6d796d656e75; asc mymenu;; 5: len 4; hex 00000002; asc ;; But in parent table `hp/folder_category`, in index `PRIMARY`, the closest match we can find is record: PHYSICAL RECORD: n_fields 8; 1-byte offs TRUE; info bits 0 0: len 6; hex 656e71756574; asc enquet;; 1: len 10; hex 656e71756574655f3035; asc enquete_05;; 2: len 12; hex 656e71756574655f30353031; asc enquete_0501;; 3: len 6; hex 0000001b33a3; asc 3 ;; 4 : len 7; hex 800002c01828a6; asc ( ;; 5: len 9; hex e383a9e382a4e38395; asc ;; 6: len 15; hex e6818be6849befbc8fe7b590e5a99a; asc ;; 7: len 4; hex 00000000; asc ;; ------------------------ LATEST DETECTED DEADLOCK ------------------------ 051125 17:07:31 *** (1) TRANSACTION: TRANSACTION 1 336606302, ACTIVE 0 sec, process no 26341, OS thread id 2080792 starting index read mysql tables in use 1, locked 1 LOCK WAIT 28 lock struct(s), heap size 2496, undo log entries 26 MySQL thread id 23839, query id 47671016 210.254.80.136 taon Updating UPDATE article SET read_count = read_count + 1 WHERE hpid = 'clover01' AND menu_code = 'album' AND fldid = 'pho0' AND aid = 7 *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 545290 n bits 112 index `PRIMARY` of table `hp/article` trx id 1 33 6606302 lock_mode X locks rec but not gap waiting Record lock, heap no 44 PHYSICAL RECORD: n_fields 29; 1-byte offs FALSE; info bits 0 0: len 8; hex 636c6f7665723031; asc clover01;; 1: len 5; hex 616c62756d; asc album;; 2: len 4; hex 70686f30; asc pho0;; 3: len 4; hex 00000007; asc ;; 4: len 6; hex 00011410345f; asc 4_;; 5 : len 7; hex 00004ec003046b; asc N k;; 6: SQL NULL, size 0 ; 7: SQL NULL, size 0 ; 8: SQL NULL, size 0 ; 9: len 4; hex 00000000; asc ;; 10: len 8; hex 636c6f7665723031; asc clover01;; 11: SQ L NULL, size 0 ; 12: SQL NULL, size 0 ; 13: len 12; hex e382aae383acefbd96efbd96; asc ; ; 14: len 4; hex 4ed1914f; asc N O;; 15: len 30; hex 62325f3030315f413536315f413330365f30383232305 f30373139385f31; asc b2_001_A561_A306_08220_07198_1;...(truncated); 16: len 3; hex 8fab78; asc x; ; 17: len 3; hex 8276df; asc v ;; 18: len 4; hex 00000003; asc ;; 19: len 4; hex 00000037; asc 7;; 20: len 4; hex 00000002; asc ;; 21: len 1; hex 00; asc ;; 22: len 3; hex ce1f9f; asc ;; 23: SQL NULL, size 0 ; 24: len 1; hex 80; asc ;; 25: len 1; hex 80; asc ;; 26: len 16; hex 3 230303531313234313631302e6a7067; asc 200511241610.jpg;; 27: len 11; hex 696d6167652f706a706567; asc image/pjpeg;; 28: len 17; hex 686169723d26626f64793d26616363733d; asc hair=&body=&accs=;; *** (2) TRANSACTION: TRANSACTION 1 336606303, ACTIVE 0 sec, process no 26650, OS thread id 2306065 starting index read, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 25 lock struct(s), heap size 2496, undo log entries 41 MySQL thread id 23933, query id 47671057 210.254.80.137 taon Updating UPDATE article SET read_count = read_count + 1 WHERE hpid = 'taka12253692' AND menu_code = 'album' AND fldid = 'pho0' AND aid = 4 *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 0 page no 545290 n bits 112 index `PRIMARY` of table `hp/article` trx id 1 33 6606303 lock_mode X locks rec but not gap Record lock, heap no 43 PHYSICAL RECORD: n_fields 29; 1-byte offs FALSE; info bits 0 0: len 8; hex 636c6f7665723031; asc clover01;; 1: len 5; hex 616c62756d; asc album;; 2: len 4; hex 70686f30; asc pho0;; 3: len 4; hex 00000006; asc ;; 4: len 6; hex 00011410345f; asc 4_;; 5 : len 7; hex 00004ec0030b7d; asc N };; 6: SQL NULL, size 0 ; 7: SQL NULL, size 0 ; 8: SQL NULL, size 0 ; 9: len 4; hex 00000000; asc ;; 10: len 8; hex 636c6f7665723031; asc clover01;; 11: SQ L NULL, size 0 ; 12: SQL NULL, size 0 ; 13: len 12; hex e382a6e38381efbd96efbd96; asc ; ; 14: len 4; hex 4ed1914f; asc N O;; 15: len 30; hex 62325f3030315f413538305f413330365f30383232305 f30373139385f31; asc b2_001_A580_A306_08220_07198_1;...(truncated); 16: len 3; hex 8fab6c; asc l; ; 17: len 3; hex 81fd29; asc );; 18: len 4; hex 0000000a; asc ;; 19: len 4; hex 000001ad; asc ;; 20: len 4; hex 00000005; asc ;; 21: len 1; hex 00; asc ;; 22: len 3; hex ce1f9f; asc ;; 23: SQL NULL, size 0 ; 24: len 1; hex 80; asc ;; 25: len 1; hex 80; asc ;; 26: len 12; hex 5 0313031303237362e4a5047; asc P1010276.JPG;; 27: len 11; hex 696d6167652f706a706567; asc image/pjpeg ;; 28: len 17; hex 686169723d26626f64793d26616363733d; asc hair=&body=&accs=;; Record lock, heap no 44 PHYSICAL RECORD: n_fields 29; 1-byte offs FALSE; info bits 0 0: len 8; hex 636c6f7665723031; asc clover01;; 1: len 5; hex 616c62756d; asc album;; 2: len 4; hex 70686f30; asc pho0;; 3: len 4; hex 00000007; asc ;; 4: len 6; hex 00011410345f; asc 4_;; 5 : len 7; hex 00004ec003046b; asc N k;; 6: SQL NULL, size 0 ; 7: SQL NULL, size 0 ; 8: SQL NULL, size 0 ; 9: len 4; hex 00000000; asc ;; 10: len 8; hex 636c6f7665723031; asc clover01;; 11: SQ L NULL, size 0 ; 12: SQL NULL, size 0 ; 13: len 12; hex e382aae383acefbd96efbd96; asc ; ; 14: len 4; hex 4ed1914f; asc N O;; 15: len 30; hex 62325f3030315f413536315f413330365f30383232305 f30373139385f31; asc b2_001_A561_A306_08220_07198_1;...(truncated); 16: len 3; hex 8fab78; asc x; ; 17: len 3; hex 8276df; asc v ;; 18: len 4; hex 00000003; asc ;; 19: len 4; hex 00000037; asc 7;; 20: len 4; hex 00000002; asc ;; 21: len 1; hex 00; asc ;; 22: len 3; hex ce1f9f; asc ;; 23: SQL NULL, size 0 ; 24: len 1; hex 80; asc ;; 25: len 1; hex 80; asc ;; 26: len 16; hex 3 230303531313234313631302e6a7067; asc 200511241610.jpg;; 27: len 11; hex 696d6167652f706a706567; asc image/pjpeg;; 28: len 17; hex 686169723d26626f64793d26616363733d; asc hair=&body=&accs=;; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 0 page no 3300300 n bits 136 index `PRIMARY` of table `hp/article` trx id 1 3 36606303 lock_mode X locks rec but not gap waiting Record lock, heap no 69 PHYSICAL RECORD: n_fields 29; 1-byte offs FALSE; info bits 0 0: len 12; hex 74616b613132323533363932; asc taka12253692;; 1: len 5; hex 616c62756d; asc album;; 2: len 4; hex 70686f30; asc pho0;; 3: len 4; hex 00000004; asc ;; 4: len 6; hex 00011410345e; a sc 4^;; 5: len 7; hex 00004e80391754; asc N 9 T;; 6: SQL NULL, size 0 ; 7: SQL NULL, size 0 ; 8: SQL NULL, size 0 ; 9: len 4; hex 00000000; asc ;; 10: len 12; hex 74616b613132323533363932; asc taka12253692;; 11: SQL NULL, size 0 ; 12: SQL NULL, size 0 ; 13: len 27; hex e68e88e6a5ade4b8a de381aee890bde69bb8e3818defbd97e291a2; asc ;; 14: len 12; hex e38195e381 8be3819fe3818b; asc ;; 15: len 30; hex 62315f3030315f413538355f413538395f30383232305f30 373139305f30; asc b1_001_A585_A589_08220_07190_0;...(truncated); 16: len 3; hex 8fab78; asc x;; 1 7: len 3; hex 824f24; asc O$;; 18: len 4; hex 00000004; asc ;; 19: len 4; hex 0000001c; asc ;; 20: len 4; hex 00000002; asc ;; 21: len 1; hex 00; asc ;; 22: len 3; hex ce1f9f; asc ; ; 23: SQL NULL, size 0 ; 24: len 1; hex 80; asc ;; 25: len 1; hex 80; asc ;; 26: len 20; hex 3035 313132345f313530337e303030312e6a7067; asc 051124_1503~0001.jpg;; 27: len 11; hex 696d6167652f706a70 6567; asc image/pjpeg;; 28: len 17; hex 686169723d26626f64793d26616363733d; asc hair=&body=&accs=;; *** WE ROLL BACK TRANSACTION (1) ------------ TRANSACTIONS ------------ Trx id counter 1 336894672 Purge done for trx's n:o < 1 336892827 undo n:o < 0 0 History list length 44 Total number of lock structs in row lock hash table 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 0, not started, process no 26669, OS thread id 2338849 MySQL thread id 24529, query id 48615856 localhost root show innodb status ---TRANSACTION 1 336870021, not started, process no 25595, OS thread id 1511437 MySQL thread id 24118, query id 48536228 base.taon.co.jp 210.254.80.77 taon ---TRANSACTION 1 336862755, not started, process no 26741, OS thread id 2474066 MySQL thread id 24478, query id 48513868 210.254.80.136 taon ---TRANSACTION 1 336894667, not started, process no 26758, OS thread id 2543721 MySQL thread id 24495, query id 48615837 210.254.80.137 taon ---TRANSACTION 1 336867828, not started, process no 26759, OS thread id 2547818 MySQL thread id 24496, query id 48530371 210.254.80.137 taon ---TRANSACTION 1 336894217, not started, process no 26750, OS thread id 2510945 MySQL thread id 24487, query id 48614381 210.254.80.136 taon ---TRANSACTION 1 336872284, not started, process no 26755, OS thread id 2531430 MySQL thread id 24492, query id 48543703 210.254.80.136 taon ---TRANSACTION 1 336894634, not started, process no 26757, OS thread id 2539624 MySQL thread id 24494, query id 48615718 210.254.80.91 taon ---TRANSACTION 1 336894654, not started, process no 26756, OS thread id 2535527 MySQL thread id 24493, query id 48615797 210.254.80.136 taon ---TRANSACTION 1 336863231, not started, process no 26754, OS thread id 2527333 MySQL thread id 24491, query id 48514313 210.254.80.136 taon ---TRANSACTION 1 336868099, not started, process no 26753, OS thread id 2523236 MySQL thread id 24490, query id 48530265 210.254.80.136 taon ---TRANSACTION 1 336863205, not started, process no 26752, OS thread id 2519139 MySQL thread id 24489, query id 48514179 210.254.80.137 taon ---TRANSACTION 1 336863253, not started, process no 26751, OS thread id 2515042 MySQL thread id 24488, query id 48514418 210.254.80.136 taon ---TRANSACTION 1 336868094, not started, process no 26749, OS thread id 2506848 MySQL thread id 24486, query id 48530263 210.254.80.137 taon ---TRANSACTION 1 336863213, not started, process no 26748, OS thread id 2502751 MySQL thread id 24485, query id 48514243 210.254.80.137 taon ---TRANSACTION 1 336894421, not started, process no 26747, OS thread id 2498654 MySQL thread id 24484, query id 48615040 210.254.80.136 taon ---TRANSACTION 1 336889813, not started, process no 26746, OS thread id 2494557 MySQL thread id 24483, query id 48600297 210.254.80.137 taon ---TRANSACTION 1 336894263, not started, process no 26745, OS thread id 2490460 MySQL thread id 24482, query id 48614558 210.254.80.137 taon ---TRANSACTION 1 336894507, not started, process no 26744, OS thread id 2486363 MySQL thread id 24481, query id 48615312 210.254.80.136 taon ---TRANSACTION 1 336863189, not started, process no 26743, OS thread id 2482264 MySQL thread id 24480, query id 48514365 210.254.80.136 taon ---TRANSACTION 1 336863270, not started, process no 26742, OS thread id 2478166 MySQL thread id 24479, query id 48514411 210.254.80.136 taon ---TRANSACTION 1 336894646, not started, process no 26740, OS thread id 2469968 MySQL thread id 24477, query id 48615759 210.254.80.137 taon ---TRANSACTION 1 336862338, not started, process no 26739, OS thread id 2465870 MySQL thread id 24476, query id 48511663 210.254.80.91 taon ---TRANSACTION 1 336863054, not started, process no 26738, OS thread id 2461769 MySQL thread id 24475, query id 48513829 210.254.80.136 taon ---TRANSACTION 1 336862337, not started, process no 26737, OS thread id 2457672 MySQL thread id 24474, query id 48511662 210.254.80.91 taon ---TRANSACTION 1 336863339, not started, process no 26736, OS thread id 2453563 MySQL thread id 24473, query id 48514666 210.254.80.136 taon ---TRANSACTION 1 336894662, not started, process no 26735, OS thread id 2449461 MySQL thread id 24472, query id 48615821 210.254.80.137 taon ---TRANSACTION 1 336893090, not started, process no 26734, OS thread id 2445353 MySQL thread id 24471, query id 48610622 210.254.80.137 taon ---TRANSACTION 1 336862937, not started, process no 26733, OS thread id 2441253 MySQL thread id 24470, query id 48513435 210.254.80.137 taon ---TRANSACTION 1 336863161, not started, process no 26732, OS thread id 2437151 MySQL thread id 24469, query id 48514170 210.254.80.137 taon ---TRANSACTION 1 336868077, not started, process no 26731, OS thread id 2433052 MySQL thread id 24468, query id 48530365 210.254.80.137 taon ---TRANSACTION 1 336893104, not started, process no 26730, OS thread id 2428954 MySQL thread id 24467, query id 48610673 210.254.80.137 taon ---TRANSACTION 1 336894428, not started, process no 26729, OS thread id 2424857 MySQL thread id 24466, query id 48615050 210.254.80.137 taon ---TRANSACTION 1 336893302, not started, process no 26714, OS thread id 2420750 MySQL thread id 24465, query id 48611373 210.254.80.137 taon ---TRANSACTION 1 336862541, not started, process no 26663, OS thread id 2326579 MySQL thread id 24445, query id 48512320 210.254.80.137 taon ---TRANSACTION 1 336863226, not started, process no 26620, OS thread id 2265162 MySQL thread id 24419, query id 48514272 210.254.80.136 taon ---TRANSACTION 1 336868111, not started, process no 26701, OS thread id 2412633 MySQL thread id 24411, query id 48530389 210.254.80.136 taon ---TRANSACTION 1 336870672, not started, process no 26702, OS thread id 2416730 MySQL thread id 24151, query id 48538281 base.taon.co.jp 210.254.80.77 taon ---TRANSACTION 1 336894446, not started, process no 26693, OS thread id 2379853 MySQL thread id 24403, query id 48615103 210.254.80.136 taon ---TRANSACTION 1 336862554, not started, process no 26339, OS thread id 2072598 MySQL thread id 24402, query id 48512377 210.254.80.137 taon ---TRANSACTION 1 336876358, not started, process no 26281, OS thread id 1962020 MySQL thread id 24401, query id 48556485 210.254.80.137 taon ---TRANSACTION 1 336876364, not started, process no 26664, OS thread id 2330680 MySQL thread id 24400, query id 48556488 210.254.80.137 taon ---TRANSACTION 1 336868119, not started, process no 26650, OS thread id 2306065 MySQL thread id 24393, query id 48530462 210.254.80.137 taon ---TRANSACTION 1 336892165, not started, process no 26689, OS thread id 2363454 MySQL thread id 24307, query id 48607664 210.254.80.137 taon ---TRANSACTION 1 336862925, not started, process no 26382, OS thread id 2105379 MySQL thread id 24281, query id 48513398 210.254.80.137 taon ---TRANSACTION 1 336868090, not started, process no 26598, OS thread id 2240582 MySQL thread id 24232, query id 48530255 210.254.80.137 taon ---TRANSACTION 1 336868454, not started, process no 26638, OS thread id 2293831 MySQL thread id 24231, query id 48531358 210.254.80.136 taon ---TRANSACTION 1 336863227, not started, process no 26699, OS thread id 2404439 MySQL thread id 24115, query id 48514430 210.254.80.136 taon ---TRANSACTION 1 336894223, not started, process no 26696, OS thread id 2392145 MySQL thread id 24112, query id 48614408 210.254.80.136 taon ---TRANSACTION 1 336863291, not started, process no 26694, OS thread id 2383951 MySQL thread id 24110, query id 48514470 210.254.80.136 taon ---TRANSACTION 1 336894668, not started, process no 26691, OS thread id 2371653 MySQL thread id 24107, query id 48615851 210.254.80.136 taon ---TRANSACTION 1 336893091, not started, process no 26690, OS thread id 2367555 MySQL thread id 24106, query id 48610621 210.254.80.137 taon ---TRANSACTION 1 336875131, not started, process no 26683, OS thread id 2359357 MySQL thread id 23999, query id 48554201 user.cafesta.com 210.254.80.75 taon ---TRANSACTION 1 336890170, not started, process no 26675, OS thread id 2351164 MySQL thread id 23943, query id 48601368 user.cafesta.com 210.254.80.75 taon ---TRANSACTION 1 336868271, not started, process no 26341, OS thread id 2080792 MySQL thread id 23839, query id 48530882 210.254.80.136 taon ---TRANSACTION 1 336863212, not started, process no 26622, OS thread id 2273356 MySQL thread id 23722, query id 48514277 210.254.80.137 taon ---TRANSACTION 1 336844394, not started, process no 26594, OS thread id 2224194 MySQL thread id 23681, query id 48452757 user.cafesta.com 210.254.80.75 taon ---TRANSACTION 1 336889006, not started, process no 26621, OS thread id 2269259 MySQL thread id 23618, query id 48597695 210.254.80.137 taon ---TRANSACTION 1 336862442, not started, process no 26670, OS thread id 2342970 MySQL thread id 23558, query id 48512180 210.254.80.137 taon ---TRANSACTION 1 336160139, not started, process no 26662, OS thread id 2322478 MySQL thread id 23524, query id 46232767 210.254.80.91 taon ---TRANSACTION 1 336158054, not started, process no 26516, OS thread id 2162737 MySQL thread id 23513, query id 46225512 210.254.80.91 taon ---TRANSACTION 1 336893257, not started, process no 26554, OS thread id 2187316 MySQL thread id 23512, query id 48611221 210.254.80.91 taon ---TRANSACTION 1 336152215, not started, process no 26606, OS thread id 2248746 MySQL thread id 23511, query id 46205644 210.254.80.91 taon ---TRANSACTION 1 336862570, not started, process no 26534, OS thread id 2175016 MySQL thread id 23441, query id 48512395 210.254.80.137 taon ---TRANSACTION 1 336890013, not started, process no 26651, OS thread id 2310182 MySQL thread id 23271, query id 48600892 210.254.80.136 taon ---TRANSACTION 1 336894527, not started, process no 26652, OS thread id 2314285 MySQL thread id 23133, query id 48615374 user.cafesta.com 210.254.80.75 taon ---TRANSACTION 1 336863105, not started, process no 26296, OS thread id 2023478 MySQL thread id 23062, query id 48513898 210.254.80.136 taon ---TRANSACTION 1 336863196, not started, process no 26501, OS thread id 2134059 MySQL thread id 23000, query id 48514146 210.254.80.136 taon ---TRANSACTION 1 336148279, not started, process no 26585, OS thread id 2220097 MySQL thread id 22472, query id 46192419 210.254.80.91 taon ---TRANSACTION 1 336862894, not started, process no 26280, OS thread id 1957922 MySQL thread id 22307, query id 48513288 210.254.80.137 taon ---TRANSACTION 1 336863282, not started, process no 26309, OS thread id 2052108 MySQL thread id 21961, query id 48514489 210.254.80.136 taon ---TRANSACTION 1 336863262, not started, process no 26579, OS thread id 2207767 MySQL thread id 21960, query id 48514368 210.254.80.136 taon ---TRANSACTION 1 336862572, not started, process no 26596, OS thread id 2232388 MySQL thread id 21784, query id 48512391 210.254.80.137 taon ---TRANSACTION 1 336863202, not started, process no 26514, OS thread id 2154543 MySQL thread id 21533, query id 48514226 210.254.80.136 taon ---TRANSACTION 1 336894671, not started, process no 26532, OS thread id 2166794 MySQL thread id 21480, query id 48615855 210.254.80.136 taon ---TRANSACTION 1 336154688, not started, process no 26584, OS thread id 2215999 MySQL thread id 21418, query id 46214105 210.254.80.91 taon ---TRANSACTION 1 336863296, not started, process no 26310, OS thread id 2056207 MySQL thread id 21249, query id 48514496 210.254.80.136 taon ---TRANSACTION 1 336863133, not started, process no 26546, OS thread id 2179122 MySQL thread id 20636, query id 48514225 210.254.80.136 taon ---TRANSACTION 1 335432308, not started, process no 26316, OS thread id 2068501 MySQL thread id 20435, query id 43788499 210.254.80.91 taon ---TRANSACTION 1 334659129, not started, process no 26410, OS thread id 2117671 MySQL thread id 20219, query id 41176159 210.254.80.91 taon ---TRANSACTION 1 335445542, not started, process no 26264, OS thread id 1912851 MySQL thread id 20149, query id 43831385 210.254.80.91 taon ---TRANSACTION 1 334234279, not started, process no 26265, OS thread id 1916948 MySQL thread id 20122, query id 39771411 210.254.80.91 taon ---TRANSACTION 1 336143760, not started, process no 24953, OS thread id 348245 MySQL thread id 19752, query id 46177130 210.254.80.91 taon ---TRANSACTION 1 334173673, not started, process no 26502, OS thread id 2138156 MySQL thread id 19716, query id 39569346 210.254.80.91 taon ---TRANSACTION 1 333871697, not started, process no 26297, OS thread id 2027575 MySQL thread id 19304, query id 38566232 210.254.80.91 taon ---TRANSACTION 1 334193163, not started, process no 26278, OS thread id 1949728 MySQL thread id 19290, query id 39633566 210.254.80.91 taon ---TRANSACTION 1 333794967, not started, process no 26515, OS thread id 2158640 MySQL thread id 19223, query id 38305625 210.254.80.91 taon ---TRANSACTION 1 334008040, not started, process no 25703, OS thread id 1794078 MySQL thread id 18542, query id 39022103 210.254.80.91 taon ---TRANSACTION 1 333768434, not started, process no 26263, OS thread id 1908752 MySQL thread id 17070, query id 38220695 210.254.80.91 taon ---TRANSACTION 1 333770340, not started, process no 26277, OS thread id 1945629 MySQL thread id 16604, query id 38229367 210.254.80.91 taon ---TRANSACTION 1 333383194, not started, process no 26299, OS thread id 2035769 MySQL thread id 14597, query id 36905966 210.254.80.91 taon ---TRANSACTION 1 336868057, not started, process no 26311, OS thread id 2060306 MySQL thread id 16135, query id 48530141 210.254.80.136 taon ---TRANSACTION 1 336894669, ACTIVE 1 sec, process no 26580, OS thread id 2211867 committing MySQL thread id 24101, query id 48615772 210.254.80.137 taon Sending data (SELECT 'diary' is_new FROM article a INNER JOIN folder b USING(hpid, menu_code, fldid) WHERE a.hpi d = 'kanon626' AND a.menu_code = 'diary' AND a.vldenddt = '9999-12-31' AND b.vldenddt = '9999-12-31 ' AND b.disabled = 0 AND a.blocked = 0 AND (a.regdt = curdate() OR (a.regdt = SUBDATE(curdate(), 1) AN Trx read view will not see trx with id >= 1 336894670, sees < 1 336894670 -------- 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: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (write thread) Pending normal aio reads: 0, 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 16034360 OS file reads, 1466411 OS file writes, 518399 OS fsyncs 134.74 reads/s, 17067 avg bytes/read, 11.83 writes/s, 4.46 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 78, free list len 48, seg size 127, is not empty Ibuf for space 0: size 78, free list len 48, seg size 127, 414038 inserts, 402309 merged recs, 124125 merges Hash table size 7470761, used cells 1791655, node heap has 2009 buffer(s) 6416.27 hash searches/s, 3069.71 non-hash searches/s --- LOG --- Log sequence number 61 4051888117 Log flushed up to 61 4051886655 Last checkpoint at 61 4042813532 0 pending log writes, 0 pending chkp writes 122386 log i/o's done, 1.08 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 2022131839; in additional pool allocated 13743232 Buffer pool size 115200 Free buffers 0 Database pages 113191 Modified db pages 10940 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages read 17182271, created 13998, written 1372304 140.54 reads/s, 0.04 creates/s, 10.71 writes/s Buffer pool hit rate 997 / 1000 -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue Main thread process no. 24873, id 28680, state: sleeping Number of rows inserted 559156, updated 660758, deleted 11196, read 2368442622 6.21 inserts/s, 7.33 updates/s, 0.00 deletes/s, 40635.22 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================