Console
Storage engines
InnoDB
Supports transactions, row-level locking, foreign keys and encryption for tables
[ Variables | Buffer Pool | InnoDB Status ]
===================================== 2026-10-20 01:51:57 0x58c8 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 11 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1757841 srv_active, 0 srv_shutdown, 36495 srv_idle srv_master_thread log flush and writes: 1794315 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 431939060 OS WAIT ARRAY INFO: signal count 556344626 RW-shared spins 742433541, rounds 11419070726, OS waits 221092084 RW-excl spins 642397313, rounds 8825612592, OS waits 158109538 RW-sx spins 35082446, rounds 351451267, OS waits 5353685 Spin rounds per wait: 15.38 RW-shared, 13.74 RW-excl, 10.02 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 2600812377 Purge done for trx's n:o < 2587812750 undo n:o < 0 state: running but idle History list length 6383734 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 282891049365792, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 282891049361624, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 282891049357456, ACTIVE 60900 sec 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 5185071, OS thread handle 18496, query id 1821885686 localhost 127.0.0.1 root Trx read view will not see trx with id >= 2587812746, sees < 2587812740 -------- 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 2137218993 OS file reads, 2310872291 OS file writes, 286455876 OS fsyncs 243.80 reads/s, 16384 avg bytes/read, 392.87 writes/s, 57.45 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 2908, free list len 37304, seg size 40213, 191118187 merges merged operations: insert 553160933, delete mark 987688855, delete 8572524 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 553253, node heap has 3174 buffer(s) Hash table size 553253, node heap has 161 buffer(s) Hash table size 553253, node heap has 29 buffer(s) Hash table size 553253, node heap has 7 buffer(s) Hash table size 553253, node heap has 4 buffer(s) Hash table size 553253, node heap has 5 buffer(s) Hash table size 553253, node heap has 36 buffer(s) Hash table size 553253, node heap has 6 buffer(s) 1791.84 hash searches/s, 5130.72 non-hash searches/s --- LOG --- Log sequence number 4797979520338 Log flushed up to 4797979520338 Pages flushed up to 4797979011187 Last checkpoint at 4797978348156 0 pending log flushes, 0 pending chkp writes 154095433 log i/o's done, 8.36 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 2281701376 Dictionary memory allocated 262920 Buffer pool size 128432 Free buffers 8159 Database pages 116851 Old database pages 42976 Modified db pages 1253 Percent of dirty pages(LRU & free pages): 1.002 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1300549564, not young 96470531093 3.18 youngs/s, 1705.66 non-youngs/s Pages read 2137218885, created 22656165, written 2097646637 243.80 reads/s, 6.54 creates/s, 365.78 writes/s Buffer pool hit rate 992 / 1000, young-making rate 0 / 1000 not 55 / 1000 Pages read ahead 197.71/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 116851, unzip_LRU len: 0 I/O sum[187808]:cur[0], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 16054 Free buffers 1018 Database pages 14620 Old database pages 5377 Modified db pages 98 Percent of dirty pages(LRU & free pages): 0.627 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 178628644, not young 12475766100 0.45 youngs/s, 122.90 non-youngs/s Pages read 261062870, created 2880945, written 260813847 18.27 reads/s, 0.18 creates/s, 36.63 writes/s Buffer pool hit rate 993 / 1000, young-making rate 0 / 1000 not 46 / 1000 Pages read ahead 11.64/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 14620, unzip_LRU len: 0 I/O sum[23476]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 16054 Free buffers 1020 Database pages 14627 Old database pages 5382 Modified db pages 108 Percent of dirty pages(LRU & free pages): 0.690 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 130025566, not young 11651490035 0.00 youngs/s, 270.07 non-youngs/s Pages read 252657240, created 2843088, written 251924355 37.27 reads/s, 0.36 creates/s, 36.72 writes/s Buffer pool hit rate 987 / 1000, young-making rate 0 / 1000 not 89 / 1000 Pages read ahead 34.91/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 14627, unzip_LRU len: 0 I/O sum[23476]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 16054 Free buffers 1017 Database pages 14590 Old database pages 5365 Modified db pages 184 Percent of dirty pages(LRU & free pages): 1.179 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 216661001, not young 12964316695 0.55 youngs/s, 202.25 non-youngs/s Pages read 293851182, created 2790041, written 276875498 25.54 reads/s, 0.91 creates/s, 53.45 writes/s Buffer pool hit rate 997 / 1000, young-making rate 0 / 1000 not 23 / 1000 Pages read ahead 23.27/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 14590, unzip_LRU len: 0 I/O sum[23476]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 16054 Free buffers 1018 Database pages 14601 Old database pages 5369 Modified db pages 141 Percent of dirty pages(LRU & free pages): 0.903 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 149175285, not young 11715349537 0.45 youngs/s, 219.25 non-youngs/s Pages read 268336709, created 2815269, written 263869530 19.54 reads/s, 2.09 creates/s, 52.18 writes/s Buffer pool hit rate 992 / 1000, young-making rate 0 / 1000 not 81 / 1000 Pages read ahead 17.36/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 14601, unzip_LRU len: 0 I/O sum[23476]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 16054 Free buffers 1021 Database pages 14577 Old database pages 5361 Modified db pages 255 Percent of dirty pages(LRU & free pages): 1.635 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 144172977, not young 11616650936 0.45 youngs/s, 258.98 non-youngs/s Pages read 258486045, created 2836145, written 275388097 34.54 reads/s, 1.27 creates/s, 53.81 writes/s Buffer pool hit rate 992 / 1000, young-making rate 0 / 1000 not 56 / 1000 Pages read ahead 29.09/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 14577, unzip_LRU len: 0 I/O sum[23476]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 16054 Free buffers 1019 Database pages 14594 Old database pages 5368 Modified db pages 149 Percent of dirty pages(LRU & free pages): 0.954 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 199815359, not young 12782881795 0.64 youngs/s, 186.62 non-youngs/s Pages read 292844741, created 2833383, written 263928122 37.54 reads/s, 1.09 creates/s, 39.36 writes/s Buffer pool hit rate 987 / 1000, young-making rate 0 / 1000 not 59 / 1000 Pages read ahead 29.09/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 14594, unzip_LRU len: 0 I/O sum[23476]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 16054 Free buffers 1022 Database pages 14626 Old database pages 5379 Modified db pages 123 Percent of dirty pages(LRU & free pages): 0.786 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 139183163, not young 11426613780 0.27 youngs/s, 202.07 non-youngs/s Pages read 246314564, created 2819362, written 251340827 32.72 reads/s, 0.64 creates/s, 39.81 writes/s Buffer pool hit rate 990 / 1000, young-making rate 0 / 1000 not 58 / 1000 Pages read ahead 17.45/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 14626, unzip_LRU len: 0 I/O sum[23476]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 16054 Free buffers 1024 Database pages 14616 Old database pages 5375 Modified db pages 195 Percent of dirty pages(LRU & free pages): 1.247 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 142887569, not young 11837462215 0.36 youngs/s, 243.52 non-youngs/s Pages read 263665534, created 2837932, written 253506361 38.36 reads/s, 0.00 creates/s, 53.81 writes/s Buffer pool hit rate 984 / 1000, young-making rate 0 / 1000 not 97 / 1000 Pages read ahead 34.91/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 14616, unzip_LRU len: 0 I/O sum[23476]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Process ID=4344, Main thread ID=5928, state: sleeping Number of rows inserted 410221341, updated 314460576, deleted 409206864, read 235557777950 0.09 inserts/s, 102.72 updates/s, 0.00 deletes/s, 22796.47 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 345909 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================