cleaning up

Camilo Vieira <[email protected]>
Newsgroups gmane.comp.db.mysql.general
Message-ID <CAOaUXVL=nq1pgM25XewT85W7xjEFqoaNjY7JFcE5-s3aHWS2Kw@mail.gmail.com>
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!
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.