Type Name Status InnoDB ===================================== 2014-10-22 09:25:41 7fe24d120700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 416280 srv_active, 0 srv_shutdown, 20 srv_idle srv_master_thread log flush and writes: 416300 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 159711970 OS WAIT ARRAY INFO: signal count 753530863 Mutex spin waits 528989269, rounds 474405469, OS waits 4486990 RW-shared spins 1194169757, rounds 6483807570, OS waits 129623949 RW-excl spins 107476167, rounds 1765686744, OS waits 22095182 Spin rounds per wait: 0.90 mutex, 5.43 RW-shared, 16.43 RW-excl ------------------------ ------------ TRANSACTIONS ------------ Trx id counter 20563880663 Purge done for trx's n:o < 20563880168 undo n:o < 0 state: running but idle History list length 71 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 77549913, OS thread handle 0x7fe24d120700, query id 1276843936 localhost root init show engine innodb status ---TRANSACTION 20563880658, not started MySQL thread id 77549914, OS thread handle 0x7fe24c83d700, query id 1276843945 192.168.0.102 project_web cleaning up ---TRANSACTION 20563880655, not started MySQL thread id 77549915, OS thread handle 0x7fe24c941700, query id 1276843941 192.168.0.102 project_web cleaning up ---TRANSACTION 20563880638, not started mysql tables in use 5, locked 0 MySQL thread id 77549905, OS thread handle 0x7fe24c87e700, query id 1276843949 192.168.0.102 project_web preparing SELECT 'trend' AS `id`, t.`name` AS `value`, t.`adjective` AS `adjective`, t.`tagId` AS `valueId`, t.`seoId` , tmp.`cnt` AS `count` FROM ( SELECT it0.`tagId`, COUNT(*) AS cnt FROM `Item2TagActive` AS it0 INNER JOIN Item2TagActive `it2` ON (it2.`itemId` = it0.`itemId`) INNER JOIN Item2TagActive `it3` ON (it ---TRANSACTION 20563880635, not started mysql tables in use 5, locked 0 MySQL thread id 77549906, OS thread handle 0x7fe247e38700, query id 1276843951 192.168.0.102 project_web statistics SELECT 'style' AS `id`, t.`name` AS `value`, t.`adjective` AS `adjective`, t.`tagId` AS `valueId`, t.`seoId` , tmp.`cnt` AS `count` FROM ( SELECT it0.`tagId`, COUNT(*) AS cnt FROM `Item2TagActive` AS it0 INNER JOIN Item2TagActive `it2` ON (it2.`itemId` = it0.`itemId`) INNER JOIN Item2TagActive `it3` ON (it ---TRANSACTION 20563880631, not started MySQL thread id 77549911, OS thread handle 0x7fe24c102700, query id 1276843954 192.168.0.102 project_web init SELECT 'category' AS `id`, t.`name` AS `value`, t.`tagId` AS `valueId`, t.`seoId`, '-1' AS count FROM ( SELECT it0.`tagId` FROM `Item2TagActive` AS it0 INNER JOIN Item2TagActive `it2` ON (it2.`itemId` = it0.`itemId`) INNER JOIN Item2TagActive `it3` ON (it3.`itemId` = it0.`itemId`) INNER JOIN Item2TagActive `it4` ON (it4.`itemId` = it0 ---TRANSACTION 20563880634, not started MySQL thread id 77549912, OS thread handle 0x7fe24d42c700, query id 1276843915 192.168.0.102 project_web cleaning up ---TRANSACTION 20563880630, not started MySQL thread id 77549907, OS thread handle 0x7fe2479e7700, query id 1276843911 192.168.0.102 project_web cleaning up ---TRANSACTION 20563880633, not started starting index read, thread declared inside InnoDB 5000 mysql tables in use 4, locked 0 MySQL thread id 77549910, OS thread handle 0x7fe24ca04700, query id 1276843952 192.168.0.102 project_web Sending data SELECT x.* , 'provider' AS `id` , d.`seoId` AS `valueId` , d.`name` AS `value` , d.`seoId` FROM ( SELECT COUNT(*) AS `count`, it0.`dataProviderId` FROM `Item2TagActive` AS it0 INNER JOIN Item2TagActive `it3` ON (it3.`itemId` = it0.`itemId`) INNER JOIN Item2TagActive `it4` ON (it4.`itemId` = it0.`itemId`) WHERE it0.`price` BETWEEN 10 ---TRANSACTION 20563880632, not started mysql tables in use 5, locked 0 MySQL thread id 77549909, OS thread handle 0x7fe247eba700, query id 1276843950 192.168.0.102 project_web Sorting result SELECT 'type' AS `id`, t.`name` AS `value`, t.`adjective` AS `adjective`, t.`tagId` AS `valueId`, t.`seoId` , tmp.`cnt` AS `count` FROM ( SELECT it0.`tagId`, COUNT(*) AS cnt FROM `Item2TagActive` AS it0 INNER JOIN Item2TagActive `it2` ON (it2.`itemId` = it0.`itemId`) INNER JOIN Item2TagActive `it3` ON (it3 ---TRANSACTION 20563880629, not started MySQL thread id 77549908, OS thread handle 0x7fe24cccf700, query id 1276843912 192.168.0.102 project_web cleaning up ---TRANSACTION 20563880627, not started MySQL thread id 77549895, OS thread handle 0x7fe24d2a6700, query id 1276843907 192.168.0.102 project_web cleaning up ---TRANSACTION 20563880582, not started MySQL thread id 77549893, OS thread handle 0x7fe247df7700, query id 1276843845 192.168.0.102 project_web cleaning up ---TRANSACTION 20563880613, not started MySQL thread id 77549894, OS thread handle 0x7fe24c6b7700, query id 1276843878 192.168.0.102 project_web cleaning up ---TRANSACTION 20563880545, not started MySQL thread id 77549891, OS thread handle 0x7fe247f3c700, query id 1276843805 192.168.0.102 project_web cleaning up ---TRANSACTION 20563880570, not started MySQL thread id 77549892, OS thread handle 0x7fe24ca45700, query id 1276843830 192.168.0.102 project_web cleaning up ---TRANSACTION 20563880568, not started MySQL thread id 77531611, OS thread handle 0x7fe24d6b6700, query id 1276843828 192.168.0.101 project_backend cleaning up ---TRANSACTION 20563880522, not started MySQL thread id 77499427, OS thread handle 0x7fe254054700, query id 1276843778 192.168.0.101 project_backend cleaning up ---TRANSACTION 20563880663, not started committing, thread declared inside InnoDB 4983 mysql tables in use 3, locked 0 MySQL thread id 77040534, OS thread handle 0x7fe24d265700, query id 1276843953 192.168.0.101 project_backend query end SELECT ita.`tagId`, IFNULL(dpr.`value`,dp.`rank`) AS `rank` FROM `Item2TagActive` AS ita JOIN `DataProvider` AS dp ON dp.`dataProviderId` = ita.`dataProviderId` LEFT JOIN `DataProviderRank` AS dpr ON dpr.`dataProviderId` = ita.`dataProviderId` AND dpr.`tagId` = ita.`tagId` WHERE ita.`itemId` = 3430624 ---TRANSACTION 20563879148, not started MySQL thread id 77040533, OS thread handle 0x7fe247d75700, query id 1276841979 192.168.0.101 project_backend cleaning up ---TRANSACTION 20563880135, not started MySQL thread id 76594273, OS thread handle 0x7fe24d7fb700, query id 1276843285 192.168.0.101 project_backend cleaning up ---TRANSACTION 20563877937, not started MySQL thread id 76594272, OS thread handle 0x7fe24779e700, query id 1276829498 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 20563880543, ACTIVE 0 sec 1313 lock struct(s), heap size 177704, 15266 row lock(s) MySQL thread id 77499424, OS thread handle 0x7fe24d01c700, query id 1276843871 192.168.0.101 project_backend cleaning up Trx read view will not see trx with id >= 20563880544, sees < 20563880544 TABLE LOCK table `project_de`.`Item` trx id 20563880543 lock mode IS RECORD LOCKS space id 190191 page no 207229 n bits 96 index `PRIMARY` of table `project_de`.`Item` trx id 20563880543 lock mode S locks rec but not gap TABLE LOCK table `project_de`.`Item2Tag` trx id 20563880543 lock mode IS RECORD LOCKS space id 190714 page no 151445 n bits 488 index `PRIMARY` of table `project_de`.`Item2Tag` trx id 20563880543 lock mode S RECORD LOCKS space id 190714 page no 151445 n bits 488 index `PRIMARY` of table `project_de`.`Item2Tag` trx id 20563880543 lock mode S locks gap before rec RECORD LOCKS space id 190191 page no 207229 n bits 96 index `PRIMARY` of table `project_de`.`Item` trx id 20563880543 lock mode S RECORD LOCKS space id 190191 page no 207409 n bits 96 index `PRIMARY` of table `project_de`.`Item` trx id 20563880543 lock mode S RECORD LOCKS space id 190191 page no 207177 n bits 88 index `PRIMARY` of table `project_de`.`Item` trx id 20563880543 lock mode S RECORD LOCKS space id 190191 page no 207231 n bits 88 index `PRIMARY` of table `project_de`.`Item` trx id 20563880543 lock mode S RECORD LOCKS space id 190191 page no 207233 n bits 96 index `PRIMARY` of table `project_de`.`Item` trx id 20563880543 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 118847522 OS file reads, 158885697 OS file writes, 25368130 OS fsyncs 470.97 reads/s, 15454 avg bytes/read, 673.65 writes/s, 69.12 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 23230, seg size 23232, 13236747 merges merged operations: insert 15560582, delete mark 22859617, delete 6671020 discarded operations: insert 0, delete mark 0, delete 0 256856.45 hash searches/s, 338392.16 non-hash searches/s --- LOG --- Log sequence number 8552250168580 Log flushed up to 8552250168552 Pages flushed up to 8552150944914 Last checkpoint at 8552146449178 Max checkpoint age 430379460 Checkpoint age target 416930102 Modified age 99223666 Checkpoint age 103719402 0 pending log writes, 0 pending chkp writes 12942291 log i/o's done, 35.25 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 54945382400; in additional pool allocated 0 Total memory allocated by read views 4128 Internal hash tables (constant factor + variable factor) Adaptive hash index 7721344928 \t(849989432 + 6871355496) Page hash 6641384 (buffer pool 0 only) Dictionary cache 216083025 \t(212498864 + 3584161) File system 1027960 \t(812272 + 215688) Lock system 147852592 \t(147837832 + 14760) Recovery system 0 \t(0 + 0) Dictionary memory allocated 3584161 Buffer pool size 3276792 Buffer pool size, bytes 53686960128 Free buffers 8255 Database pages 2813762 Old database pages 1038510 Modified db pages 72264 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 212060113, not young 9990268865 421.97 youngs/s, 66977.81 non-youngs/s Pages read 118847468, created 4704965, written 141299741 470.97 reads/s, 6.06 creates/s, 627.15 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 34 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 2813762, unzip_LRU len: 144865 I/O sum[574464]:cur[8], unzip sum[20528]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 409599 Buffer pool size, bytes 6710870016 Free buffers 1033 Database pages 352099 Old database pages 129954 Modified db pages 9223 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 27518743, not young 1250135999 53.56 youngs/s, 8707.08 non-youngs/s Pages read 15273306, created 596501, written 18147152 53.93 reads/s, 1.75 creates/s, 89.06 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 40 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 352099, unzip_LRU len: 16697 I/O sum[71808]:cur[1], unzip sum[2566]:cur[0] ---BUFFER POOL 1 Buffer pool size 409599 Buffer pool size, bytes 6710870016 Free buffers 1037 Database pages 351410 Old database pages 129699 Modified db pages 9172 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 25493045, not young 1213507223 46.62 youngs/s, 8371.23 non-youngs/s Pages read 14295611, created 591938, written 17468191 63.12 reads/s, 0.50 creates/s, 79.62 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 45 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 351410, unzip_LRU len: 18676 I/O sum[71808]:cur[1], unzip sum[2566]:cur[0] ---BUFFER POOL 2 Buffer pool size 409599 Buffer pool size, bytes 6710870016 Free buffers 1033 Database pages 351497 Old database pages 129731 Modified db pages 8327 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 26169497, not young 1253817916 54.18 youngs/s, 8475.53 non-youngs/s Pages read 14883414, created 594069, written 17418167 58.00 reads/s, 0.25 creates/s, 71.68 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 25 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 351497, unzip_LRU len: 19152 I/O sum[71808]:cur[1], unzip sum[2566]:cur[0] ---BUFFER POOL 3 Buffer pool size 409599 Buffer pool size, bytes 6710870016 Free buffers 1034 Database pages 351904 Old database pages 129882 Modified db pages 9893 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 26887300, not young 1263835854 50.56 youngs/s, 8580.28 non-youngs/s Pages read 15181149, created 600641, written 17796639 56.81 reads/s, 0.25 creates/s, 84.18 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 56 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 351904, unzip_LRU len: 17787 I/O sum[71808]:cur[1], unzip sum[2566]:cur[0] ---BUFFER POOL 4 Buffer pool size 409599 Buffer pool size, bytes 6710870016 Free buffers 1031 Database pages 351955 Old database pages 129900 Modified db pages 9078 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 26483684, not young 1226018171 51.93 youngs/s, 7385.85 non-youngs/s Pages read 14446394, created 537119, written 17710763 54.25 reads/s, 1.87 creates/s, 73.31 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 31 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 351955, unzip_LRU len: 16785 I/O sum[71808]:cur[1], unzip sum[2566]:cur[0] ---BUFFER POOL 5 Buffer pool size 409599 Buffer pool size, bytes 6710870016 Free buffers 1032 Database pages 351816 Old database pages 129849 Modified db pages 8292 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 26744698, not young 1263777421 49.43 youngs/s, 8027.44 non-youngs/s Pages read 14933069, created 583338, written 17285139 51.81 reads/s, 0.00 creates/s, 76.75 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 51 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 351816, unzip_LRU len: 17544 I/O sum[71808]:cur[1], unzip sum[2566]:cur[0] ---BUFFER POOL 6 Buffer pool size 409599 Buffer pool size, bytes 6710870016 Free buffers 1030 Database pages 351458 Old database pages 129717 Modified db pages 8968 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 26890306, not young 1238119167 63.31 youngs/s, 8617.46 non-youngs/s Pages read 14890204, created 604303, written 17752874 65.87 reads/s, 1.06 creates/s, 76.06 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: 351458, unzip_LRU len: 19484 I/O sum[71808]:cur[1], unzip sum[2566]:cur[0] ---BUFFER POOL 7 Buffer pool size 409599 Buffer pool size, bytes 6710870016 Free buffers 1025 Database pages 351623 Old database pages 129778 Modified db pages 9311 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 25872840, not young 1281057114 52.37 youngs/s, 8812.95 non-youngs/s Pages read 14944321, created 597056, written 17720816 67.18 reads/s, 0.37 creates/s, 76.50 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 19 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 351623, unzip_LRU len: 18740 I/O sum[71808]:cur[1], unzip sum[2566]:cur[0] -------------- ROW OPERATIONS -------------- 8 queries inside InnoDB, 0 queries in queue 8 read views open inside InnoDB 0 RW transactions active inside InnoDB 0 RO transactions active inside InnoDB 0 out of 1000 descriptors used ---OLDEST VIEW--- Normal read view Read view low limit trx n:o 20563880619 Read view up limit trx id 20563880543 Read view low limit trx id 20563880619 Read view individually stored trx ids: Read view trx id 20563880543 ----------------- Main thread process no. 9779, id 140610117498624, state: sleeping Number of rows inserted 69831000, updated 458074822, deleted 81143261, read 483445313960 24.50 inserts/s, 3855.51 updates/s, 0.00 deletes/s, 996718.89 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 20563880696 Purge done for trx's n:o < 20563880168 undo n:o < 0 state: running but idle History list length 71 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 77549913, OS thread handle 0x7fe24d120700, query id 1276843936 localhost root init show engine innodb status ---TRANSACTION 20563880658, not started MySQL thread id 77549914, OS thread handle 0x7fe24c83d700, query id 1276843945 192.168.0.102 project_web cleaning up ---TRANSACTION 20563880655, not started MySQL thread id 77549915, OS thread handle 0x7fe24c941700, query id 1276843941 192.168.0.102 project_web cleaning up ---TRANSACTION 20563880668, not started MySQL thread id 77549905, OS thread handle 0x7fe24c87e700, query id 1276843949 192.168.0.102 project_web cleaning up ---TRANSACTION 20563880669, not started MySQL thread id 77549906, OS thread handle 0x7fe247e38700, query id 1276843951 192.168.0.102 project_web cleaning up ---TRANSACTION 20563880672, not started MySQL thread id 77549911, OS thread handle 0x7fe24c102700, query id 1276843954 192.168.0.102 project_web cleaning up ---TRANSACTION 20563880634, not started MySQL thread id 77549912, OS thread handle 0x7fe24d42c700, query id 1276843915 192.168.0.102 project_web cleaning up ---TRANSACTION 20563880670, not started MySQL thread id 77549907, OS thread handle 0x7fe2479e7700, query id 1276843955 192.168.0.102 project_web cleaning up ---TRANSACTION 20563880667, not started MySQL thread id 77549909, OS thread handle 0x7fe247eba700, query id 1276843950 192.168.0.102 project_web cleaning up ---TRANSACTION 20563880626, not started MySQL thread id 77549900, OS thread handle 0x7fe24771c700, query id 1276843900 192.168.0.102 project_web cleaning up ---TRANSACTION 20563880623, not started MySQL thread id 77549899, OS thread handle 0x7fe25421b700, query id 1276843899 192.168.0.102 project_web cleaning up ---TRANSACTION 20563880619, not started MySQL thread id 77549904, OS thread handle 0x7fe24c572700, query id 1276843897 192.168.0.102 project_web cleaning up ---TRANSACTION 20563880627, not started MySQL thread id 77549895, OS thread handle 0x7fe24d2a6700, query id 1276843907 192.168.0.102 project_web cleaning up ---TRANSACTION 20563880659, not started MySQL thread id 77549896, OS thread handle 0x7fe24c329700, query id 1276843944 192.168.0.102 project_web cleaning up ---TRANSACTION 20563880582, not started MySQL thread id 77549893, OS thread handle 0x7fe247df7700, query id 1276843845 192.168.0.102 project_web cleaning up ---TRANSACTION 20563880613, not started MySQL thread id 77549894, OS thread handle 0x7fe24c6b7700, query id 1276843878 192.168.0.102 project_web cleaning up ---TRANSACTION 20563880545, not started MySQL thread id 77549891, OS thread handle 0x7fe247f3c700, query id 1276843805 192.168.0.102 project_web cleaning up ---TRANSACTION 20563880570, not started MySQL thread id 77549892, OS thread handle 0x7fe24ca45700, query id 1276843830 192.168.0.102 project_web cleaning up ---TRANSACTION 20563880568, not started MySQL thread id 77531611, OS thread handle 0x7fe24d6b6700, query id 1276843828 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 20563880695, not started MySQL thread id 77040534, OS thread handle 0x7fe24d265700, query id 1276843997 192.168.0.101 project_backend cleaning up ---TRANSACTION 20563879148, not started MySQL thread id 77040533, OS thread handle 0x7fe247d75700, query id 1276841979 192.168.0.101 project_backend cleaning up ---TRANSACTION 20563880135, not started MySQL thread id 76594273, OS thread handle 0x7fe24d7fb700, query id 1276843285 192.168.0.101 project_backend cleaning up ---TRANSACTION 20563877937, not started MySQL thread id 76594272, OS thread handle 0x7fe24779e700, query id 1276829498 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 ---------------------------- END OF INNODB MONITOR OUTPUT ============================