MySQL Forums
Forum List  »  General

Re: Long running queries over tcp don’t “respond” to client after completion
Posted by: Matthew Lenz
Date: March 24, 2021 12:01PM

The thread is still there and connected in a sleep state.

Here is the entire thing:

*************************** 1. row ***************************
Type: InnoDB
Name:
Status:
=====================================
2021-03-24 12:56:11 0x7f47022ee700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 6 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 713 srv_active, 0 srv_shutdown, 1389 srv_idle
srv_master_thread log flush and writes: 0
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 404
OS WAIT ARRAY INFO: signal count 678
RW-shared spins 53, rounds 53, OS waits 0
RW-excl spins 142, rounds 1763, OS waits 64
RW-sx spins 86, rounds 2538, OS waits 83
Spin rounds per wait: 1.00 RW-shared, 12.42 RW-excl, 29.51 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 4169170
Purge done for trx's n:o < 4169170 undo n:o < 0 state: running but idle
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421418032300472, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421418032299576, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421418032298680, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
---TRANSACTION 421418032297784, not started
0 lock struct(s), heap size 1136, 0 row lock(s)
--------
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] , aio writes: [0, 0, 0, 0] ,
ibuf aio reads:, log i/o's:, sync i/o's:
Pending flushes (fsync) log: 0; buffer pool: 18446744073709551613
402268 OS file reads, 4730471 OS file writes, 454179 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 327.78 writes/s, 94.98 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 21, seg size 23, 0 merges
merged operations:
insert 0, delete mark 0, delete 0
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 10624987, node heap has 3671 buffer(s)
Hash table size 10624987, node heap has 74 buffer(s)
Hash table size 10624987, node heap has 98 buffer(s)
Hash table size 10624987, node heap has 1 buffer(s)
Hash table size 10624987, node heap has 47 buffer(s)
Hash table size 10624987, node heap has 21 buffer(s)
Hash table size 10624987, node heap has 11 buffer(s)
Hash table size 10624987, node heap has 3 buffer(s)
0.00 hash searches/s, 0.00 non-hash searches/s
---
LOG
---
Log sequence number 394533221208
Log buffer assigned up to 394533221208
Log buffer completed up to 394533221208
Log written up to 394533221208
Log flushed up to 394533221208
Added dirty pages up to 394533221208
Pages flushed up to 389858583774
Last checkpoint at 389858583774
Checkpoint age target 9866336768
Modified age no less than 4668399417
Checkpoint age 4674637434
Max checkpoint age 9630470144
Number of logs 2
Log size 5368709120
Log total size 10737418240
4354571 log i/o's done, 0.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 43977277440
Dictionary memory allocated 567004
Buffer pool size 2621120
Buffer pool size, bytes 42944430080
Free buffers 1741489
Database pages 875705
Old database pages 322438
Modified db pages 204537
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 402163, created 473542, written 284793
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, Random read ahead 0.00/s
LRU len: 875705, unzip_LRU len: 0
I/O sum[0]:cur[8000], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43597
Database pages 21840
Old database pages 8042
Modified db pages 4924
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 9927, created 11913, written 7119
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, Random read ahead 0.00/s
LRU len: 21840, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43695
Database pages 21731
Old database pages 8001
Modified db pages 4747
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10241, created 11490, written 7159
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, Random read ahead 0.00/s
LRU len: 21731, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43412
Database pages 22008
Old database pages 8104
Modified db pages 5469
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10142, created 11866, written 7257
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, Random read ahead 0.00/s
LRU len: 22008, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43481
Database pages 21944
Old database pages 8080
Modified db pages 5167
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10080, created 11864, written 7005
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, Random read ahead 0.00/s
LRU len: 21944, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43807
Database pages 21618
Old database pages 7960
Modified db pages 5062
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 1, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 9901, created 11717, written 7133
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, Random read ahead 0.00/s
LRU len: 21618, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43453
Database pages 21968
Old database pages 8089
Modified db pages 4821
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10325, created 11643, written 7161
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, Random read ahead 0.00/s
LRU len: 21968, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43230
Database pages 22201
Old database pages 8175
Modified db pages 5262
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10114, created 12087, written 7472
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, Random read ahead 0.00/s
LRU len: 22201, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43430
Database pages 21990
Old database pages 8097
Modified db pages 5150
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10209, created 11781, written 7069
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, Random read ahead 0.00/s
LRU len: 21990, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 8
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43199
Database pages 22234
Old database pages 8187
Modified db pages 5585
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10028, created 12206, written 7024
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, Random read ahead 0.00/s
LRU len: 22234, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 9
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43447
Database pages 21977
Old database pages 8092
Modified db pages 5260
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 9965, created 12012, written 7225
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, Random read ahead 0.00/s
LRU len: 21977, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 10
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43499
Database pages 21920
Old database pages 8071
Modified db pages 4828
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10113, created 11807, written 7164
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, Random read ahead 0.00/s
LRU len: 21920, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 11
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43457
Database pages 21984
Old database pages 8095
Modified db pages 5389
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 9878, created 12106, written 7181
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, Random read ahead 0.00/s
LRU len: 21984, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 12
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43851
Database pages 21574
Old database pages 7943
Modified db pages 4576
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10077, created 11497, written 7355
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, Random read ahead 0.00/s
LRU len: 21574, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 13
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43746
Database pages 21691
Old database pages 7987
Modified db pages 5050
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 9922, created 11769, written 6975
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, Random read ahead 0.00/s
LRU len: 21691, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 14
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43861
Database pages 21574
Old database pages 7943
Modified db pages 5087
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 9789, created 11785, written 7061
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, Random read ahead 0.00/s
LRU len: 21574, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 15
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43093
Database pages 22333
Old database pages 8224
Modified db pages 5672
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10221, created 12112, written 7000
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, Random read ahead 0.00/s
LRU len: 22333, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 16
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43650
Database pages 21784
Old database pages 8021
Modified db pages 5339
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 9915, created 11869, written 7039
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, Random read ahead 0.00/s
LRU len: 21784, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 17
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43533
Database pages 21903
Old database pages 8065
Modified db pages 5295
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 9952, created 11951, written 6934
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, Random read ahead 0.00/s
LRU len: 21903, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 18
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43749
Database pages 21687
Old database pages 7985
Modified db pages 5136
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 9853, created 11834, written 7056
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, Random read ahead 0.00/s
LRU len: 21687, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 19
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43639
Database pages 21796
Old database pages 8025
Modified db pages 5042
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 9961, created 11835, written 7093
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, Random read ahead 0.00/s
LRU len: 21796, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 20
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43556
Database pages 21875
Old database pages 8054
Modified db pages 5311
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10044, created 11831, written 7101
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, Random read ahead 0.00/s
LRU len: 21875, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 21
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43442
Database pages 21993
Old database pages 8098
Modified db pages 4959
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10185, created 11808, written 7223
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, Random read ahead 0.00/s
LRU len: 21993, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 22
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43680
Database pages 21750
Old database pages 8008
Modified db pages 5366
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 9831, created 11919, written 7144
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, Random read ahead 0.00/s
LRU len: 21750, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 23
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43540
Database pages 21893
Old database pages 8061
Modified db pages 4989
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10048, created 11845, written 7113
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, Random read ahead 0.00/s
LRU len: 21893, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 24
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43812
Database pages 21609
Old database pages 7956
Modified db pages 4601
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 9999, created 11610, written 7223
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, Random read ahead 0.00/s
LRU len: 21609, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 25
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43557
Database pages 21877
Old database pages 8055
Modified db pages 5232
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 9894, created 11983, written 7069
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, Random read ahead 0.00/s
LRU len: 21877, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 26
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43503
Database pages 21925
Old database pages 8073
Modified db pages 4920
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10148, created 11777, written 7175
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, Random read ahead 0.00/s
LRU len: 21925, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 27
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43228
Database pages 22198
Old database pages 8174
Modified db pages 5327
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10061, created 12137, written 7046
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, Random read ahead 0.00/s
LRU len: 22198, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 28
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43298
Database pages 22132
Old database pages 8149
Modified db pages 5298
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10241, created 11891, written 7056
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, Random read ahead 0.00/s
LRU len: 22132, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 29
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43843
Database pages 21597
Old database pages 7952
Modified db pages 4853
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 9952, created 11645, written 7089
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, Random read ahead 0.00/s
LRU len: 21597, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 30
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43612
Database pages 21823
Old database pages 8035
Modified db pages 4597
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10337, created 11486, written 7257
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, Random read ahead 0.00/s
LRU len: 21823, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 31
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43349
Database pages 22081
Old database pages 8130
Modified db pages 5476
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10193, created 11888, written 7082
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, Random read ahead 0.00/s
LRU len: 22081, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 32
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43638
Database pages 21784
Old database pages 8021
Modified db pages 5013
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 9983, created 11801, written 7155
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, Random read ahead 0.00/s
LRU len: 21784, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 33
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43489
Database pages 21940
Old database pages 8078
Modified db pages 5116
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10340, created 11600, written 6914
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, Random read ahead 0.00/s
LRU len: 21940, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 34
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43788
Database pages 21631
Old database pages 7964
Modified db pages 5342
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 9802, created 11829, written 7222
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, Random read ahead 0.00/s
LRU len: 21631, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 35
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43185
Database pages 22243
Old database pages 8190
Modified db pages 5316
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10199, created 12044, written 7221
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, Random read ahead 0.00/s
LRU len: 22243, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 36
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43913
Database pages 21521
Old database pages 7924
Modified db pages 4817
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 9795, created 11726, written 7072
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, Random read ahead 0.00/s
LRU len: 21521, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 37
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43259
Database pages 22176
Old database pages 8166
Modified db pages 4934
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10232, created 11944, written 7108
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, Random read ahead 0.00/s
LRU len: 22176, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 38
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43529
Database pages 21902
Old database pages 8064
Modified db pages 4959
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10081, created 11821, written 7030
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, Random read ahead 0.00/s
LRU len: 21902, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
---BUFFER POOL 39
Buffer pool size 65528
Buffer pool size, bytes 1073610752
Free buffers 43439
Database pages 21998
Old database pages 8100
Modified db pages 5250
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 10185, created 11813, written 7011
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, Random read ahead 0.00/s
LRU len: 21998, unzip_LRU len: 0
I/O sum[0]:cur[200], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
0 RW transactions active inside InnoDB
Process ID=580, Main thread ID=139902441154304 , state=sleeping
Number of rows inserted 8315512, updated 0, deleted 0, read 0
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
Number of system rows inserted 792, updated 1487, deleted 788, read 8692
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.