Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MariaDB [(none)]> SHOW ENGINE INNODB STATUS\G
- *************************** 1. row ***************************
- Type: InnoDB
- Name:
- Status:
- =====================================
- 2023-03-09 11:48:14 0x7f261e8cd700 INNODB MONITOR OUTPUT
- =====================================
- Per second averages calculated from the last 35 seconds
- -----------------
- BACKGROUND THREAD
- -----------------
- srv_master_thread loops: 36732 srv_active, 0 srv_shutdown, 51018 srv_idle
- srv_master_thread log flush and writes: 87737
- ----------
- SEMAPHORES
- ----------
- OS WAIT ARRAY INFO: reservation count 1163771
- OS WAIT ARRAY INFO: signal count 632201
- RW-shared spins 114313, rounds 2866820, OS waits 93876
- RW-excl spins 101210, rounds 491835, OS waits 8694
- RW-sx spins 3108, rounds 70807, OS waits 2289
- Spin rounds per wait: 25.08 RW-shared, 4.86 RW-excl, 22.78 RW-sx
- ------------
- TRANSACTIONS
- ------------
- Trx id counter 539735827
- Purge done for trx's n:o < 539586225 undo n:o < 0 state: running
- History list length 17
- LIST OF TRANSACTIONS FOR EACH SESSION:
- ---TRANSACTION 421300747204952, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 539570313, ACTIVE 17 sec doing SYNC index
- 1 lock struct(s), heap size 1128, 0 row lock(s), undo log entries 693055
- ---TRANSACTION 539718750, ACTIVE 6 sec
- 54 lock struct(s), heap size 8312, 1439 row lock(s), undo log entries 5
- MySQL thread id 239991, OS thread handle 139802291545856, query id 51269077 XXXXXXXXXXXXXX XXXXXXXXXXXXXX XXXXXXXXXXXXXX
- Trx read view will not see trx with id >= 539584824, sees < 539570313
- ---TRANSACTION 421300747129784, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421300747171544, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421300747230008, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421300747200776, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421300747263416, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421300747238360, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421300747234184, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421300747192424, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421300747184072, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421300747225832, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421300747188248, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421300747138136, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421300747133960, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421300747121432, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421300747179896, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421300747175720, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421300747167368, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421300747163192, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421300747159016, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421300747154840, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421300747150664, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421300747146488, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421300747142312, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421300747125608, 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: 0
- 1404524 OS file reads, 54985554 OS file writes, 2072566 OS fsyncs
- 78.43 reads/s, 16384 avg bytes/read, 5685.01 writes/s, 131.31 fsyncs/s
- -------------------------------------
- INSERT BUFFER AND ADAPTIVE HASH INDEX
- -------------------------------------
- Ibuf: size 1, free list len 10893, seg size 10895, 20131 merges
- merged operations:
- insert 19326, delete mark 41419, delete 13357
- discarded operations:
- insert 0, delete mark 0, delete 0
- 0.00 hash searches/s, 146024.09 non-hash searches/s
- ---
- LOG
- ---
- Log sequence number 2524694141348
- Log flushed up to 2524683896429
- Pages flushed up to 2524625093493
- Last checkpoint at 2524621774065
- 0 pending log flushes, 0 pending chkp writes
- 206424 log i/o's done, 10.06 log i/o's/second
- ----------------------
- BUFFER POOL AND MEMORY
- ----------------------
- Total large memory allocated 21959278592
- Dictionary memory allocated 820512
- Buffer pool size 1310720
- Free buffers 8190
- Database pages 1302530
- Old database pages 480656
- Modified db pages 57594
- Percent of dirty pages(LRU & free pages): 4.394
- Max dirty pages percent: 75.000
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 1098072, not young 4800980
- 432.96 youngs/s, 220.22 non-youngs/s
- Pages read 1404194, created 97362, written 53650702
- 78.43 reads/s, 3.83 creates/s, 5575.07 writes/s
- Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 1302530, unzip_LRU len: 0
- I/O sum[2288672]:cur[6456], unzip sum[0]:cur[0]
- ----------------------
- INDIVIDUAL BUFFER POOL INFO
- ----------------------
- ---BUFFER POOL 0
- Buffer pool size 163840
- Free buffers 1024
- Database pages 162816
- Old database pages 60082
- Modified db pages 7343
- Percent of dirty pages(LRU & free pages): 4.482
- Max dirty pages percent: 75.000
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 137729, not young 624469
- 59.23 youngs/s, 48.66 non-youngs/s
- Pages read 176145, created 11776, written 6800193
- 9.66 reads/s, 0.03 creates/s, 694.75 writes/s
- Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 162816, unzip_LRU len: 0
- I/O sum[286084]:cur[807], unzip sum[0]:cur[0]
- ---BUFFER POOL 1
- Buffer pool size 163840
- Free buffers 1024
- Database pages 162816
- Old database pages 60082
- Modified db pages 7428
- Percent of dirty pages(LRU & free pages): 4.534
- Max dirty pages percent: 75.000
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 136259, not young 610636
- 55.97 youngs/s, 33.11 non-youngs/s
- Pages read 174252, created 12445, written 6728748
- 9.97 reads/s, 0.86 creates/s, 700.15 writes/s
- Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 162816, unzip_LRU len: 0
- I/O sum[286084]:cur[807], unzip sum[0]:cur[0]
- ---BUFFER POOL 2
- Buffer pool size 163840
- Free buffers 1024
- Database pages 162816
- Old database pages 60082
- Modified db pages 6918
- Percent of dirty pages(LRU & free pages): 4.222
- Max dirty pages percent: 75.000
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 130702, not young 464917
- 55.34 youngs/s, 24.74 non-youngs/s
- Pages read 174655, created 11913, written 6583056
- 10.46 reads/s, 1.89 creates/s, 678.07 writes/s
- Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 162816, unzip_LRU len: 0
- I/O sum[286084]:cur[807], unzip sum[0]:cur[0]
- ---BUFFER POOL 3
- Buffer pool size 163840
- Free buffers 1022
- Database pages 162818
- Old database pages 60082
- Modified db pages 7487
- Percent of dirty pages(LRU & free pages): 4.570
- Max dirty pages percent: 75.000
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 140469, not young 678974
- 50.06 youngs/s, 19.80 non-youngs/s
- Pages read 175955, created 12262, written 6933633
- 9.80 reads/s, 0.86 creates/s, 712.35 writes/s
- Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 162818, unzip_LRU len: 0
- I/O sum[286084]:cur[807], unzip sum[0]:cur[0]
- ---BUFFER POOL 4
- Buffer pool size 163840
- Free buffers 1024
- Database pages 162816
- Old database pages 60082
- Modified db pages 7128
- Percent of dirty pages(LRU & free pages): 4.351
- Max dirty pages percent: 75.000
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 135781, not young 559626
- 50.66 youngs/s, 17.60 non-youngs/s
- Pages read 173765, created 12185, written 6674812
- 8.74 reads/s, 0.00 creates/s, 691.24 writes/s
- Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 162816, unzip_LRU len: 0
- I/O sum[286084]:cur[807], unzip sum[0]:cur[0]
- ---BUFFER POOL 5
- Buffer pool size 163840
- Free buffers 1024
- Database pages 162816
- Old database pages 60082
- Modified db pages 7175
- Percent of dirty pages(LRU & free pages): 4.379
- Max dirty pages percent: 75.000
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 135831, not young 604644
- 58.94 youngs/s, 32.54 non-youngs/s
- Pages read 175044, created 11853, written 6656589
- 10.54 reads/s, 0.00 creates/s, 698.27 writes/s
- Buffer pool hit rate 999 / 1000, young-making rate 1 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 162816, unzip_LRU len: 0
- I/O sum[286084]:cur[807], unzip sum[0]:cur[0]
- ---BUFFER POOL 6
- Buffer pool size 163840
- Free buffers 1024
- Database pages 162816
- Old database pages 60082
- Modified db pages 7081
- Percent of dirty pages(LRU & free pages): 4.322
- Max dirty pages percent: 75.000
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 141397, not young 598200
- 49.77 youngs/s, 18.60 non-youngs/s
- Pages read 177610, created 12626, written 6675950
- 8.60 reads/s, 0.11 creates/s, 700.35 writes/s
- Buffer pool hit rate 999 / 1000, young-making rate 1 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 162816, unzip_LRU len: 0
- I/O sum[286084]:cur[807], unzip sum[0]:cur[0]
- ---BUFFER POOL 7
- Buffer pool size 163840
- Free buffers 1024
- Database pages 162816
- Old database pages 60082
- Modified db pages 7034
- Percent of dirty pages(LRU & free pages): 4.293
- Max dirty pages percent: 75.000
- Pending reads 0
- Pending writes: LRU 0, flush list 0, single page 0
- Pages made young 139904, not young 659514
- 53.00 youngs/s, 25.17 non-youngs/s
- Pages read 176768, created 12302, written 6597721
- 10.66 reads/s, 0.09 creates/s, 699.89 writes/s
- Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000
- Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
- LRU len: 162816, unzip_LRU len: 0
- I/O sum[286084]:cur[807], unzip sum[0]:cur[0]
- --------------
- ROW OPERATIONS
- --------------
- 0 queries inside InnoDB, 0 queries in queue
- 1 read views open inside InnoDB
- Process ID=15676, Main thread ID=139801724438272, state: sleeping
- Number of rows inserted 71254, updated 11185439, deleted 26361, read 12201341947
- 2.83 inserts/s, 3.14 updates/s, 0.00 deletes/s, 116691.92 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
- ============================
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement