파일을 여기로 끌어오세요
콘솔
스토리지 엔진
InnoDB
Supports transactions, row-level locking, foreign keys and encryption for tables
===================================== 2026-03-18 16:46:09 0x7fdb5c0a9700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 39 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 7844 srv_active, 0 srv_shutdown, 4628 srv_idle srv_master_thread log flush and writes: 12472 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 25872 OS WAIT ARRAY INFO: signal count 20313 RW-shared spins 0, rounds 8810, OS waits 4394 RW-excl spins 0, rounds 3319, OS waits 110 RW-sx spins 4, rounds 91, OS waits 3 Spin rounds per wait: 8810.00 RW-shared, 3319.00 RW-excl, 22.75 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 71062 Purge done for trx's n:o < 71062 undo n:o < 0 state: running but idle History list length 17 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 422054880883672, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422054880879416, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422054880875160, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422054880866648, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422054880862392, 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: 0 863 OS file reads, 109962 OS file writes, 54429 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 2.10 writes/s, 2.10 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 69257, node heap has 1 buffer(s) Hash table size 69257, node heap has 10 buffer(s) Hash table size 69257, node heap has 2 buffer(s) Hash table size 69257, node heap has 25 buffer(s) Hash table size 69257, node heap has 1 buffer(s) Hash table size 69257, node heap has 3 buffer(s) Hash table size 69257, node heap has 26 buffer(s) Hash table size 69257, node heap has 0 buffer(s) 6.90 hash searches/s, 2.67 non-hash searches/s --- LOG --- Log sequence number 32837219 Log flushed up to 32837082 Pages flushed up to 32734781 Last checkpoint at 32734772 0 pending log flushes, 0 pending chkp writes 33374 log i/o's done, 2.10 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 285212672 Dictionary memory allocated 154976 Buffer pool size 16024 Free buffers 15042 Database pages 914 Old database pages 333 Modified db pages 194 Percent of dirty pages(LRU & free pages): 1.216 Max dirty pages percent: 75.000 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 704, created 210, written 68525 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: 914, 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=908, Main thread ID=140579404982016, state: sleeping Number of rows inserted 62, updated 16452, deleted 0, read 1336907 0.00 inserts/s, 1.95 updates/s, 0.00 deletes/s, 9.05 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 5919 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================