- 表收藏夹为空。
将文件拖动至此
控制台
存储引擎
InnoDB
Supports transactions, row-level locking, foreign keys and encryption for tables
===================================== 2025-07-02 09:40:50 0x1764 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 6 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1741 srv_active, 0 srv_shutdown, 3837 srv_idle srv_master_thread log flush and writes: 5578 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 9281 OS WAIT ARRAY INFO: signal count 6763 RW-shared spins 15927, rounds 118078, OS waits 2006 RW-excl spins 6283, rounds 51395, OS waits 761 RW-sx spins 137, rounds 2955, OS waits 82 Spin rounds per wait: 7.41 RW-shared, 8.18 RW-excl, 21.57 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 3770345 Purge done for trx's n:o < 3770345 undo n:o < 0 state: running but idle History list length 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 283814739938256, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739934088, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739929920, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739925752, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739913248, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739921584, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739917416, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739909080, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739784040, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739859064, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739863232, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739904912, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739900744, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739875736, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739896576, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739892408, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739888240, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739884072, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739879904, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739842392, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739871568, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739867400, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739854896, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739850728, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739846560, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739838224, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739834056, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739829888, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739825720, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739821552, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739817384, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739813216, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739804880, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739800712, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739796544, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739775704, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739792376, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739788208, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739779872, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739809048, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 283814739771536, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: native aio handle (insert buffer thread) I/O thread 1 state: native aio handle (log thread) I/O thread 2 state: native aio handle (read thread) I/O thread 3 state: native aio handle (read thread) I/O thread 4 state: native aio handle (read thread) I/O thread 5 state: native aio handle (read thread) I/O thread 6 state: native aio handle (write thread) I/O thread 7 state: native aio handle (write thread) I/O thread 8 state: native aio handle (write thread) I/O thread 9 state: native aio handle (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 38429 OS file reads, 39348 OS file writes, 21154 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 24, seg size 26, 3715 merges merged operations: insert 2840, delete mark 12845, delete 10772 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 1106407, node heap has 841 buffer(s) Hash table size 1106407, node heap has 187 buffer(s) Hash table size 1106407, node heap has 13 buffer(s) Hash table size 1106407, node heap has 19 buffer(s) Hash table size 1106407, node heap has 97 buffer(s) Hash table size 1106407, node heap has 355 buffer(s) Hash table size 1106407, node heap has 16 buffer(s) Hash table size 1106407, node heap has 78 buffer(s) 70725.21 hash searches/s, 1387.27 non-hash searches/s --- LOG --- Log sequence number 10653251202 Log flushed up to 10653251202 Pages flushed up to 10653251202 Last checkpoint at 10653251193 0 pending log flushes, 0 pending chkp writes 4985 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 4462739456 Dictionary memory allocated 2511512 Buffer pool size 256864 Free buffers 217531 Database pages 37727 Old database pages 14083 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 111, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 37421, created 306, written 28875 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 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: 37727, 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 32108 Free buffers 27166 Database pages 4730 Old database pages 1766 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 16, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 4715, created 15, written 3657 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 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: 4730, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 32108 Free buffers 27157 Database pages 4755 Old database pages 1775 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 11, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 4745, created 10, written 4456 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 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: 4755, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 32108 Free buffers 27043 Database pages 4873 Old database pages 1818 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 21, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 4832, created 41, written 2970 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 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: 4873, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 32108 Free buffers 27120 Database pages 4766 Old database pages 1779 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 11, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 4756, created 10, written 4173 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 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: 4766, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 32108 Free buffers 26864 Database pages 5074 Old database pages 1893 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 14, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 5065, created 9, written 3816 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 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: 5074, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 32108 Free buffers 27481 Database pages 4431 Old database pages 1655 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 8, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 4355, created 76, written 3316 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 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: 4431, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 32108 Free buffers 27198 Database pages 4719 Old database pages 1761 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 17, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 4650, created 69, written 3765 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 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: 4719, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 32108 Free buffers 27502 Database pages 4379 Old database pages 1636 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 13, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 4303, created 76, written 2722 0.00 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 1000 / 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: 4379, 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 Process ID=11420, Main thread ID=4512, state: sleeping Number of rows inserted 7189, updated 782, deleted 2571, read 853443560 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 165368.11 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 ============================