Here the steps executed: mysql> SELECT * FROM performance_schema.MUTEX_INSTANCES WHERE LOCKED_BY_THREAD_ID IS NOT NULL; Empty set (0.00 sec) mysql> SELECT * FROM performance_schema.RWLOCK_INSTANCES WHERE WRITE_LOCKED_BY_THREAD_ID IS NOT NULL OR READ_LOCKED_BY_COUNT IS NOT NULL; Empty set (0.00 sec) mysql> show engine innodb status\G; *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 110720 21:05:49 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 0 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 12751 1_second, 12735 sleeps, 1191 10_second, 871 background, 870 flush srv_master_thread log flush and writes: 12774 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 9242, signal count 18416 Mutex spin waits 69799, rounds 318011, OS waits 3038 RW-shared spins 9125, rounds 168468, OS waits 4693 RW-excl spins 1231, rounds 49494, OS waits 1182 Spin rounds per wait: 4.56 mutex, 18.46 RW-shared, 40.21 RW-excl ------------ TRANSACTIONS ------------ Trx id counter ACD126 Purge done for trx's n:o < ACD125 undo n:o < 0 History list length 912 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started, process no 22803, OS thread id 139689573320976 MySQL thread id 1803, query id 3486584 localhost root show engine innodb status ---TRANSACTION ACC6DF, not started, process no 22803, OS thread id 139689568262416 MySQL thread id 1641, query id 3456897 localhost root ---TRANSACTION ACB0F0, not started, process no 22803, OS thread id 139689570658576 MySQL thread id 991, query id 3377417 lim-int1-acce-01.bluestarenergy.com 10.3.251.48 ACCE_I_ACCE_03 ---TRANSACTION 95DC93, not started, process no 22803, OS thread id 139689572256016 MySQL thread id 516, query id 172274 lim-int1-wthc-01.bluestarenergy.com 10.3.251.66 WTHC_I_WTHC_02 ---TRANSACTION 95EDBA, not started, process no 22803, OS thread id 139689605536016 MySQL thread id 515, query id 220011 lim-int1-wthc-01.bluestarenergy.com 10.3.251.66 WTHC_I_WTHC_02 ---TRANSACTION 95DC8B, not started, process no 22803, OS thread id 139689572788496 MySQL thread id 514, query id 172281 lim-int1-wthc-01.bluestarenergy.com 10.3.251.66 WTHC_I_WTHC_02 ---TRANSACTION 95EC98, not started, process no 22803, OS thread id 139689573054736 MySQL thread id 343, query id 214308 lim-int1-fwcb-01.bluestarenergy.com 10.3.251.70 FWCB_I_FWCB_02 ---TRANSACTION ACD079, not started, process no 22803, OS thread id 139689574119696 MySQL thread id 134, query id 3486523 lim-int1-b2b-01.bluestarenergy.com 10.3.251.25 B2B_I_B2B_02 ---TRANSACTION ACCEF7, not started, process no 22803, OS thread id 139691440118032 MySQL thread id 207, query id 3478368 lim-int1-b2b-01.bluestarenergy.com 10.3.251.25 B2B_I_B2B_02 ---TRANSACTION ACCEEC, not started, process no 22803, OS thread id 139691440384272 MySQL thread id 82, query id 3478106 lim-int1-b2bg-01.bluestarenergy.com 10.3.251.26 GISB_I_B2BG_02 ---TRANSACTION ACB8E8, not started, process no 22803, OS thread id 139689574652176 MySQL thread id 93, query id 3402615 lim-int1-b2bw-01.bluestarenergy.com 10.3.251.29 B2BW_I_B2BW_02 ---TRANSACTION ACD083, not started, process no 22803, OS thread id 139689574918416 MySQL thread id 92, query id 3483905 lim-int1-b2bw-01.bluestarenergy.com 10.3.251.29 B2BW_I_B2BW_02 ---TRANSACTION ACD121, not started, process no 22803, OS thread id 139689575717136 MySQL thread id 89, query id 3486493 lim-int1-b2bw-01.bluestarenergy.com 10.3.251.29 B2BW_I_B2BW_02 ---TRANSACTION ACCEE2, not started, process no 22803, OS thread id 139689604471056 MySQL thread id 88, query id 3477942 lim-int1-b2bw-01.bluestarenergy.com 10.3.251.29 B2BW_I_B2BW_02 ---TRANSACTION ACD07E, not started, process no 22803, OS thread id 139689604737296 MySQL thread id 87, query id 3484342 lim-int1-b2bw-01.bluestarenergy.com 10.3.251.29 B2BW_I_B2BW_02 ---TRANSACTION ACCEE4, not started, process no 22803, OS thread id 139689575184656 MySQL thread id 91, query id 3477943 lim-int1-b2bw-01.bluestarenergy.com 10.3.251.29 B2BW_I_B2BW_02 ---TRANSACTION ACCCBB, not started, process no 22803, OS thread id 139689605269776 MySQL thread id 80, query id 3479269 lim-int1-b2b-01.bluestarenergy.com 10.3.251.25 B2B_I_B2B_02 ---TRANSACTION ACB718, not started, process no 22803, OS thread id 139689577580816 MySQL thread id 13, query id 3396707 lim-int1-acc-01.bluestarenergy.com 10.3.251.46 ACC_I_ACC_03 ---TRANSACTION ACD125, not started, process no 22803, OS thread id 139689577314576 MySQL thread id 14, query id 3486573 lim-int1-acc-01.bluestarenergy.com 10.3.251.46 ACC_I_ACC_03 ---TRANSACTION ACB670, not started, process no 22803, OS thread id 139689578379536 MySQL thread id 10, query id 3395282 lim-int1-acc-01.bluestarenergy.com 10.3.251.46 ACC_I_ACC_03 ---TRANSACTION 0, not started, process no 22803, OS thread id 139689579976976 MySQL thread id 5, query id 7923 lim-int1-acc-01.bluestarenergy.com 10.3.251.46 ACC_I_ACC_03 ---TRANSACTION ACC79F, ACTIVE 1549 sec, process no 22803, OS thread id 139689575450896 MySQL thread id 1669, query id 3485553 lim-int1-acce-01.bluestarenergy.com 10.3.251.48 ACCE_I_ACCE_03 ---TRANSACTION ACB954, ACTIVE 3947 sec, process no 22803, OS thread id 139689571723536 MySQL thread id 1382, query id 3403939 lim-int1-husp-01.bluestarenergy.com 10.3.251.35 HUSP_I_HUSP_02 ---TRANSACTION ACB14E, ACTIVE 5149 sec, process no 22803, OS thread id 139689575983376 MySQL thread id 1217, query id 3446611 lim-int1-acce-01.bluestarenergy.com 10.3.251.48 ACCE_I_ACCE_03 ---TRANSACTION AC878D, ACTIVE 7318 sec, process no 22803, OS thread id 139689576249616 MySQL thread id 959, query id 3482317 lim-wrk-win-011.bse.local 10.3.50.111 USR_GLB_ACC ---TRANSACTION 95BBAD, ACTIVE 17560 sec, process no 22803, OS thread id 139691439585552 MySQL thread id 123, query id 3297743 lim-int1-sfap-01.bluestarenergy.com 10.3.251.40 MSCP_I_SFAP_02 -------- 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 643258 OS file reads, 28567 OS file writes, 15032 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 26, seg size 28, 1331 merges merged operations: insert 7970, delete mark 457, delete 182 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 2212673, node heap has 95 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 206103371322 Log flushed up to 206103371322 Last checkpoint at 206103371322 0 pending log writes, 0 pending chkp writes 12715 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 1098907648; in additional pool allocated 0 Dictionary memory allocated 10997799 Buffer pool size 65535 Free buffers 1 Database pages 65439 Old database pages 24136 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 741708, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 642302, created 724, written 15075 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 65439, unzip_LRU len: 0 I/O sum[4]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 22803, id 139689589168400, state: waiting for server activity Number of rows inserted 77423, updated 3401, deleted 1, read 326400274 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set (0.00 sec) ERROR: No query specified mysql> use bse_eis; Database changed mysql> show variables like '%foreign%'; +--------------------+-------+ | Variable_name | Value | +--------------------+-------+ | foreign_key_checks | OFF | +--------------------+-------+ 1 row in set (0.00 sec) mysql> truncate table zipcodes; ... From other connection to the same instance : mysql> show engine innodb status\G; *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 110720 23:59:16 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 0 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 19454 1_second, 19436 sleeps, 1818 10_second, 1320 background, 1319 flush srv_master_thread log flush and writes: 19483 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 10422, signal count 24993 Mutex spin waits 276876, rounds 450375, OS waits 3549 RW-shared spins 11753, rounds 190614, OS waits 5233 RW-excl spins 1470, rounds 59616, OS waits 1296 Spin rounds per wait: 1.63 mutex, 16.22 RW-shared, 40.56 RW-excl ------------ TRANSACTIONS ------------ Trx id counter ADFB3E Purge done for trx's n:o < ADF62D undo n:o < 0 History list length 1300 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started, process no 22803, OS thread id 139689572522256 MySQL thread id 1881, query id 4340394 localhost root show engine innodb status ---TRANSACTION 0, not started, process no 22803, OS thread id 139689573320976 MySQL thread id 1803, query id 3487988 localhost root Waiting for table metadata lock truncate table zipcodes ---TRANSACTION 95DC93, not started, process no 22803, OS thread id 139689572256016 MySQL thread id 516, query id 172274 lim-int1-wthc-01.bluestarenergy.com 10.3.251.66 WTHC_I_WTHC_02 ---TRANSACTION 95EDBA, not started, process no 22803, OS thread id 139689605536016 MySQL thread id 515, query id 220011 lim-int1-wthc-01.bluestarenergy.com 10.3.251.66 WTHC_I_WTHC_02 ---TRANSACTION 95DC8B, not started, process no 22803, OS thread id 139689572788496 MySQL thread id 514, query id 172281 lim-int1-wthc-01.bluestarenergy.com 10.3.251.66 WTHC_I_WTHC_02 ---TRANSACTION 95EC98, not started, process no 22803, OS thread id 139689573054736 MySQL thread id 343, query id 214308 lim-int1-fwcb-01.bluestarenergy.com 10.3.251.70 FWCB_I_FWCB_02 ---TRANSACTION ADFA9B, not started, process no 22803, OS thread id 139689574119696 MySQL thread id 134, query id 4338569 lim-int1-b2b-01.bluestarenergy.com 10.3.251.25 B2B_I_B2B_02 ---TRANSACTION ADF045, not started, process no 22803, OS thread id 139691440118032 MySQL thread id 207, query id 4302422 lim-int1-b2b-01.bluestarenergy.com 10.3.251.25 B2B_I_B2B_02 ---TRANSACTION ADF036, not started, process no 22803, OS thread id 139691440384272 MySQL thread id 82, query id 4301936 lim-int1-b2bg-01.bluestarenergy.com 10.3.251.26 GISB_I_B2BG_02 ---TRANSACTION ACB8E8, not started, process no 22803, OS thread id 139689574652176 MySQL thread id 93, query id 3402615 lim-int1-b2bw-01.bluestarenergy.com 10.3.251.29 B2BW_I_B2BW_02 ---TRANSACTION ADFA90, not started, process no 22803, OS thread id 139689574918416 MySQL thread id 92, query id 4338204 lim-int1-b2bw-01.bluestarenergy.com 10.3.251.29 B2BW_I_B2BW_02 ---TRANSACTION ADFB3C, not started, process no 22803, OS thread id 139689575717136 MySQL thread id 89, query id 4340364 lim-int1-b2bw-01.bluestarenergy.com 10.3.251.29 B2BW_I_B2BW_02 ---TRANSACTION ADF02F, not started, process no 22803, OS thread id 139689604471056 MySQL thread id 88, query id 4301733 lim-int1-b2bw-01.bluestarenergy.com 10.3.251.29 B2BW_I_B2BW_02 ---TRANSACTION ADFA9E, not started, process no 22803, OS thread id 139689604737296 MySQL thread id 87, query id 4338667 lim-int1-b2bw-01.bluestarenergy.com 10.3.251.29 B2BW_I_B2BW_02 ---TRANSACTION ADF032, not started, process no 22803, OS thread id 139689575184656 MySQL thread id 91, query id 4302374 lim-int1-b2bw-01.bluestarenergy.com 10.3.251.29 B2BW_I_B2BW_02 ---TRANSACTION ADF926, not started, process no 22803, OS thread id 139689605269776 MySQL thread id 80, query id 4333380 lim-int1-b2b-01.bluestarenergy.com 10.3.251.25 B2B_I_B2B_02 ---TRANSACTION ADEB75, not started, process no 22803, OS thread id 139689577580816 MySQL thread id 13, query id 4279418 lim-int1-acc-01.bluestarenergy.com 10.3.251.46 ACC_I_ACC_03 ---TRANSACTION ADFB3D, not started, process no 22803, OS thread id 139689577314576 MySQL thread id 14, query id 4340393 lim-int1-acc-01.bluestarenergy.com 10.3.251.46 ACC_I_ACC_03 ---TRANSACTION ACB670, not started, process no 22803, OS thread id 139689578379536 MySQL thread id 10, query id 3395282 lim-int1-acc-01.bluestarenergy.com 10.3.251.46 ACC_I_ACC_03 ---TRANSACTION ADF3F1, ACTIVE 1156 sec, process no 22803, OS thread id 139691440650512 MySQL thread id 3024, query id 4334293 lim-int1-acce-01.bluestarenergy.com 10.3.251.48 ACCE_I_ACCE_03 ---TRANSACTION ADDAF4, ACTIVE 4756 sec, process no 22803, OS thread id 139689606334736 MySQL thread id 2563, query id 4308532 lim-int1-acce-01.bluestarenergy.com 10.3.251.48 ACCE_I_ACCE_03 ---TRANSACTION ACB954, ACTIVE 14354 sec, process no 22803, OS thread id 139689571723536 MySQL thread id 1382, query id 3403939 lim-int1-husp-01.bluestarenergy.com 10.3.251.35 HUSP_I_HUSP_02 ---TRANSACTION 95BBAD, ACTIVE 27967 sec, process no 22803, OS thread id 139691439585552 MySQL thread id 123, query id 3297743 lim-int1-sfap-01.bluestarenergy.com 10.3.251.40 MSCP_I_SFAP_02 -------- 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 677147 OS file reads, 106888 OS file writes, 58399 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 26, seg size 28, 1819 merges merged operations: insert 8650, delete mark 470, delete 182 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 2212673, node heap has 3307 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 206153158927 Log flushed up to 206153158927 Last checkpoint at 206153158927 0 pending log writes, 0 pending chkp writes 53785 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 1098907648; in additional pool allocated 0 Dictionary memory allocated 10997799 Buffer pool size 65535 Free buffers 1 Database pages 62227 Old database pages 22950 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 775380, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 676191, created 2812, written 51367 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s LRU len: 62227, unzip_LRU len: 0 I/O sum[1]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 22803, id 139689589168400, state: sleeping Number of rows inserted 101641, updated 46247, deleted 47073, read 884609681 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set (0.00 sec) ERROR: No query specified mysql> show processlist; +------+----------------+-------------------------------------------+--------------------+---------+-------+---------------------------------+-------------------------+ | Id | User | Host | db | Command | Time | State | Info | +------+----------------+-------------------------------------------+--------------------+---------+-------+---------------------------------+-------------------------+ | 10 | ACC_I_ACC_03 | lim-int1-acc-01.bluestarenergy.com:39388 | opentaps | Sleep | 14740 | | NULL | | 13 | ACC_I_ACC_03 | lim-int1-acc-01.bluestarenergy.com:54729 | opentaps | Sleep | 2556 | | NULL | | 14 | ACC_I_ACC_03 | lim-int1-acc-01.bluestarenergy.com:51257 | opentaps | Sleep | 15 | | NULL | | 80 | B2B_I_B2B_02 | lim-int1-b2b-01.bluestarenergy.com:57045 | bse_eis | Sleep | 329 | | NULL | | 82 | GISB_I_B2BG_02 | lim-int1-b2bg-01.bluestarenergy.com:47474 | bse_eis | Sleep | 1769 | | NULL | | 84 | B2BW_I_B2BW_02 | lim-int1-b2bn-01.bluestarenergy.com:59957 | bse_eis | Sleep | 28362 | | NULL | | 87 | B2BW_I_B2BW_02 | lim-int1-b2bw-01.bluestarenergy.com:36830 | bse_eis | Sleep | 89 | | NULL | | 88 | B2BW_I_B2BW_02 | lim-int1-b2bw-01.bluestarenergy.com:46426 | bse_eis | Sleep | 1769 | | NULL | | 89 | B2BW_I_B2BW_02 | lim-int1-b2bw-01.bluestarenergy.com:41714 | bse_eis | Sleep | 29 | | NULL | | 91 | B2BW_I_B2BW_02 | lim-int1-b2bw-01.bluestarenergy.com:60081 | bse_eis | Sleep | 1769 | | NULL | | 92 | B2BW_I_B2BW_02 | lim-int1-b2bw-01.bluestarenergy.com:60851 | bse_eis | Sleep | 89 | | NULL | | 93 | B2BW_I_B2BW_02 | lim-int1-b2bw-01.bluestarenergy.com:33252 | bse_eis | Sleep | 14369 | | NULL | | 98 | B2BC_I_B2BC_02 | lim-int1-b2bc-01.bluestarenergy.com:57575 | bse_eis | Sleep | 28326 | | NULL | | 123 | MSCP_I_SFAP_02 | lim-int1-sfap-01.bluestarenergy.com:39164 | bse_eis | Sleep | 17458 | | NULL | | 134 | B2B_I_B2B_02 | lim-int1-b2b-01.bluestarenergy.com:40137 | bse_eis | Sleep | 89 | | NULL | | 207 | B2B_I_B2B_02 | lim-int1-b2b-01.bluestarenergy.com:37892 | bse_eis | Sleep | 1769 | | NULL | | 343 | FWCB_I_FWCB_02 | lim-int1-fwcb-01.bluestarenergy.com:37726 | bse_eis | Sleep | 21567 | | NULL | | 514 | WTHC_I_WTHC_02 | lim-int1-wthc-01.bluestarenergy.com:37144 | bse_eis | Sleep | 22951 | | NULL | | 515 | WTHC_I_WTHC_02 | lim-int1-wthc-01.bluestarenergy.com:48154 | bse_eis | Sleep | 21315 | | NULL | | 516 | WTHC_I_WTHC_02 | lim-int1-wthc-01.bluestarenergy.com:57767 | bse_eis | Sleep | 22970 | | NULL | | 1382 | HUSP_I_HUSP_02 | lim-int1-husp-01.bluestarenergy.com:35706 | bse_eis | Sleep | 14367 | | NULL | | 1803 | root | localhost | bse_eis | Query | 10356 | Waiting for table metadata lock | truncate table zipcodes | | 1881 | root | localhost | information_schema | Query | 0 | NULL | show processlist | | 2563 | ACCE_I_ACCE_03 | lim-int1-acce-01.bluestarenergy.com:54838 | opentaps | Sleep | 1469 | | NULL | | 2787 | ACCE_I_ACCE_03 | lim-int1-acce-01.bluestarenergy.com:60079 | opentaps | Sleep | 3108 | | NULL | | 2788 | ACCE_I_ACCE_03 | lim-int1-acce-01.bluestarenergy.com:36372 | opentaps | Sleep | 3108 | | NULL | | 2789 | ACCE_I_ACCE_03 | lim-int1-acce-01.bluestarenergy.com:44215 | opentaps | Sleep | 3108 | | NULL | | 2790 | ACCE_I_ACCE_03 | lim-int1-acce-01.bluestarenergy.com:46432 | opentaps | Sleep | 3108 | | NULL | | 3004 | BILN_I_BILN_02 | lim-int1-bila-01.bluestarenergy.com:37922 | bse_eis | Sleep | 1396 | | NULL | | 3021 | ACCE_I_ACCE_03 | lim-int1-acce-01.bluestarenergy.com:51248 | opentaps | Sleep | 1308 | | NULL | | 3022 | ACCE_I_ACCE_03 | lim-int1-acce-01.bluestarenergy.com:49985 | opentaps | Sleep | 1308 | | NULL | | 3023 | ACCE_I_ACCE_03 | lim-int1-acce-01.bluestarenergy.com:48971 | opentaps | Sleep | 1308 | | NULL | | 3024 | ACCE_I_ACCE_03 | lim-int1-acce-01.bluestarenergy.com:53279 | opentaps | Sleep | 269 | | NULL | | 3025 | ACCE_I_ACCE_03 | lim-int1-acce-01.bluestarenergy.com:43675 | opentaps | Sleep | 1308 | | NULL | | 3153 | BILN_I_BILN_02 | lim-int1-bilx-01.bluestarenergy.com:53070 | bse_eis | Sleep | 151 | | NULL | | 3156 | BILN_I_BILN_02 | lim-int1-bilx-01.bluestarenergy.com:42485 | bse_eis | Sleep | 91 | | NULL | | 3157 | BILN_I_BILN_02 | lim-int1-bilx-01.bluestarenergy.com:45593 | bse_eis | Sleep | 91 | | NULL | | 3158 | BILN_I_BILN_02 | lim-int1-bilx-01.bluestarenergy.com:48050 | bse_eis | Sleep | 91 | | NULL | | 3159 | BILN_I_BILN_02 | lim-int1-bilx-01.bluestarenergy.com:37460 | bse_eis | Sleep | 91 | | NULL | | 3160 | BILN_I_BILN_02 | lim-int1-bilx-01.bluestarenergy.com:40037 | bse_eis | Sleep | 91 | | NULL | | 3161 | BILN_I_BILN_02 | lim-int1-bilx-01.bluestarenergy.com:47521 | bse_eis | Sleep | 91 | | NULL | | 3162 | BILN_I_BILN_02 | lim-int1-bilx-01.bluestarenergy.com:35679 | bse_eis | Sleep | 91 | | NULL | | 3163 | BILN_I_BILN_02 | lim-int1-bilx-01.bluestarenergy.com:40927 | bse_eis | Sleep | 91 | | NULL | | 3164 | BILN_I_BILN_02 | lim-int1-biln-01.bluestarenergy.com:33846 | bse_eis | Sleep | 80 | | NULL | | 3165 | BILN_I_BILN_02 | lim-int1-biln-01.bluestarenergy.com:37790 | bse_eis | Sleep | 80 | | NULL | | 3166 | BILN_I_BILN_02 | lim-int1-biln-01.bluestarenergy.com:40871 | bse_eis | Sleep | 80 | | NULL | | 3167 | BILN_I_BILN_02 | lim-int1-biln-01.bluestarenergy.com:50959 | bse_eis | Sleep | 80 | | NULL | | 3168 | BILN_I_BILN_02 | lim-int1-biln-01.bluestarenergy.com:43372 | bse_eis | Sleep | 80 | | NULL | | 3169 | BILN_I_BILN_02 | lim-int1-biln-01.bluestarenergy.com:55298 | bse_eis | Sleep | 80 | | NULL | | 3170 | BILN_I_BILN_02 | lim-int1-biln-01.bluestarenergy.com:39210 | bse_eis | Sleep | 80 | | NULL | | 3171 | BILN_I_BILN_02 | lim-int1-biln-01.bluestarenergy.com:46899 | bse_eis | Sleep | 80 | | NULL | | 3172 | BILN_I_BILN_02 | lim-int1-bilx-01.bluestarenergy.com:38876 | bse_eis | Sleep | 31 | | NULL | | 3173 | BILN_I_BILN_02 | lim-int1-biln-01.bluestarenergy.com:46906 | bse_eis | Sleep | 20 | | NULL | | 3174 | BILN_I_BILN_02 | lim-int1-biln-01.bluestarenergy.com:34589 | bse_eis | Sleep | 20 | | NULL | +------+----------------+-------------------------------------------+--------------------+---------+-------+---------------------------------+-------------------------+ 54 rows in set (0.00 sec) mysql> SELECT * FROM performance_schema.MUTEX_INSTANCES WHERE LOCKED_BY_THREAD_ID IS NOT NULL; Empty set (0.00 sec) mysql> SELECT * FROM performance_schema.RWLOCK_INSTANCES WHERE WRITE_LOCKED_BY_THREAD_ID IS NOT NULL OR READ_LOCKED_BY_COUNT IS NOT NULL; Empty set (0.00 sec)