MariaDB [(none)]> show engine innodb status\G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2019-05-27 13:30:52 0x7f264de06700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 21 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 758413 srv_active, 0 srv_shutdown, 6135 srv_idle srv_master_thread log flush and writes: 764545 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 1158149 OS WAIT ARRAY INFO: signal count 3880796 RW-shared spins 0, rounds 5379168, OS waits 377618 RW-excl spins 0, rounds 8359892, OS waits 44245 RW-sx spins 402679, rounds 3528914, OS waits 24274 Spin rounds per wait: 5379168.00 RW-shared, 8359892.00 RW-excl, 8.76 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 324629930 Purge done for trx's n:o < 272516657 undo n:o < 0 state: running but idle History list length 26056637 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421280667500928, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421280667496712, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421280667492496, 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 1022670 OS file reads, 57278236 OS file writes, 50288098 OS fsyncs 0.71 reads/s, 16384 avg bytes/read, 82.85 writes/s, 75.38 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 33531, seg size 33533, 376096 merges merged operations: insert 301023, delete mark 28069268, delete 583875 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 553253, node heap has 229 buffer(s) Hash table size 553253, node heap has 636 buffer(s) Hash table size 553253, node heap has 755 buffer(s) Hash table size 553253, node heap has 94 buffer(s) Hash table size 553253, node heap has 16 buffer(s) Hash table size 553253, node heap has 23 buffer(s) Hash table size 553253, node heap has 15 buffer(s) Hash table size 553253, node heap has 126 buffer(s) 163.85 hash searches/s, 233.99 non-hash searches/s --- LOG --- Log sequence number 197974781132 Log flushed up to 197974781016 Pages flushed up to 197927986355 Last checkpoint at 197927986355 0 pending log flushes, 0 pending chkp writes 47656406 log i/o's done, 72.38 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 2213543936 Dictionary memory allocated 528768 Buffer pool size 131072 Free buffers 8191 Database pages 120987 Old database pages 44498 Modified db pages 11136 Percent of dirty pages(LRU & free pages): 8.621 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 740631, not young 47388850 1.43 youngs/s, 1.33 non-youngs/s Pages read 1022451, created 956366, written 8953326 0.71 reads/s, 2.38 creates/s, 9.95 writes/s Buffer pool hit rate 999 / 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: 120987, unzip_LRU len: 0 I/O sum[4672]:cur[0], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 16384 Free buffers 1024 Database pages 15120 Old database pages 5561 Modified db pages 1512 Percent of dirty pages(LRU & free pages): 9.365 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 94371, not young 5600374 0.24 youngs/s, 0.00 non-youngs/s Pages read 129019, created 120123, written 1198822 0.00 reads/s, 0.19 creates/s, 1.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: 15120, unzip_LRU len: 0 I/O sum[584]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 16384 Free buffers 1025 Database pages 15118 Old database pages 5560 Modified db pages 1399 Percent of dirty pages(LRU & free pages): 8.666 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 93767, not young 5991898 0.14 youngs/s, 0.00 non-youngs/s Pages read 134090, created 119422, written 1073536 0.00 reads/s, 0.00 creates/s, 1.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: 15118, unzip_LRU len: 0 I/O sum[584]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 16384 Free buffers 1024 Database pages 15138 Old database pages 5568 Modified db pages 1311 Percent of dirty pages(LRU & free pages): 8.111 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 93387, not young 5607112 0.43 youngs/s, 0.10 non-youngs/s Pages read 129058, created 120390, written 1075267 0.05 reads/s, 0.00 creates/s, 1.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 1 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 15138, unzip_LRU len: 0 I/O sum[584]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 16384 Free buffers 1022 Database pages 15118 Old database pages 5560 Modified db pages 1510 Percent of dirty pages(LRU & free pages): 9.355 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 91495, not young 5804530 0.05 youngs/s, 0.38 non-youngs/s Pages read 125655, created 119551, written 1224121 0.19 reads/s, 1.90 creates/s, 1.00 writes/s Buffer pool hit rate 999 / 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: 15118, unzip_LRU len: 0 I/O sum[584]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 16384 Free buffers 1024 Database pages 15115 Old database pages 5559 Modified db pages 1498 Percent of dirty pages(LRU & free pages): 9.281 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 90048, not young 6197449 0.05 youngs/s, 0.29 non-youngs/s Pages read 125083, created 118759, written 1165934 0.14 reads/s, 0.10 creates/s, 1.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 1 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 15115, unzip_LRU len: 0 I/O sum[584]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 16384 Free buffers 1024 Database pages 15136 Old database pages 5567 Modified db pages 1095 Percent of dirty pages(LRU & free pages): 6.776 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 97287, not young 7152096 0.24 youngs/s, 0.10 non-youngs/s Pages read 132437, created 119505, written 1082656 0.05 reads/s, 0.10 creates/s, 1.00 writes/s Buffer pool hit rate 998 / 1000, young-making rate 6 / 1000 not 2 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 15136, unzip_LRU len: 0 I/O sum[584]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 16384 Free buffers 1024 Database pages 15119 Old database pages 5561 Modified db pages 1326 Percent of dirty pages(LRU & free pages): 8.214 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 86896, not young 5655099 0.24 youngs/s, 0.10 non-youngs/s Pages read 121497, created 118888, written 1056640 0.10 reads/s, 0.00 creates/s, 2.95 writes/s Buffer pool hit rate 998 / 1000, young-making rate 3 / 1000 not 1 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 15119, unzip_LRU len: 0 I/O sum[584]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 16384 Free buffers 1024 Database pages 15123 Old database pages 5562 Modified db pages 1485 Percent of dirty pages(LRU & free pages): 9.196 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 93380, not young 5380292 0.05 youngs/s, 0.38 non-youngs/s Pages read 125612, created 119728, written 1076350 0.19 reads/s, 0.10 creates/s, 1.00 writes/s Buffer pool hit rate 998 / 1000, young-making rate 0 / 1000 not 2 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 15123, unzip_LRU len: 0 I/O sum[584]: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=79242, Main thread ID=139802917492480, state: sleeping Number of rows inserted 6819088, updated 41833042, deleted 5490627, read 4079316835 13.14 inserts/s, 61.28 updates/s, 0.00 deletes/s, 727.49 reads/s Number of system rows inserted 46626221, updated 0, deleted 46626221, read 46626223 70.81 inserts/s, 0.00 updates/s, 70.81 deletes/s, 70.81 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================