|
- mysql> show engine innodb status\G
- *************************** 1. row ***************************
- Type: InnoDB
- Name:
- Status:
- =====================================
- 2024-12-12 14:55:26 140047534749248 INNODB MONITOR OUTPUT
- =====================================
- Per second averages calculated from the last 11 seconds
- -----------------
- BACKGROUND THREAD
- -----------------
- srv_master_thread loops: 8 srv_active, 0 srv_shutdown, 598 srv_idle
- srv_master_thread log flush and writes: 0
- ----------
- SEMAPHORES
- ----------
- OS WAIT ARRAY INFO: reservation count 149
- OS WAIT ARRAY INFO: signal count 106
- RW-shared spins 0, rounds 0, OS waits 0
- RW-excl spins 0, rounds 0, OS waits 0
- RW-sx spins 0, rounds 0, OS waits 0
- Spin rounds per wait: 0.00 RW-shared, 0.00 RW-excl, 0.00 RW-sx
- ------------
- TRANSACTIONS
- ------------
- Trx id counter 15703
- Purge done for trx's n:o < 15702 undo n:o < 0 state: running but idle
- History list length 0
- LIST OF TRANSACTIONS FOR EACH SESSION:
- ---TRANSACTION 421529099757576, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099756728, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099755880, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099755032, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099754184, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099753336, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099752488, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099751640, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099750792, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099749944, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099749096, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099748248, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099747400, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099746552, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099745704, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099744856, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099744008, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099743160, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099742312, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099741464, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099740616, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099739768, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099738920, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099738072, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099737224, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099736376, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099735528, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099734680, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099733832, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099732984, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099732136, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099731288, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099730440, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099729592, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099728744, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099727896, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099727048, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099726200, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099725352, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099724504, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099723656, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099722808, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099721960, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099721112, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099720264, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099719416, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099718568, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099717720, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099716872, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099716024, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099715176, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099714328, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099713480, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099712632, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099711784, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099710936, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099710088, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099709240, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099708392, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099707544, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099706696, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099705848, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099705000, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099704152, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099703304, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099700760, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099702456, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099701608, not started
- 0 lock struct(s), heap size 1128, 0 row lock(s)
- ---TRANSACTION 421529099699912, 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:
- Pending flushes (fsync) log: 0; buffer pool: 0
- 1333 OS file reads, 2154 OS file writes, 443 OS fsyncs
- 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
- -------------------------------------
- INSERT BUFFER AND ADAPTIVE HASH INDEX
- -------------------------------------
- Ibuf: size 1, free list len 0, seg size 2, 0 merges
- merged operations:
- insert 0, delete mark 0, delete 0
- discarded operations:
- insert 0, delete mark 0, delete 0
- Hash table size 2656321, node heap has 0 buffer(s)
- Hash table size 2656321, node heap has 0 buffer(s)
- Hash table size 2656321, node heap has 0 buffer(s)
- Hash table size 2656321, node heap has 0 buffer(s)
- Hash table size 2656321, node heap has 0 buffer(s)
- Hash table size 2656321, node heap has 0 buffer(s)
- Hash table size 2656321, node heap has 0 buffer(s)
- Hash table size 2656321, node heap has 0 buffer(s)
- 0.00 hash searches/s, 0.00 non-hash searches/s
- ---
- LOG
- ---
- Log sequence number 37108105
- Log buffer assigned up to 37108105
- Log buffer completed up to 37108105
- Log written up to 37108105
- Log flushed up to 37108105
- Added dirty pages up to 37108105
- Pages flushed up to 37108105
- Last checkpoint at 37108105
- Log minimum file id is 0
- Log maximum file id is 0
- Modified age no less than 37108105
- Checkpoint age 0
- Max checkpoint age 5422668288
- 260 log i/o's done, 0.00 log i/o's/second
- ----------------------
- BUFFER POOL AND MEMORY
- ----------------------
- Total large memory allocated 0
- Dictionary memory allocated 510082
- Buffer pool size 655280
- Buffer pool size, bytes 10736107520
- Free buffers 653868
- Database pages 1412
- Old database pages 0
- Modified db pages 0
- 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 1263, created 150, written 685
- 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: 1412, unzip_LRU len: 0
- I/O sum[0]:cur[0], unzip sum[0]:cur[0]
- ----------------------
- INDIVIDUAL BUFFER POOL INFO
- ----------------------
- ---BUFFER POOL 0
- Buffer pool size 81910
- Buffer pool size, bytes 1342013440
- Free buffers 81787
- Database pages 123
- Old database pages 0
- Modified db pages 0
- 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 118, created 5, written 74
- 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: 123, unzip_LRU len: 0
- I/O sum[0]:cur[0], unzip sum[0]:cur[0]
- ---BUFFER POOL 1
- Buffer pool size 81910
- Buffer pool size, bytes 1342013440
- Free buffers 81822
- Database pages 88
- Old database pages 0
- Modified db pages 0
- 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 86, created 2, written 15
- 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: 88, unzip_LRU len: 0
- I/O sum[0]:cur[0], unzip sum[0]:cur[0]
- ---BUFFER POOL 2
- Buffer pool size 81910
- Buffer pool size, bytes 1342013440
- Free buffers 81841
- Database pages 69
- Old database pages 0
- Modified db pages 0
- 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 69, created 0, written 82
- 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: 69, unzip_LRU len: 0
- I/O sum[0]:cur[0], unzip sum[0]:cur[0]
- ---BUFFER POOL 3
- Buffer pool size 81910
- Buffer pool size, bytes 1342013440
- Free buffers 81589
- Database pages 321
- Old database pages 0
- Modified db pages 0
- 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 320, created 1, written 69
- 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: 321, unzip_LRU len: 0
- I/O sum[0]:cur[0], unzip sum[0]:cur[0]
- ---BUFFER POOL 4
- Buffer pool size 81910
- Buffer pool size, bytes 1342013440
- Free buffers 81790
- Database pages 120
- Old database pages 0
- Modified db pages 0
- 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 117, created 3, written 48
- 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: 120, unzip_LRU len: 0
- I/O sum[0]:cur[0], unzip sum[0]:cur[0]
- ---BUFFER POOL 5
- Buffer pool size 81910
- Buffer pool size, bytes 1342013440
- Free buffers 81872
- Database pages 38
- Old database pages 0
- Modified db pages 0
- 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 37, created 1, written 10
- 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: 38, unzip_LRU len: 0
- I/O sum[0]:cur[0], unzip sum[0]:cur[0]
- ---BUFFER POOL 6
- Buffer pool size 81910
- Buffer pool size, bytes 1342013440
- Free buffers 81637
- Database pages 273
- Old database pages 0
- Modified db pages 0
- 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 205, created 68, written 158
- 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: 273, unzip_LRU len: 0
- I/O sum[0]:cur[0], unzip sum[0]:cur[0]
- ---BUFFER POOL 7
- Buffer pool size 81910
- Buffer pool size, bytes 1342013440
- Free buffers 81530
- Database pages 380
- Old database pages 0
- Modified db pages 0
- 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 311, created 70, written 229
- 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: 380, unzip_LRU len: 0
- I/O sum[0]:cur[0], 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=2174063, Main thread ID=140041955309120 , state=sleeping
- Number of rows inserted 0, updated 4, deleted 0, read 4
- 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
- Number of system rows inserted 41, updated 418, deleted 33, read 7612
- 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
- ----------------------------
- END OF INNODB MONITOR OUTPUT
- ============================
- 1 row in set (0.00 sec)
复制代码 |
|