innodb-status.txt

*************************** 1. row ***************************
  Type: InnoDB
  Name: 
Status: 
=====================================
2022-01-30 00:29:10 0x7f7234541700 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 16 seconds
-----------------
BACKGROUND THREAD
-----------------
srv_master_thread loops: 471660 srv_active, 0 srv_shutdown, 145567 srv_idle
srv_master_thread log flush and writes: 617226
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 32779405
OS WAIT ARRAY INFO: signal count 111727426
RW-shared spins 115252537, rounds 497489853, OS waits 9609789
RW-excl spins 15822670, rounds 179658651, OS waits 5106814
RW-sx spins 9269424, rounds 28330940, OS waits 481735
Spin rounds per wait: 4.32 RW-shared, 11.35 RW-excl, 3.06 RW-sx
------------
TRANSACTIONS
------------
Trx id counter 173404
Purge done for trx's n:o < 173403 undo n:o < 64409405 state: running
History list length 1
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421603790549096, not started
0 lock struct(s), heap size 1128, 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: 2
429930956 OS file reads, 442661076 OS file writes, 65098753 OS fsyncs
248.11 reads/s, 16384 avg bytes/read, 621.96 writes/s, 428.85 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 13776, seg size 13778, 547909 merges
merged operations:
 insert 0, delete mark 567574383, delete 18560
discarded operations:
 insert 0, delete mark 0, delete 0
