Web lists-archives.com

cleaning up




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!