*************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2014-10-15 09:18:16 7fb1ef75d700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 21 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 81375 srv_active, 0 srv_shutdown, 32 srv_idle srv_master_thread log flush and writes: 81407 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 23393484 OS WAIT ARRAY INFO: signal count 140386607 Mutex spin waits 79023155, rounds 87397400, OS waits 967369 RW-shared spins 197092944, rounds 951609752, OS waits 18411350 RW-excl spins 22009890, rounds 313340345, OS waits 3533296 Spin rounds per wait: 1.11 mutex, 4.83 RW-shared, 14.24 RW-excl ------------------------ LATEST DETECTED DEADLOCK ------------------------ 2014-10-15 08:29:03 7fb21c669700 *** (1) TRANSACTION: TRANSACTION 19524330595, ACTIVE 4 sec starting index read mysql tables in use 2, locked 2 LOCK WAIT 152 lock struct(s), heap size 30248, 404 row lock(s), undo log entries 349 MySQL thread id 8878698, OS thread handle 0x7fbf38170700, query id 157896422 192.168.1.101 our_project_backend Sending data SELECT it.`itemId`, COUNT(*) AS `count`FROM `XYZ` AS it JOIN `Tag` AS t ON t.`colId` = it.`colId` WHERE t.`colTypeId` = 2 AND it.`itemId` IN (2786862) GROUP BY `itemId` FOR UPDATE *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 190842 page no 15 n bits 200 index `PRIMARY` of table `our_project_de`.`Tag` trx id 19524330595 lock_mode X locks rec but not gap waiting *** (2) TRANSACTION: TRANSACTION 19524330568, ACTIVE 4 sec inserting, thread declared inside InnoDB 4965 mysql tables in use 23, locked 23 4581 lock struct(s), heap size 620072, 35858 row lock(s), undo log entries 35619 MySQL thread id 8853354, OS thread handle 0x7fb21c669700, query id 157930621 192.168.1.101 our_project_backend Sending data INSERT INTO xyz(colId, colId2, colTypeId2, items) SELECT ita.colId, ita2.colId AS colId2, ita2.colTypeId, COUNT(*) AS items FROM .... ON DUPLICATE KEY UPDATE colId = VALUES(colId), colId2 = VALUES(colId2), colTypeId2 = VALUES(colTypeId2), items = (items + VALUES(items)) *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 190842 page no 15 n bits 200 index `PRIMARY` of table `our_project_de`.`Tag` trx id 19524330568 lock mode S locks rec but not gap *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 190371 page no 9544 n bits 576 index `PRIMARY` of table `our_project_de`.`XFilterTag` trx id 19524330568 lock_mode X locks rec but not gap waiting *** WE ROLL BACK TRANSACTION (1) ------------ TRANSACTIONS ------------ Trx id counter 19527763943 Purge done for trx's n:o < 19527763572 undo n:o < 0 state: running but idle History list length 684 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 9259624, OS thread handle 0x7fb1ef75d700, query id 170287178 localhost root init show engine innodb status ---TRANSACTION 19527763936, not started MySQL thread id 9259620, OS thread handle 0x7fb1efaeb700, query id 170287180 192.168.1.102 our_project_web cleaning up ---TRANSACTION 19527763942, not started MySQL thread id 9259621, OS thread handle 0x7fbf38170700, query id 170287187 192.168.1.102 our_project_web cleaning up ---TRANSACTION 19527763855, not started MySQL thread id 9226012, OS thread handle 0x7fb1ef8a2700, query id 170287034 192.168.1.101 our_project_backend cleaning up ---TRANSACTION 19527763935, not started MySQL thread id 9222276, OS thread handle 0x7fb1efefb700, query id 170287176 192.168.1.101 our_project_backend cleaning up ---TRANSACTION 19527424087, not started MySQL thread id 9214184, OS thread handle 0x7fb214a11700, query id 169823059 192.168.1.101 our_project_backend cleaning up ---TRANSACTION 19527763576, not started MySQL thread id 9199729, OS thread handle 0x7fb1efb6d700, query id 170286618 192.168.1.101 our_project_backend cleaning up ---TRANSACTION 19527763539, not started MySQL thread id 8946831, OS thread handle 0x7fb2150ab700, query id 170286529 192.168.1.101 our_project_backend cleaning up ---TRANSACTION 19527753965, not started MySQL thread id 8946830, OS thread handle 0x7fb216a77700, query id 170271879 192.168.1.101 our_project_backend cleaning up ---TRANSACTION 19527419990, not started MySQL thread id 6220855, OS thread handle 0x7fb1ef7df700, query id 109105407 Slave has read all relay log; waiting for the slave I/O thread to update it ---TRANSACTION 19527762971, not started MySQL thread id 6054129, OS thread handle 0x7fb21c196700, query id 170285680 192.168.1.101 our_project_backend cleaning up ---TRANSACTION 19527330859, not started MySQL thread id 6054128, OS thread handle 0x7fb21c114700, query id 169415513 192.168.1.101 our_project_backend cleaning up ---TRANSACTION 19527763941, ACTIVE 0 sec 74 lock struct(s), heap size 13864, 7178 row lock(s) MySQL thread id 9222275, OS thread handle 0x7fb21416f700, query id 170287186 192.168.1.101 our_project_backend cleaning up Trx read view will not see trx with id >= 19527763942, sees < 19527763942 TABLE LOCK table `our_project_cz`.`X` trx id 19527763941 lock mode IS RECORD LOCKS space id 190766 page no 209779 n bits 112 index `PRIMARY` of table `our_project_cz`.`X` trx id 19527763941 lock mode S locks rec but not gap TABLE LOCK table `our_project_cz`.`XYZ` trx id 19527763941 lock mode IS RECORD LOCKS space id 190715 page no 296640 n bits 496 index `PRIMARY` of table `our_project_cz`.`XYZ` trx id 19527763941 lock mode S RECORD LOCKS space id 190715 page no 296640 n bits 496 index `PRIMARY` of table `our_project_cz`.`XYZ` trx id 19527763941 lock mode S locks gap before rec RECORD LOCKS space id 190766 page no 209779 n bits 112 index `PRIMARY` of table `our_project_cz`.`X` trx id 19527763941 lock mode S RECORD LOCKS space id 190766 page no 209780 n bits 104 index `PRIMARY` of table `our_project_cz`.`X` trx id 19527763941 lock mode S RECORD LOCKS space id 190715 page no 426578 n bits 448 index `PRIMARY` of table `our_project_cz`.`XYZ` trx id 19527763941 lock mode S RECORD LOCKS space id 190715 page no 426578 n bits 448 index `PRIMARY` of table `our_project_cz`.`XYZ` trx id 19527763941 lock mode S locks gap before rec RECORD LOCKS space id 190766 page no 209781 n bits 96 index `PRIMARY` of table `our_project_cz`.`X` trx id 19527763941 lock mode S 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 20380591 OS file reads, 34454558 OS file writes, 8488431 OS fsyncs 714.78 reads/s, 16019 avg bytes/read, 73.38 writes/s, 27.95 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 23374, seg size 23376, 2121502 merges merged operations: insert 2931395, delete mark 8803053, delete 4509849 discarded operations: insert 0, delete mark 0, delete 0 403336.75 hash searches/s, 418213.85 non-hash searches/s --- LOG --- Log sequence number 8154781247870 Log flushed up to 8154781247760 Pages flushed up to 8154721177524 Last checkpoint at 8154719965359 Max checkpoint age 430379460 Checkpoint age target 416930102 Modified age 60070346 Checkpoint age 61282511 0 pending log writes, 0 pending chkp writes 6211882 log i/o's done, 12.90 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 54945382400; in additional pool allocated 0 Total memory allocated by read views 1680 Internal hash tables (constant factor + variable factor) Adaptive hash index 10074464160 (849989432 + 9224474728) Page hash 6641384 (buffer pool 0 only) Dictionary cache 215972806 (212498864 + 3473942) File system 1020208 (812272 + 207936) Lock system 147971424 (147837832 + 133592) Recovery system 0 (0 + 0) Dictionary memory allocated 3473942 Buffer pool size 3276792 Buffer pool size, bytes 53686960128 Free buffers 7397 Database pages 2701985 Old database pages 997369 Modified db pages 16618 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 31479365, not young 1863998285 739.30 youngs/s, 291012.09 non-youngs/s Pages read 20380281, created 920470, written 27368411 714.82 reads/s, 4.67 creates/s, 53.62 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 132 / 1000 Pages read ahead 426.12/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 2701985, unzip_LRU len: 34451 I/O sum[148256]:cur[1104], unzip sum[11480]:cur[16] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 409599 Buffer pool size, bytes 6710870016 Free buffers 986 Database pages 337670 Old database pages 124627 Modified db pages 2171 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 4135440, not young 233389369 79.09 youngs/s, 27063.00 non-youngs/s Pages read 2601039, created 115777, written 3577341 71.28 reads/s, 0.19 creates/s, 4.86 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 113 / 1000 Pages read ahead 42.66/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 337670, unzip_LRU len: 3736 I/O sum[18532]:cur[138], unzip sum[1435]:cur[2] ---BUFFER POOL 1 Buffer pool size 409599 Buffer pool size, bytes 6710870016 Free buffers 983 Database pages 337704 Old database pages 124640 Modified db pages 1863 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 3725406, not young 225580690 133.37 youngs/s, 42360.13 non-youngs/s Pages read 2464281, created 115853, written 3380622 83.95 reads/s, 0.05 creates/s, 5.14 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 207 / 1000 Pages read ahead 48.76/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 337704, unzip_LRU len: 4151 I/O sum[18532]:cur[138], unzip sum[1435]:cur[2] ---BUFFER POOL 2 Buffer pool size 409599 Buffer pool size, bytes 6710870016 Free buffers 904 Database pages 337590 Old database pages 124636 Modified db pages 1964 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 3885713, not young 230977891 76.00 youngs/s, 27943.38 non-youngs/s Pages read 2549908, created 118637, written 3362901 67.47 reads/s, 0.05 creates/s, 7.33 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 76 / 1000 Pages read ahead 35.76/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 337590, unzip_LRU len: 4706 I/O sum[18532]:cur[138], unzip sum[1435]:cur[2] ---BUFFER POOL 3 Buffer pool size 409599 Buffer pool size, bytes 6710870016 Free buffers 917 Database pages 337883 Old database pages 124735 Modified db pages 2103 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 3993275, not young 234215267 88.52 youngs/s, 40818.29 non-youngs/s Pages read 2593453, created 117377, written 3429352 101.47 reads/s, 0.00 creates/s, 6.29 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 235 / 1000 Pages read ahead 60.95/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 337883, unzip_LRU len: 4449 I/O sum[18532]:cur[138], unzip sum[1435]:cur[2] ---BUFFER POOL 4 Buffer pool size 409599 Buffer pool size, bytes 6710870016 Free buffers 898 Database pages 337465 Old database pages 124552 Modified db pages 2342 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 3939734, not young 237033000 110.52 youngs/s, 39621.45 non-youngs/s Pages read 2523273, created 111276, written 3420463 96.76 reads/s, 1.81 creates/s, 5.24 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 154 / 1000 Pages read ahead 60.95/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 337465, unzip_LRU len: 5083 I/O sum[18532]:cur[138], unzip sum[1435]:cur[2] ---BUFFER POOL 5 Buffer pool size 409599 Buffer pool size, bytes 6710870016 Free buffers 898 Database pages 337945 Old database pages 124766 Modified db pages 1873 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 3993642, not young 236041605 96.57 youngs/s, 34001.29 non-youngs/s Pages read 2544165, created 112068, written 3387778 91.85 reads/s, 0.05 creates/s, 6.90 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 182 / 1000 Pages read ahead 54.85/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 337945, unzip_LRU len: 3866 I/O sum[18532]:cur[138], unzip sum[1435]:cur[2] ---BUFFER POOL 6 Buffer pool size 409599 Buffer pool size, bytes 6710870016 Free buffers 841 Database pages 337848 Old database pages 124708 Modified db pages 2019 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 3948146, not young 231762777 77.52 youngs/s, 47357.03 non-youngs/s Pages read 2563759, created 114239, written 3406142 115.23 reads/s, 0.24 creates/s, 8.19 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 205 / 1000 Pages read ahead 76.47/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 337848, unzip_LRU len: 4448 I/O sum[18532]:cur[138], unzip sum[1435]:cur[2] ---BUFFER POOL 7 Buffer pool size 409599 Buffer pool size, bytes 6710870016 Free buffers 970 Database pages 337880 Old database pages 124705 Modified db pages 2283 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 3858009, not young 234997686 77.71 youngs/s, 31847.53 non-youngs/s Pages read 2540403, created 115243, written 3403812 86.81 reads/s, 2.29 creates/s, 9.67 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 58 / 1000 Pages read ahead 45.71/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 337880, unzip_LRU len: 4012 I/O sum[18532]:cur[138], unzip sum[1435]:cur[2] -------------- ROW OPERATIONS -------------- 3 queries inside InnoDB, 0 queries in queue 4 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 19527763480 Read view up limit trx id 19527763471 Read view low limit trx id 19527763480 Read view individually stored trx ids: Read view trx id 19527763471 ----------------- Main thread process no. 12868, id 140402990458624, state: sleeping Number of rows inserted 31341549, updated 99971608, deleted 15285413, read 57947169435 22.81 inserts/s, 3.76 updates/s, 0.00 deletes/s, 1216578.35 reads/s ------------------------ LATEST DETECTED DEADLOCK ------------------------ 2014-10-15 08:29:03 7fb21c669700 *** (1) TRANSACTION: TRANSACTION 19524330595, ACTIVE 4 sec starting index read mysql tables in use 2, locked 2 LOCK WAIT 152 lock struct(s), heap size 30248, 404 row lock(s), undo log entries 349 MySQL thread id 8878698, OS thread handle 0x7fbf38170700, query id 157896422 192.168.1.101 our_project_backend Sending data SELECT it.`itemId`, COUNT(*) AS `count`FROM `XYZ` AS it JOIN `Tag` AS t ON t.`colId` = it.`colId` WHERE t.`colTypeId` = 2 AND it.`itemId` IN (2786862) GROUP BY `itemId` FOR UPDATE *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 190842 page no 15 n bits 200 index `PRIMARY` of table `our_project_de`.`Tag` trx id 19524330595 lock_mode X locks rec but not gap waiting *** (2) TRANSACTION: TRANSACTION 19524330568, ACTIVE 4 sec inserting, thread declared inside InnoDB 4965 mysql tables in use 23, locked 23 4581 lock struct(s), heap size 620072, 35858 row lock(s), undo log entries 35619 MySQL thread id 8853354, OS thread handle 0x7fb21c669700, query id 157930621 192.168.1.101 our_project_backend Sending data INSERT INTO XFilterTag(colId, colId2, colTypeId2, items) SELECT ita.colId, ita2.colId AS colId2, ita2.colTypeId, COUNT(*) AS items FROM XYZActive ita JOIN XYZActive ita2 ON ita.itemId = ita2.itemId AND ita.colId != ita2.colId WHERE ita2.colTypeId IS NOT NULL AND ita.colId = NEW.colId AND ita.itemId = NEW.itemId GROUP BY ita.colId, colId2 ORDER BY NULL ON DUPLICATE KEY UPDATE colId = VALUES(colId), colId2 = VALUES(colId2), colTypeId2 = VALUES(colTypeId2), items = (items + VALUES(items)) *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 190842 page no 15 n bits 200 index `PRIMARY` of table `our_project_de`.`Tag` trx id 19524330568 lock mode S locks rec but not gap *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 190371 page no 9544 n bits 576 index `PRIMARY` of table `our_project_de`.`XFilterTag` trx id 19524330568 lock_mode X locks rec but not gap waiting *** WE ROLL BACK TRANSACTION (1) ------------ TRANSACTIONS ------------ Trx id counter 19527763960 Purge done for trx's n:o < 19527763572 undo n:o < 0 state: running but idle History list length 684 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 19527763959, not started MySQL thread id 9259627, OS thread handle 0x7fb2166e9700, query id 170287213 192.168.1.102 our_project_web cleaning up ---TRANSACTION 19527763957, not started MySQL thread id 9259632, OS thread handle 0x7fb2145c0700, query id 170287220 192.168.1.102 our_project_web cleaning up ---TRANSACTION 19527763958, not started MySQL thread id 9259631, OS thread handle 0x7fb1ef861700, query id 170287219 192.168.1.102 our_project_web cleaning up ---TRANSACTION 19527763956, not started MySQL thread id 9259629, OS thread handle 0x7fb21457f700, query id 170287216 192.168.1.102 our_project_web cleaning up ---TRANSACTION 19527763955, not started MySQL thread id 9259634, OS thread handle 0x7fb214de0700, query id 170287218 192.168.1.102 our_project_web cleaning up ---TRANSACTION 19527763954, not started MySQL thread id 9259630, OS thread handle 0x7fb1ef9e7700, query id 170287215 192.168.1.102 our_project_web cleaning up ---TRANSACTION 19527763952, not started MySQL thread id 9259633, OS thread handle 0x7fb214d9f700, query id 170287217 192.168.1.102 our_project_web cleaning up ---TRANSACTION 19527763949, not started MySQL thread id 9259625, OS thread handle 0x7fb1efdb6700, query id 170287202 192.168.1.102 our_project_web cleaning up ---TRANSACTION 19527763951, not started MySQL thread id 9259626, OS thread handle 0x7fb2150ec700, query id 170287204 192.168.1.102 our_project_web cleaning up ---TRANSACTION 0, not started MySQL thread id 9259624, OS thread handle 0x7fb1ef75d700, query id 170287178 localhost root init show engine innodb status ---TRANSACTION 19527763855, not started MySQL thread id 9226012, OS thread handle 0x7fb1ef8a2700, query id 170287034 192.168.1.101 our_project_backend cleaning up ---TRANSACTION 19527763935, not started MySQL thread id 9222276, OS thread handle 0x7fb1efefb700, query id 170287176 192.168.1.101 our_project_backend cleaning up ---TRANSACTION 19527424087, not started MySQL thread id 9214184, OS thread handle 0x7fb214a11700, query id 169823059 192.168.1.101 our_project_backend cleaning up ---TRANSACTION 19527763576, not started MySQL thread id 9199729, OS thread handle 0x7fb1efb6d700, query id 170286618 192.168.1.101 our_project_backend cleaning up ---TRANSACTION 19527763539, not started MySQL thread id 8946831, OS thread handle 0x7fb2150ab700, query id 170286529 192.168.1.101 our_project_backend cleaning up ---TRANSACTION 19527753965, not started MySQL thread id 8946830, OS thread handle 0x7fb216a77700, query id 170271879 192.168.1.101 our_project_backend cleaning up ---TRANSACTION 19527419990, not started MySQL thread id 6220855, OS thread handle 0x7fb1ef7df700, query id 109105407 Slave has read all relay log; waiting for the slave I/O thread to update it ---TRANSACTION 19527762971, not started MySQL thread id 6054129, OS thread handle 0x7fb21c196700, query id 170285680 192.168.1.101 our_project_backend cleaning up ---TRANSACTION 19527330859, not started MySQL thread id 6054128, OS thread handle 0x7fb21c114700, query id 169415513 192.168.1.101 our_project_backend cleaning up ---TRANSACTION 19527763941, ACTIVE 0 sec 1431 lock struct(s), heap size 194088, 15267 row lock(s) MySQL thread id 9222275, OS thread handle 0x7fb21416f700, query id 170287201 192.168.1.101 our_project_backend cleaning up Trx read view will not see trx with id >= 19527763942, sees < 19527763942 TABLE LOCK table `our_project_cz`.`X` trx id 19527763941 lock mode IS RECORD LOCKS space id 190766 page no 209779 n bits 112 index `PRIMARY` of table `our_project_cz`.`X` trx id 19527763941 lock mode S locks rec but not gap TABLE LOCK table `our_project_cz`.`XYZ` trx id 19527763941 lock mode IS RECORD LOCKS space id 190715 page no 296640 n bits 496 index `PRIMARY` of table `our_project_cz`.`XYZ` trx id 19527763941 lock mode S RECORD LOCKS space id 190715 page no 296640 n bits 496 index `PRIMARY` of table `our_project_cz`.`XYZ` trx id 19527763941 lock mode S locks gap before rec RECORD LOCKS space id 190766 page no 209779 n bits 112 index `PRIMARY` of table `our_project_cz`.`X` trx id 19527763941 lock mode S RECORD LOCKS space id 190766 page no 209780 n bits 104 index `PRIMARY` of table `our_project_cz`.`X` trx id 19527763941 lock mode S RECORD LOCKS space id 190715 page no 426578 n bits 448 index `PRIMARY` of table `our_project_cz`.`XYZ` trx id 19527763941 lock mode S RECORD LOCKS space id 190715 page no 426578 n bits 448 index `PRIMARY` of table `our_project_cz`.`XYZ` trx id 19527763941 lock mode S locks gap before rec RECORD LOCKS space id 190766 page no 209781 n bits 96 index `PRIMARY` of table `our_project_cz`.`X` trx id 19527763941 lock mode S TOO MANY LOCKS PRINTED FOR THIS TRX: SUPPRESSING FURTHER PRINTS ---------------------------- END OF INNODB MONITOR OUTPUT ============================