Hash table size 276707, node heap has 0 buffer(s)
Hash table size 276707, node heap has 1 buffer(s)
Hash table size 276707, node heap has 0 buffer(s)
Hash table size 276707, node heap has 263 buffer(s)
Hash table size 276707, node heap has 0 buffer(s)
Hash table size 276707, node heap has 1 buffer(s)
Hash table size 276707, node heap has 1 buffer(s)
Hash table size 276707, node heap has 1 buffer(s)
0.00 hash searches/s, 291.42 non-hash searches/s
---
LOG
---
Log sequence number 1228501885658
Log flushed up to   1228501881747
Pages flushed up to 1228500837508
Last checkpoint at  1228500837508
0 pending log flushes, 0 pending chkp writes
1751455 log i/o's done, 3.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 1129840640
Dictionary memory allocated 36960
Buffer pool size   65536
Free buffers       0
Database pages     65205
Old database pages 23909
Modified db pages  27123
Percent of dirty pages(LRU & free pages): 41.596
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 42628169, not young 27026184793
20.31 youngs/s, 262.42 non-youngs/s
Pages read 429593093, created 8673264, written 406869050
248.36 reads/s, 0.00 creates/s, 405.97 writes/s
Buffer pool hit rate 824 / 1000, young-making rate 14 / 1000 not 185 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 65205, unzip_LRU len: 0
I/O sum[278104]:cur[384], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   8192
Free buffers       0
Database pages     8152
Old database pages 2989
Modified db pages  3440
Percent of dirty pages(LRU & free pages): 42.193
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 5339484, not young 3389096715
1.87 youngs/s, 29.06 non-youngs/s
Pages read 53780778, created 1084341, written 50949662
27.31 reads/s, 0.00 creates/s, 47.25 writes/s
Buffer pool hit rate 533 / 1000, young-making rate 32 / 1000 not 496 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 8152, unzip_LRU len: 0
I/O sum[34763]:cur[48], unzip sum[0]:cur[0]
---BUFFER POOL 1
Buffer pool size   8192
Free buffers       0
Database pages     8152
Old database pages 2989
Modified db pages  3462
Percent of dirty pages(LRU & free pages): 42.463
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 5276568, not young 3395233661
2.87 youngs/s, 33.37 non-youngs/s
Pages read 52461450, created 1081803, written 49875256
31.81 reads/s, 0.00 creates/s, 52.25 writes/s
Buffer pool hit rate 947 / 1000, young-making rate 4 / 1000 not 55 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 8152, unzip_LRU len: 0
I/O sum[34763]:cur[48], unzip sum[0]:cur[0]
---BUFFER POOL 2
Buffer pool size   8192
Free buffers       0
Database pages     8152
Old database pages 2989
Modified db pages  3310
Percent of dirty pages(LRU & free pages): 40.599
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 5331216, not young 3417009756
2.87 youngs/s, 36.25 non-youngs/s
Pages read 54099915, created 1087265, written 51156363
34.06 reads/s, 0.00 creates/s, 55.93 writes/s
Buffer pool hit rate 530 / 1000, young-making rate 39 / 1000 not 499 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 8152, unzip_LRU len: 0
I/O sum[34763]:cur[48], unzip sum[0]:cur[0]
---BUFFER POOL 3
Buffer pool size   8192
Free buffers       0
Database pages     8146
Old database pages 2987
Modified db pages  3381
Percent of dirty pages(LRU & free pages): 41.500
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 5351388, not young 3406393977
2.87 youngs/s, 33.69 non-youngs/s
Pages read 53855333, created 1087707, written 50890885
32.25 reads/s, 0.00 creates/s, 53.62 writes/s
Buffer pool hit rate 598 / 1000, young-making rate 35 / 1000 not 419 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 8146, unzip_LRU len: 0
I/O sum[34763]:cur[48], unzip sum[0]:cur[0]
---BUFFER POOL 4
Buffer pool size   8192
Free buffers       0
Database pages     8151
Old database pages 2988
Modified db pages  3367
Percent of dirty pages(LRU & free pages): 41.303
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 1
Pages made young 5329198, not young 3236476067
3.25 youngs/s, 32.69 non-youngs/s
Pages read 53533680, created 1070918, written 51107217
30.94 reads/s, 0.00 creates/s, 50.00 writes/s
Buffer pool hit rate 742 / 1000, young-making rate 27 / 1000 not 272 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 8151, unzip_LRU len: 0
I/O sum[34763]:cur[48], unzip sum[0]:cur[0]
---BUFFER POOL 5
Buffer pool size   8192
Free buffers       0
Database pages     8157
Old database pages 2991
Modified db pages  3317
Percent of dirty pages(LRU & free pages): 40.659
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 5333809, not young 3393551378
2.44 youngs/s, 33.31 non-youngs/s
Pages read 53948105, created 1087195, written 50989492
31.19 reads/s, 0.00 creates/s, 50.50 writes/s
Buffer pool hit rate 867 / 1000, young-making rate 10 / 1000 not 141 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 8157, unzip_LRU len: 0
I/O sum[34763]:cur[48], unzip sum[0]:cur[0]
---BUFFER POOL 6
Buffer pool size   8192
Free buffers       0
Database pages     8142
Old database pages 2986
Modified db pages  3424
Percent of dirty pages(LRU & free pages): 42.048
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 1
Pages made young 5314753, not young 3384499406
1.62 youngs/s, 31.37 non-youngs/s
Pages read 53977254, created 1087325, written 50957179
29.69 reads/s, 0.00 creates/s, 47.68 writes/s
Buffer pool hit rate 584 / 1000, young-making rate 22 / 1000 not 439 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 8142, unzip_LRU len: 0
I/O sum[34763]:cur[48], unzip sum[0]:cur[0]
---BUFFER POOL 7
Buffer pool size   8192
Free buffers       0
Database pages     8153
Old database pages 2990
Modified db pages  3422
Percent of dirty pages(LRU & free pages): 41.967
Max dirty pages percent: 75.000
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 5351753, not young 3403923833
2.50 youngs/s, 32.69 non-youngs/s
Pages read 53936578, created 1086710, written 50942996
31.12 reads/s, 0.00 creates/s, 48.75 writes/s
Buffer pool hit rate 816 / 1000, young-making rate 14 / 1000 not 192 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 8153, unzip_LRU len: 0
I/O sum[34763]:cur[48], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
0 read views open inside InnoDB
Process ID=148167, Main thread ID=140127032555264, state: sleeping
Number of rows inserted 583769024, updated 0, deleted 1393319845, read 23200811575
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
Number of system rows inserted 0, updated 0, deleted 0, read 0
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================