MariaDB [(none)]> show engine innodb status -> ; +--------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Type | Name | Status | +--------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | InnoDB | | ===================================== 2019-06-01 10:29:26 0x7fe7f3913700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 41 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 2765 srv_active, 0 srv_shutdown, 1 srv_idle srv_master_thread log flush and writes: 2766 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1424 OS WAIT ARRAY INFO: signal count 3162 RW-shared spins 0, rounds 2671, OS waits 619 RW-excl spins 0, rounds 83216, OS waits 172 RW-sx spins 26, rounds 113, OS waits 2 Spin rounds per wait: 2671.00 RW-shared, 83216.00 RW-excl, 4.35 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 544727 Purge done for trx's n:o < 544727 undo n:o < 0 state: running History list length 3 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 422118656232024, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656227808, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656223592, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656219376, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656215160, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656210944, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656206728, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656194080, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656198296, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656189864, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656185648, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656202512, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656181432, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656177216, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656168784, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656173000, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656164568, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656156136, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656151920, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656160352, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656147704, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656143488, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656139272, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656135056, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656126624, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656130840, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656109760, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656122408, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656118192, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656105544, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656101328, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656092896, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656080248, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656097112, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656113976, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656088680, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656084464, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656076032, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656025440, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656071816, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656067600, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656063384, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656059168, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656054952, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656050736, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656033872, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656046520, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656042304, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656038088, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656029656, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656021224, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656017008, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656004360, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656012792, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656008576, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422118656000144, 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 132906 OS file reads, 186946 OS file writes, 97438 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 78.00 writes/s, 38.88 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 18, seg size 20, 381 merges merged operations: insert 3058, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 2212699, node heap has 22 buffer(s) Hash table size 2212699, node heap has 35 buffer(s) Hash table size 2212699, node heap has 43 buffer(s) Hash table size 2212699, node heap has 86 buffer(s) Hash table size 2212699, node heap has 982 buffer(s) Hash table size 2212699, node heap has 21 buffer(s) Hash table size 2212699, node heap has 107 buffer(s) Hash table size 2212699, node heap has 39 buffer(s) 5311.92 hash searches/s, 2531.60 non-hash searches/s --- LOG --- Log sequence number 9639013468 Log flushed up to 9639010540 Pages flushed up to 9638998072 Last checkpoint at 9638958094 0 pending log flushes, 0 pending chkp writes 5061 log i/o's done, 2.02 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 8820621312 Dictionary memory allocated 435744 Buffer pool size 524288 Free buffers 388596 Database pages 134357 Old database pages 49505 Modified db pages 67 Percent of dirty pages(LRU & free pages): 0.013 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 146, not young 0 0.02 youngs/s, 0.00 non-youngs/s Pages read 132704, created 1653, written 143655 0.00 reads/s, 0.66 creates/s, 61.63 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: 134357, unzip_LRU len: 0 I/O sum[0]:cur[152], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 65536 Free buffers 48536 Database pages 16836 Old database pages 6206 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.005 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 19, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16625, created 211, written 15845 0.00 reads/s, 0.32 creates/s, 7.29 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: 16836, unzip_LRU len: 0 I/O sum[0]:cur[19], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 65536 Free buffers 48761 Database pages 16608 Old database pages 6118 Modified db pages 8 Percent of dirty pages(LRU & free pages): 0.012 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 9, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16452, created 156, written 17294 0.00 reads/s, 0.29 creates/s, 9.10 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: 16608, unzip_LRU len: 0 I/O sum[0]:cur[19], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 65536 Free buffers 48420 Database pages 16940 Old database pages 6233 Modified db pages 3 Percent of dirty pages(LRU & free pages): 0.005 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 26, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16729, created 211, written 10620 0.00 reads/s, 0.05 creates/s, 4.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: 16940, unzip_LRU len: 0 I/O sum[0]:cur[19], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 65536 Free buffers 48667 Database pages 16701 Old database pages 6145 Modified db pages 7 Percent of dirty pages(LRU & free pages): 0.011 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.02 youngs/s, 0.00 non-youngs/s Pages read 16482, created 219, written 27103 0.00 reads/s, 0.00 creates/s, 12.29 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: 16701, unzip_LRU len: 0 I/O sum[0]:cur[19], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 65536 Free buffers 48584 Database pages 16782 Old database pages 6174 Modified db pages 15 Percent of dirty pages(LRU & free pages): 0.023 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 27, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16590, created 192, written 17432 0.00 reads/s, 0.00 creates/s, 6.05 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: 16782, unzip_LRU len: 0 I/O sum[0]:cur[19], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 65536 Free buffers 48605 Database pages 16767 Old database pages 6186 Modified db pages 1 Percent of dirty pages(LRU & free pages): 0.002 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 10, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16625, created 142, written 14925 0.00 reads/s, 0.00 creates/s, 4.66 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: 16767, unzip_LRU len: 0 I/O sum[0]:cur[19], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 65536 Free buffers 48579 Database pages 16795 Old database pages 6179 Modified db pages 13 Percent of dirty pages(LRU & free pages): 0.020 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 16482, created 313, written 19416 0.00 reads/s, 0.00 creates/s, 8.37 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: 16795, unzip_LRU len: 0 I/O sum[0]:cur[19], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 65536 Free buffers 48444 Database pages 16928 Old database pages 6264 Modified db pages 17 Percent of dirty pages(LRU & free pages): 0.026 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 26, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16719, created 209, written 21020 0.00 reads/s, 0.00 creates/s, 9.88 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: 16928, unzip_LRU len: 0 I/O sum[0]:cur[19], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB Process ID=18942, Main thread ID=140634322966272, state: sleeping Number of rows inserted 279381, updated 81480, deleted 2, read 251687985 98.05 inserts/s, 25.83 updates/s, 0.00 deletes/s, 72634.40 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 ============================ | +--------+------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.001 sec)