Hi, There are lot mysql transactions with the "cleaning up" state on my Mysql 5.6.31:
------------ TRANSACTIONS ------------ Trx id counter 26782150 Purge done for trx's n:o < 26774181 undo n:o < 0 state: running but idle History list length 739 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 6337, OS thread handle 0x7f13d08f2700, query id 126598020 localhost root init show engine innodb status ---TRANSACTION 26782140, not started MySQL thread id 6334, OS thread handle 0x7f13c9e59700, query id 126597972 x.y.5.30 bnu cleaning up ---TRANSACTION 26782003, not started MySQL thread id 6333, OS thread handle 0x7f13d05b1700, query id 126597189 x.y.5.30 nat cleaning up ---TRANSACTION 26770094, not started MySQL thread id 6332, OS thread handle 0x7f13d048b700, query id 126517953 x.y.5.30 gyn cleaning up ---TRANSACTION 26770095, not started MySQL thread id 6331, OS thread handle 0x7f13c9d64700, query id 126517957 x.y.5.30 gyn cleaning up ---TRANSACTION 26782142, not started MySQL thread id 6328, OS thread handle 0x7f13d0119700, query id 126597982 10.212.10.113 douglas cleaning up ---TRANSACTION 0, not started MySQL thread id 6327, OS thread handle 0x7f13d079b700, query id 126589014 10.37.28.96 cesar cleaning up ---TRANSACTION 26759054, not started MySQL thread id 6325, OS thread handle 0x7f13c9e28700, query id 126591159 10.212.10.158 camilo cleaning up ---TRANSACTION 0, not started MySQL thread id 6324, OS thread handle 0x7f13d0270700, query id 126591158 10.212.10.158 camilo cleaning up ---TRANSACTION 26779776, not started MySQL thread id 6322, OS thread handle 0x7f13d4bd5700, query id 126582047 x.y.5.30 nat cleaning up ---TRANSACTION 0, not started MySQL thread id 6321, OS thread handle 0x7f13ca0a5700, query id 126597896 localhost root cleaning up ---TRANSACTION 26780918, not started MySQL thread id 6308, OS thread handle 0x7f13c9fb0700, query id 126590660 10.212.10.113 douglas cleaning up ---TRANSACTION 26721560, not started MySQL thread id 6281, OS thread handle 0x7f13d0396700, query id 126223696 10.212.10.96 wrpaiva cleaning up ---TRANSACTION 0, not started MySQL thread id 6280, OS thread handle 0x7f13d0303700, query id 126223692 10.212.10.96 wrpaiva cleaning up ---TRANSACTION 26777804, not started MySQL thread id 6300, OS thread handle 0x7f13d0644700, query id 126568164 x.y.5.30 bnu cleaning up ---TRANSACTION 26781215, not started MySQL thread id 6299, OS thread handle 0x7f13c9dc6700, query id 126592399 x.y.5.30 gyn cleaning up ---TRANSACTION 26782147, not started MySQL thread id 6297, OS thread handle 0x7f13d00b7700, query id 126598007 x.y.5.30 nat cleaning up ---TRANSACTION 26689786, not started MySQL thread id 6296, OS thread handle 0x7f13d499e700, query id 126302499 172.25.23.93 odemir cleaning up ---TRANSACTION 26777803, not started MySQL thread id 6295, OS thread handle 0x7f13d04ed700, query id 126568163 x.y.5.30 bnu cleaning up ---TRANSACTION 26782073, not started MySQL thread id 6294, OS thread handle 0x7f13d020e700, query id 126597605 x.y.5.30 bnu cleaning up ---TRANSACTION 26774701, not started MySQL thread id 6293, OS thread handle 0x7f13ca074700, query id 126547915 x.y.5.30 nat cleaning up ---TRANSACTION 26780762, not started MySQL thread id 6291, OS thread handle 0x7f13d496d700, query id 126589795 x.y.5.30 gyn cleaning up ---TRANSACTION 26782146, not started MySQL thread id 6290, OS thread handle 0x7f13ca138700, query id 126598002 x.y.5.30 gyn cleaning up ---TRANSACTION 26780390, not started MySQL thread id 6289, OS thread handle 0x7f13d08c1700, query id 126586679 x.y.5.30 gyn cleaning up ---TRANSACTION 26770105, not started MySQL thread id 5964, OS thread handle 0x7f13ca1cb700, query id 126518017 x.y.5.30 gyn cleaning up ---TRANSACTION 26777808, not started MySQL thread id 5963, OS thread handle 0x7f13d07cc700, query id 126568189 x.y.5.30 bnu cleaning up ---TRANSACTION 26774294, not started MySQL thread id 5942, OS thread handle 0x7f13c9eec700, query id 126545162 x.y.2.22 douglas cleaning up ---TRANSACTION 26780109, not started MySQL thread id 5832, OS thread handle 0x7f13d48a9700, query id 126589829 x.y.5.30 gyn cleaning up ---TRANSACTION 26777802, not started MySQL thread id 5822, OS thread handle 0x7f13ca012700, query id 126568156 x.y.5.30 bnu cleaning up ---TRANSACTION 26782149, not started MySQL thread id 5314, OS thread handle 0x7f13d017b700, query id 126598019 x.y.5.30 nhb cleaning up ---TRANSACTION 26782143, not started MySQL thread id 5246, OS thread handle 0x7f13c9d95700, query id 126597987 x.y.2.22 douglas cleaning up ---TRANSACTION 26779477, not started MySQL thread id 5237, OS thread handle 0x7f13d076a700, query id 126580069 x.y.5.30 nhb cleaning up ---TRANSACTION 26772820, ACTIVE 675 sec 18 lock struct(s), heap size 2936, 15 row lock(s), undo log entries 6 MySQL thread id 6326, OS thread handle 0x7f13c9ebb700, query id 126589015 10.37.28.96 cesar cleaning up Trx read view will not see trx with id >= 26773666, sees < 26773666 -------- 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 236733645 OS file reads, 4720707 OS file writes, 1185709 OS fsyncs 201.64 reads/s, 16384 avg bytes/read, 66.99 writes/s, 5.89 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 2801, seg size 2803, 1135658 merges merged operations: insert 3675583, delete mark 615656, delete 40699 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 276671, node heap has 385 buffer(s) 15022.55 hash searches/s, 3823.13 non-hash searches/s Somebody could help me to understand what happening? Thanks!
