Type Name Status InnoDB ===================================== 2014-10-22 09:25:43 7fe24771c700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 2 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 416282 srv_active, 0 srv_shutdown, 20 srv_idle srv_master_thread log flush and writes: 416302 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 159713097 OS WAIT ARRAY INFO: signal count 753532640 Mutex spin waits 528991089, rounds 474407764, OS waits 4487029 RW-shared spins 1194173278, rounds 6483844078, OS waits 129624886 RW-excl spins 107476281, rounds 1765692735, OS waits 22095324 Spin rounds per wait: 0.90 mutex, 5.43 RW-shared, 16.43 RW-excl ------------------------ ------------ TRANSACTIONS ------------ Trx id counter 20563882274 Purge done for trx's n:o < 20563881727 undo n:o < 0 state: running but idle History list length 102 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 77550148, OS thread handle 0x7fe24771c700, query id 1276848563 localhost root init show engine innodb status ---TRANSACTION 20563882254, not started MySQL thread id 77550139, OS thread handle 0x7fe2476db700, query id 1276848444 192.168.0.102 project_web cleaning up ---TRANSACTION 20563882252, not started MySQL thread id 77550138, OS thread handle 0x7fe247aeb700, query id 1276848441 192.168.0.102 project_web cleaning up ---TRANSACTION 20563882245, not started MySQL thread id 77550136, OS thread handle 0x7fe247618700, query id 1276848406 192.168.0.102 project_web cleaning up ---TRANSACTION 20563882273, not started MySQL thread id 77550137, OS thread handle 0x7fe24c5f4700, query id 1276848545 192.168.0.102 project_web cleaning up ---TRANSACTION 20563881823, not started MySQL thread id 77550048, OS thread handle 0x7fe24c3ab700, query id 1276845778 192.168.0.102 project_web cleaning up ---TRANSACTION 20563881379, not started MySQL thread id 77549984, OS thread handle 0x7fe24d224700, query id 1276844813 192.168.0.102 project_web cleaning up ---TRANSACTION 20563881380, not started MySQL thread id 77549985, OS thread handle 0x7fe24d5b2700, query id 1276844814 192.168.0.102 project_web cleaning up ---TRANSACTION 20563881372, not started MySQL thread id 77549991, OS thread handle 0x7fe24cb49700, query id 1276844806 192.168.0.102 project_web cleaning up ---TRANSACTION 20563881384, not started MySQL thread id 77549990, OS thread handle 0x7fe24c080700, query id 1276844817 192.168.0.102 project_web cleaning up ---TRANSACTION 20563881386, not started MySQL thread id 77549986, OS thread handle 0x7fe254423700, query id 1276844819 192.168.0.102 project_web cleaning up ---TRANSACTION 20563881381, not started MySQL thread id 77549988, OS thread handle 0x7fe24cbcb700, query id 1276844816 192.168.0.102 project_web cleaning up ---TRANSACTION 20563881389, not started MySQL thread id 77549987, OS thread handle 0x7fe24d675700, query id 1276844822 192.168.0.102 project_web cleaning up ---TRANSACTION 20563881166, not started MySQL thread id 77549962, OS thread handle 0x7fe254158700, query id 1276844542 192.168.0.102 project_web cleaning up ---TRANSACTION 20563881232, not started MySQL thread id 77549963, OS thread handle 0x7fe247410700, query id 1276844624 192.168.0.102 project_web cleaning up ---TRANSACTION 20563882194, not started MySQL thread id 77531611, OS thread handle 0x7fe24d6b6700, query id 1276848048 192.168.0.101 project_backend cleaning up ---TRANSACTION 20563880543, not started MySQL thread id 77499424, OS thread handle 0x7fe24d01c700, query id 1276843979 192.168.0.101 project_backend cleaning up ---TRANSACTION 20563881697, not started MySQL thread id 77040534, OS thread handle 0x7fe24d265700, query id 1276845184 192.168.0.101 project_backend cleaning up ---TRANSACTION 20563882138, not started MySQL thread id 76594273, OS thread handle 0x7fe24d7fb700, query id 1276847697 192.168.0.101 project_backend cleaning up ---TRANSACTION 20563880864, not started MySQL thread id 76594272, OS thread handle 0x7fe24779e700, query id 1276844195 192.168.0.101 project_backend cleaning up ---TRANSACTION 20509878143, not started MySQL thread id 72159153, OS thread handle 0x7fe24d4ef700, query id 0 Slave has read all relay log; waiting for the slave I/O thread to update it ---TRANSACTION 20563882256, ACTIVE 0 sec starting index read, thread declared inside InnoDB 5000 mysql tables in use 1, locked 1 24 lock struct(s), heap size 2936, 47 row lock(s), undo log entries 46 MySQL thread id 77040533, OS thread handle 0x7fe247d75700, query id 1276848562 192.168.0.101 project_backend updating UPDATE `Item2TagActive` SET `sortRank` = 1000060, `sortRankCalculationType` = 'brand', `visits` = 2111, `clicks` = 1 WHERE `itemId` IN (3435976) AND `tagId` = 197 TABLE LOCK table `project_de`.`Item2TagActive` trx id 20563882256 lock mode IX RECORD LOCKS space id 190383 page no 1531 n bits 248 index `PRIMARY` of table `project_de`.`Item2TagActive` trx id 20563882256 lock_mode X locks rec but not gap TABLE LOCK table `project_de`.`Item2TagAlternativeRank` trx id 20563882256 lock mode IX RECORD LOCKS space id 190949 page no 44981 n bits 352 index `PRIMARY` of table `project_de`.`Item2TagAlternativeRank` trx id 20563882256 lock_mode X locks rec but not gap RECORD LOCKS space id 190383 page no 217021 n bits 224 index `PRIMARY` of table `project_de`.`Item2TagActive` trx id 20563882256 lock_mode X locks rec but not gap RECORD LOCKS space id 190383 page no 334271 n bits 288 index `PRIMARY` of table `project_de`.`Item2TagActive` trx id 20563882256 lock_mode X locks rec but not gap RECORD LOCKS space id 190383 page no 217789 n bits 296 index `PRIMARY` of table `project_de`.`Item2TagActive` trx id 20563882256 lock_mode X locks rec but not gap RECORD LOCKS space id 190949 page no 8932 n bits 464 index `PRIMARY` of table `project_de`.`Item2TagAlternativeRank` trx id 20563882256 lock_mode X locks rec but not gap RECORD LOCKS space id 190383 page no 334194 n bits 264 index `PRIMARY` of table `project_de`.`Item2TagActive` trx id 20563882256 lock_mode X locks rec but not gap RECORD LOCKS space id 190383 page no 135846 n bits 248 index `PRIMARY` of table `project_de`.`Item2TagActive` trx id 20563882256 lock_mode X locks rec but not gap TOO MANY LOCKS PRINTED FOR THIS TRX: SUPPRESSING FURTHER PRINTS -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (write thread) I/O thread 7 state: waiting for completed aio requests (write thread) I/O thread 8 state: waiting for completed aio requests (write thread) I/O thread 9 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 118847952 OS file reads, 158886204 OS file writes, 25368192 OS fsyncs 214.89 reads/s, 15869 avg bytes/read, 253.37 writes/s, 30.98 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 23230, seg size 23232, 13236748 merges merged operations: insert 15560583, delete mark 22859617, delete 6671020 discarded operations: insert 0, delete mark 0, delete 0 104385.81 hash searches/s, 288421.79 non-hash searches/s --- LOG --- Log sequence number 8552250875167 Log flushed up to 8552250862545 Pages flushed up to 8552156761993 Last checkpoint at 8552146449178 Max checkpoint age 430379460 Checkpoint age target 416930102 Modified age 94113174 Checkpoint age 104425989 0 pending log writes, 0 pending chkp writes 12942328 log i/o's done, 18.50 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 54945382400; in additional pool allocated 0 Total memory allocated by read views 2744 Internal hash tables (constant factor + variable factor) Adaptive hash index 7721607072 \t(849989432 + 6871617640) Page hash 6641384 (buffer pool 0 only) Dictionary cache 216083025 \t(212498864 + 3584161) File system 1027960 \t(812272 + 215688) Lock system 147849408 \t(147837832 + 11576) Recovery system 0 \t(0 + 0) Dictionary memory allocated 3584161 Buffer pool size 3276792 Buffer pool size, bytes 53686960128 Free buffers 8078 Database pages 2813925 Old database pages 1038586 Modified db pages 72702 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 212060520, not young 9990306073 203.40 youngs/s, 18594.70 non-youngs/s Pages read 118847898, created 4704970, written 141300202 214.89 reads/s, 2.50 creates/s, 230.38 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 13 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 2813925, unzip_LRU len: 144860 I/O sum[565424]:cur[1776], unzip sum[20488]:cur[112] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 409599 Buffer pool size, bytes 6710870016 Free buffers 1009 Database pages 352121 Old database pages 129964 Modified db pages 9217 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 27518792, not young 1250146561 24.49 youngs/s, 5278.36 non-youngs/s Pages read 15273349, created 596501, written 18147281 21.49 reads/s, 0.00 creates/s, 64.47 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 46 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 352121, unzip_LRU len: 16706 I/O sum[70678]:cur[222], unzip sum[2561]:cur[14] ---BUFFER POOL 1 Buffer pool size 409599 Buffer pool size, bytes 6710870016 Free buffers 1002 Database pages 351444 Old database pages 129715 Modified db pages 9182 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 25493104, not young 1213515400 29.49 youngs/s, 4086.46 non-youngs/s Pages read 14295655, created 591938, written 17468276 21.99 reads/s, 0.00 creates/s, 42.48 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 37 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 351444, unzip_LRU len: 18676 I/O sum[70678]:cur[222], unzip sum[2561]:cur[14] ---BUFFER POOL 2 Buffer pool size 409599 Buffer pool size, bytes 6710870016 Free buffers 1006 Database pages 351523 Old database pages 129748 Modified db pages 8377 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 26169534, not young 1253818696 18.49 youngs/s, 389.81 non-youngs/s Pages read 14883460, created 594069, written 17418223 22.99 reads/s, 0.00 creates/s, 27.99 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 1 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 351523, unzip_LRU len: 19145 I/O sum[70678]:cur[222], unzip sum[2561]:cur[14] ---BUFFER POOL 3 Buffer pool size 409599 Buffer pool size, bytes 6710870016 Free buffers 1015 Database pages 351921 Old database pages 129889 Modified db pages 9942 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 26887341, not young 1263837058 20.49 youngs/s, 601.70 non-youngs/s Pages read 15181187, created 600641, written 17796694 18.99 reads/s, 0.00 creates/s, 27.49 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 5 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 351921, unzip_LRU len: 17789 I/O sum[70678]:cur[222], unzip sum[2561]:cur[14] ---BUFFER POOL 4 Buffer pool size 409599 Buffer pool size, bytes 6710870016 Free buffers 1022 Database pages 351962 Old database pages 129903 Modified db pages 9149 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 26483743, not young 1226018928 29.49 youngs/s, 378.31 non-youngs/s Pages read 14446463, created 537119, written 17710792 34.48 reads/s, 0.00 creates/s, 14.49 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 1 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 351962, unzip_LRU len: 16779 I/O sum[70678]:cur[222], unzip sum[2561]:cur[14] ---BUFFER POOL 5 Buffer pool size 409599 Buffer pool size, bytes 6710870016 Free buffers 1015 Database pages 351831 Old database pages 129856 Modified db pages 8421 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 26744759, not young 1263778371 30.48 youngs/s, 474.76 non-youngs/s Pages read 14933108, created 583339, written 17285139 19.49 reads/s, 0.50 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 4 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 351831, unzip_LRU len: 17546 I/O sum[70678]:cur[222], unzip sum[2561]:cur[14] ---BUFFER POOL 6 Buffer pool size 409599 Buffer pool size, bytes 6710870016 Free buffers 1015 Database pages 351471 Old database pages 129722 Modified db pages 8990 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 26890358, not young 1238121643 25.99 youngs/s, 1237.38 non-youngs/s Pages read 14890256, created 604307, written 17752949 25.99 reads/s, 2.00 creates/s, 37.48 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 12 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 351471, unzip_LRU len: 19487 I/O sum[70678]:cur[222], unzip sum[2561]:cur[14] ---BUFFER POOL 7 Buffer pool size 409599 Buffer pool size, bytes 6710870016 Free buffers 994 Database pages 351652 Old database pages 129789 Modified db pages 9424 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 25872889, not young 1281069416 24.49 youngs/s, 6147.93 non-youngs/s Pages read 14944420, created 597056, written 17720848 49.48 reads/s, 0.00 creates/s, 15.99 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 17 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 351652, unzip_LRU len: 18732 I/O sum[70678]:cur[222], unzip sum[2561]:cur[14] -------------- ROW OPERATIONS -------------- 3 queries inside InnoDB, 0 queries in queue 3 read views open inside InnoDB 1 RW transactions active inside InnoDB 0 RO transactions active inside InnoDB 1 out of 1000 descriptors used ---OLDEST VIEW--- Normal read view Read view low limit trx n:o 20563881384 Read view up limit trx id 20563881384 Read view low limit trx id 20563881384 Read view individually stored trx ids: ----------------- Main thread process no. 9779, id 140610117498624, state: sleeping Number of rows inserted 69831017, updated 458077189, deleted 81143261, read 483448812060 8.50 inserts/s, 1182.91 updates/s, 0.00 deletes/s, 1748176.91 reads/s ------------------------ LATEST DETECTED DEADLOCK ------------------------ 2014-10-22 04:55:22 7fe247b6d700 *** (1) TRANSACTION: TRANSACTION 20530000279, ACTIVE 0 sec starting index read mysql tables in use 3, locked 3 LOCK WAIT 10 lock struct(s), heap size 2936, 17 row lock(s), undo log entries 1 MySQL thread id 74468435, OS thread handle 0x7fe24d4ae700, query id 1206364596 192.168.0.101 project_backend Sending data UPDATE `ExtTag` AS et \t\t\t\t\tJOIN `ExtItem2ExtTag` AS eit ON eit.`extTagId`= et.`extTagId` AND eit.`extItemId` = NEW.`extItemId` \t\t\t\tSET et.`items` = et.`items` + 1 *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 190862 page no 524 n bits 416 index `PRIMARY` of table `project_cz`.`ExtTag` trx id 20530000279 lock_mode X locks rec but not gap waiting *** (2) TRANSACTION: TRANSACTION 20530000179, ACTIVE 0 sec inserting, thread declared inside InnoDB 4998 mysql tables in use 3, locked 3 13 lock struct(s), heap size 2936, 12 row lock(s), undo log entries 11 MySQL thread id 74409094, OS thread handle 0x7fe247b6d700, query id 1206364662 192.168.0.101 project_backend closing tables INSERT INTO `ExtItem2ExtTag` (`extItemId`, `extTagId`) VALUES (6133258,'34215'), (6133258,'127472'), (6133258,'127464'), (6133258,'127467'), (6133258,'127466'), (6133258,'113184'), (6133258,'113141') *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 190862 page no 524 n bits 416 index `PRIMARY` of table `project_cz`.`ExtTag` trx id 20530000179 lock_mode X locks rec but not gap *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 190862 page no 524 n bits 416 index `PRIMARY` of table `project_cz`.`ExtTag` trx id 20530000179 lock mode S locks rec but not gap waiting *** WE ROLL BACK TRANSACTION (1) ------------ TRANSACTIONS ------------ Trx id counter 20563882274 Purge done for trx's n:o < 20563881727 undo n:o < 0 state: running but idle History list length 102 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 77550148, OS thread handle 0x7fe24771c700, query id 1276848563 localhost root init show engine innodb status ---TRANSACTION 20563882254, not started MySQL thread id 77550139, OS thread handle 0x7fe2476db700, query id 1276848444 192.168.0.102 project_web cleaning up ---TRANSACTION 20563882252, not started MySQL thread id 77550138, OS thread handle 0x7fe247aeb700, query id 1276848441 192.168.0.102 project_web cleaning up ---TRANSACTION 20563882245, not started MySQL thread id 77550136, OS thread handle 0x7fe247618700, query id 1276848406 192.168.0.102 project_web cleaning up ---TRANSACTION 20563882273, not started MySQL thread id 77550137, OS thread handle 0x7fe24c5f4700, query id 1276848545 192.168.0.102 project_web cleaning up ---TRANSACTION 20563881823, not started MySQL thread id 77550048, OS thread handle 0x7fe24c3ab700, query id 1276845778 192.168.0.102 project_web cleaning up ---TRANSACTION 20563881379, not started MySQL thread id 77549984, OS thread handle 0x7fe24d224700, query id 1276844813 192.168.0.102 project_web cleaning up ---TRANSACTION 20563881380, not started MySQL thread id 77549985, OS thread handle 0x7fe24d5b2700, query id 1276844814 192.168.0.102 project_web cleaning up ---TRANSACTION 20563881372, not started MySQL thread id 77549991, OS thread handle 0x7fe24cb49700, query id 1276844806 192.168.0.102 project_web cleaning up ---TRANSACTION 20563881384, not started MySQL thread id 77549990, OS thread handle 0x7fe24c080700, query id 1276844817 192.168.0.102 project_web cleaning up ---TRANSACTION 20563881386, not started MySQL thread id 77549986, OS thread handle 0x7fe254423700, query id 1276844819 192.168.0.102 project_web cleaning up ---TRANSACTION 20563881381, not started MySQL thread id 77549988, OS thread handle 0x7fe24cbcb700, query id 1276844816 192.168.0.102 project_web cleaning up ---TRANSACTION 20563881389, not started MySQL thread id 77549987, OS thread handle 0x7fe24d675700, query id 1276844822 192.168.0.102 project_web cleaning up ---TRANSACTION 20563881166, not started MySQL thread id 77549962, OS thread handle 0x7fe254158700, query id 1276844542 192.168.0.102 project_web cleaning up ---TRANSACTION 20563881232, not started MySQL thread id 77549963, OS thread handle 0x7fe247410700, query id 1276844624 192.168.0.102 project_web cleaning up ---TRANSACTION 20563882194, not started MySQL thread id 77531611, OS thread handle 0x7fe24d6b6700, query id 1276848048 192.168.0.101 project_backend cleaning up ---TRANSACTION 20563880543, not started MySQL thread id 77499424, OS thread handle 0x7fe24d01c700, query id 1276843979 192.168.0.101 project_backend cleaning up ---TRANSACTION 20563881697, not started MySQL thread id 77040534, OS thread handle 0x7fe24d265700, query id 1276845184 192.168.0.101 project_backend cleaning up ---TRANSACTION 20563882138, not started MySQL thread id 76594273, OS thread handle 0x7fe24d7fb700, query id 1276847697 192.168.0.101 project_backend cleaning up ---TRANSACTION 20563880864, not started MySQL thread id 76594272, OS thread handle 0x7fe24779e700, query id 1276844195 192.168.0.101 project_backend cleaning up ---TRANSACTION 20509878143, not started MySQL thread id 72159153, OS thread handle 0x7fe24d4ef700, query id 0 Slave has read all relay log; waiting for the slave I/O thread to update it ---TRANSACTION 20563882256, ACTIVE 0 sec inserting, thread declared inside InnoDB 5000 mysql tables in use 1, locked 1 24 lock struct(s), heap size 2936, 48 row lock(s), undo log entries 47 MySQL thread id 77040533, OS thread handle 0x7fe247d75700, query id 1276848564 192.168.0.101 project_backend update INSERT INTO `Item2TagAlternativeRank` SET `itemId` = 3435976, `tagId` = 197, `value` = 1010000, `clicks` = 1, `views` = 2111 ON DUPLICATE KEY UPDATE `value` = VALUES(`value`), `views` = VALUES(`views`), `clicks` = VALUES(`clicks`) TABLE LOCK table `project_de`.`Item2TagActive` trx id 20563882256 lock mode IX RECORD LOCKS space id 190383 page no 1531 n bits 248 index `PRIMARY` of table `project_de`.`Item2TagActive` trx id 20563882256 lock_mode X locks rec but not gap TABLE LOCK table `project_de`.`Item2TagAlternativeRank` trx id 20563882256 lock mode IX RECORD LOCKS space id 190949 page no 44981 n bits 352 index `PRIMARY` of table `project_de`.`Item2TagAlternativeRank` trx id 20563882256 lock_mode X locks rec but not gap RECORD LOCKS space id 190383 page no 217021 n bits 224 index `PRIMARY` of table `project_de`.`Item2TagActive` trx id 20563882256 lock_mode X locks rec but not gap RECORD LOCKS space id 190383 page no 334271 n bits 288 index `PRIMARY` of table `project_de`.`Item2TagActive` trx id 20563882256 lock_mode X locks rec but not gap RECORD LOCKS space id 190383 page no 217789 n bits 296 index `PRIMARY` of table `project_de`.`Item2TagActive` trx id 20563882256 lock_mode X locks rec but not gap RECORD LOCKS space id 190949 page no 8932 n bits 464 index `PRIMARY` of table `project_de`.`Item2TagAlternativeRank` trx id 20563882256 lock_mode X locks rec but not gap RECORD LOCKS space id 190383 page no 334194 n bits 264 index `PRIMARY` of table `project_de`.`Item2TagActive` trx id 20563882256 lock_mode X locks rec but not gap RECORD LOCKS space id 190383 page no 135846 n bits 248 index `PRIMARY` of table `project_de`.`Item2TagActive` trx id 20563882256 lock_mode X locks rec but not gap TOO MANY LOCKS PRINTED FOR THIS TRX: SUPPRESSING FURTHER PRINTS ---------------------------- END OF INNODB MONITOR OUTPUT ============================