SHOW ENGINE INNODB STATUS\G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2016-04-17 20:07:28 0x7f2175baa700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 57 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 894873 srv_active, 0 srv_shutdown, 661 srv_idle srv_master_thread log flush and writes: 895533 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 109154927 OS WAIT ARRAY INFO: signal count 42505886 RW-shared spins 0, rounds 208937507, OS waits 103381119 RW-excl spins 0, rounds 107179595, OS waits 1433699 RW-sx spins 198861, rounds 5214934, OS waits 140584 Spin rounds per wait: 208937507.00 RW-shared, 107179595.00 RW-excl, 26.22 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 73031935 Purge done for trx's n:o < 73031935 undo n:o < 0 state: running but idle History list length 2306 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421293661324368, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661279680, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661271472, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661273296, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661323456, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661320720, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661251408, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661322544, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661321632, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661319808, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661318896, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661317984, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661317072, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661316160, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661315248, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661312512, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661313424, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661314336, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661309776, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661310688, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661311600, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661308864, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661307952, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661307040, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661306128, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661305216, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661304304, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661303392, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661300656, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661297920, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661299744, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661298832, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661297008, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661302480, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661301568, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661296096, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661295184, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661294272, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661293360, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661291536, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661292448, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661290624, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661289712, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661288800, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661287888, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661286976, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661286064, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661285152, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661284240, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661283328, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661282416, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661281504, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661280592, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661278768, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661277856, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661276944, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661276032, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661275120, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661274208, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661272384, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661270560, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661269648, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661268736, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661267824, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661266912, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661266000, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661265088, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661264176, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661263264, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661262352, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661261440, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661260528, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661259616, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661258704, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661257792, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661256880, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661255968, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661255056, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661253232, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661254144, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421293661252320, 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, 1] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 0; buffer pool: 0 168190701 OS file reads, 88671923 OS file writes, 26161662 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 27.53 writes/s, 4.58 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 5676, seg size 5678, 43188 merges merged operations: insert 941229, delete mark 206847, delete 31870 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 9461113, node heap has 10589 buffer(s) Hash table size 9461113, node heap has 125 buffer(s) Hash table size 9461113, node heap has 315 buffer(s) Hash table size 9461113, node heap has 461 buffer(s) Hash table size 9461113, node heap has 2969 buffer(s) Hash table size 9461113, node heap has 84 buffer(s) Hash table size 9461113, node heap has 2318 buffer(s) Hash table size 9461113, node heap has 9133 buffer(s) 12321.64 hash searches/s, 861.86 non-hash searches/s --- LOG --- Log sequence number 413007863143 Log flushed up to 413007863143 Pages flushed up to 412959528189 Last checkpoint at 412959528189 0 pending log flushes, 0 pending chkp writes 10198832 log i/o's done, 10.56 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 35181821952 Dictionary memory allocated 8859599 Buffer pool size 2097024 Free buffers 32765 Database pages 2038265 Old database pages 751749 Modified db pages 55631 Pending reads 0 Pending writes: LRU 0, flush list 9, single page 0 Pages made young 96955807, not young 543255568 0.00 youngs/s, 0.00 non-youngs/s Pages read 168191038, created 3411249, written 67463478 0.00 reads/s, 2.30 creates/s, 15.81 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: 2038265, unzip_LRU len: 0 I/O sum[28640]:cur[224], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 65536 Free buffers 1024 Database pages 63703 Old database pages 23495 Modified db pages 1870 Pending reads 0 Pending writes: LRU 0, flush list 3, single page 0 Pages made young 1951925, not young 17815922 0.00 youngs/s, 0.00 non-youngs/s Pages read 5461141, created 111495, written 2300989 0.00 reads/s, 0.12 creates/s, 0.58 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: 63703, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 65528 Free buffers 1025 Database pages 63692 Old database pages 23491 Modified db pages 1749 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 3838651, not young 15958963 0.00 youngs/s, 0.00 non-youngs/s Pages read 4928667, created 105073, written 2097702 0.00 reads/s, 0.00 creates/s, 0.47 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: 63692, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 65536 Free buffers 1024 Database pages 63700 Old database pages 23494 Modified db pages 1380 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 1315891, not young 17863046 0.00 youngs/s, 0.00 non-youngs/s Pages read 5513854, created 106200, written 2101544 0.00 reads/s, 0.00 creates/s, 0.46 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: 63700, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 65528 Free buffers 1024 Database pages 63682 Old database pages 23487 Modified db pages 1843 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 3576353, not young 16322476 0.00 youngs/s, 0.00 non-youngs/s Pages read 5200008, created 105685, written 2214444 0.00 reads/s, 0.00 creates/s, 0.47 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: 63682, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 65536 Free buffers 1024 Database pages 63693 Old database pages 23491 Modified db pages 1950 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1246272, not young 18396723 0.00 youngs/s, 0.00 non-youngs/s Pages read 5670711, created 106221, written 2095769 0.00 reads/s, 0.00 creates/s, 0.46 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: 63693, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 65528 Free buffers 1024 Database pages 63684 Old database pages 23488 Modified db pages 944 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1352451, not young 17606210 0.00 youngs/s, 0.00 non-youngs/s Pages read 5479049, created 104222, written 2095135 0.00 reads/s, 0.00 creates/s, 0.46 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: 63684, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 65536 Free buffers 1024 Database pages 63696 Old database pages 23492 Modified db pages 2043 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 3681842, not young 16258990 0.00 youngs/s, 0.00 non-youngs/s Pages read 5046201, created 106532, written 2142124 0.00 reads/s, 0.00 creates/s, 0.47 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: 63696, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 65528 Free buffers 1024 Database pages 63699 Old database pages 23493 Modified db pages 1682 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1327638, not young 18257299 0.00 youngs/s, 0.00 non-youngs/s Pages read 5697265, created 105675, written 2091326 0.00 reads/s, 0.00 creates/s, 0.46 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: 63699, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 8 Buffer pool size 65536 Free buffers 1024 Database pages 63695 Old database pages 23492 Modified db pages 1312 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 5662173, not young 17190800 0.00 youngs/s, 0.00 non-youngs/s Pages read 5180259, created 108000, written 2082040 0.00 reads/s, 0.00 creates/s, 0.46 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: 63695, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 9 Buffer pool size 65528 Free buffers 1024 Database pages 63684 Old database pages 23488 Modified db pages 1839 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 3453148, not young 16672484 0.00 youngs/s, 0.00 non-youngs/s Pages read 5243098, created 108727, written 2087370 0.00 reads/s, 0.00 creates/s, 0.47 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: 63684, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 10 Buffer pool size 65536 Free buffers 1024 Database pages 63693 Old database pages 23491 Modified db pages 1832 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2778398, not young 17417728 0.00 youngs/s, 0.00 non-youngs/s Pages read 5496500, created 106785, written 2128839 0.00 reads/s, 0.00 creates/s, 0.46 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: 63693, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 11 Buffer pool size 65528 Free buffers 1024 Database pages 63691 Old database pages 23490 Modified db pages 1860 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 3541012, not young 15859799 0.00 youngs/s, 0.00 non-youngs/s Pages read 4915175, created 108089, written 2083353 0.00 reads/s, 0.00 creates/s, 0.47 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: 63691, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 12 Buffer pool size 65536 Free buffers 1024 Database pages 63698 Old database pages 23493 Modified db pages 1771 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 5467866, not young 17049345 0.00 youngs/s, 0.00 non-youngs/s Pages read 5195962, created 107795, written 2073155 0.00 reads/s, 0.00 creates/s, 0.46 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: 63698, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 13 Buffer pool size 65528 Free buffers 1024 Database pages 63696 Old database pages 23492 Modified db pages 1502 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 4133470, not young 17628970 0.00 youngs/s, 0.00 non-youngs/s Pages read 5289935, created 107828, written 2147308 0.00 reads/s, 0.00 creates/s, 0.46 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: 63696, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 14 Buffer pool size 65536 Free buffers 1024 Database pages 63698 Old database pages 23493 Modified db pages 2130 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1366317, not young 17548108 0.00 youngs/s, 0.00 non-youngs/s Pages read 5389838, created 107245, written 2078281 0.00 reads/s, 0.00 creates/s, 0.46 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: 63698, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 15 Buffer pool size 65528 Free buffers 1024 Database pages 63697 Old database pages 23493 Modified db pages 1899 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 3387579, not young 16605279 0.00 youngs/s, 0.00 non-youngs/s Pages read 5242301, created 107506, written 2104538 0.00 reads/s, 0.00 creates/s, 0.46 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: 63697, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 16 Buffer pool size 65536 Free buffers 1024 Database pages 63712 Old database pages 23498 Modified db pages 2138 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 6407629, not young 13457818 0.00 youngs/s, 0.00 non-youngs/s Pages read 3982320, created 108401, written 2107844 0.00 reads/s, 0.00 creates/s, 1.35 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: 63712, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 17 Buffer pool size 65528 Free buffers 1024 Database pages 63695 Old database pages 23492 Modified db pages 1779 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2775285, not young 17006566 0.00 youngs/s, 0.00 non-youngs/s Pages read 5282839, created 108312, written 2160739 0.00 reads/s, 0.26 creates/s, 0.46 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: 63695, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 18 Buffer pool size 65536 Free buffers 1024 Database pages 63713 Old database pages 23499 Modified db pages 1880 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1273924, not young 17944115 0.00 youngs/s, 0.00 non-youngs/s Pages read 5593544, created 107111, written 2065005 0.00 reads/s, 0.02 creates/s, 0.47 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: 63713, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 19 Buffer pool size 65528 Free buffers 1023 Database pages 63699 Old database pages 23493 Modified db pages 1677 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 3624669, not young 16147103 0.00 youngs/s, 0.00 non-youngs/s Pages read 5123402, created 106703, written 2101169 0.00 reads/s, 0.39 creates/s, 0.47 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: 63699, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 20 Buffer pool size 65536 Free buffers 1024 Database pages 63706 Old database pages 23496 Modified db pages 2175 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 4111461, not young 16748556 0.00 youngs/s, 0.00 non-youngs/s Pages read 5227182, created 105410, written 2109166 0.00 reads/s, 0.00 creates/s, 0.47 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: 63706, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 21 Buffer pool size 65528 Free buffers 1024 Database pages 63697 Old database pages 23493 Modified db pages 1455 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 3063541, not young 16490046 0.00 youngs/s, 0.00 non-youngs/s Pages read 5153407, created 106089, written 2045993 0.00 reads/s, 0.09 creates/s, 0.47 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: 63697, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 22 Buffer pool size 65536 Free buffers 1024 Database pages 63706 Old database pages 23496 Modified db pages 1882 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1971113, not young 18715439 0.00 youngs/s, 0.00 non-youngs/s Pages read 5777820, created 105382, written 2114181 0.00 reads/s, 0.00 creates/s, 0.46 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: 63706, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 23 Buffer pool size 65528 Free buffers 1024 Database pages 63680 Old database pages 23486 Modified db pages 1348 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 6425250, not young 13250836 0.00 youngs/s, 0.00 non-youngs/s Pages read 3871747, created 106012, written 2078845 0.00 reads/s, 0.00 creates/s, 0.46 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: 63680, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 24 Buffer pool size 65536 Free buffers 1024 Database pages 63683 Old database pages 23487 Modified db pages 1656 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1269054, not young 18022741 0.00 youngs/s, 0.00 non-youngs/s Pages read 5583558, created 105022, written 2060119 0.00 reads/s, 0.00 creates/s, 0.46 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: 63683, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 25 Buffer pool size 65528 Free buffers 1024 Database pages 63687 Old database pages 23489 Modified db pages 1385 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 3872430, not young 15782383 0.00 youngs/s, 0.00 non-youngs/s Pages read 4904810, created 105832, written 2092526 0.00 reads/s, 0.25 creates/s, 0.46 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: 63687, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 26 Buffer pool size 65536 Free buffers 1022 Database pages 63689 Old database pages 23490 Modified db pages 2121 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1356743, not young 18435222 0.00 youngs/s, 0.00 non-youngs/s Pages read 5703272, created 105696, written 2112151 0.00 reads/s, 1.02 creates/s, 0.46 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: 63689, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 27 Buffer pool size 65528 Free buffers 1024 Database pages 63701 Old database pages 23494 Modified db pages 1507 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 3822652, not young 16572581 0.00 youngs/s, 0.00 non-youngs/s Pages read 5145873, created 105645, written 2096880 0.00 reads/s, 0.05 creates/s, 0.46 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: 63701, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 28 Buffer pool size 65536 Free buffers 1024 Database pages 63704 Old database pages 23495 Modified db pages 1798 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 3828336, not young 16060334 0.00 youngs/s, 0.00 non-youngs/s Pages read 5052373, created 105397, written 2103230 0.00 reads/s, 0.00 creates/s, 0.46 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: 63704, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 29 Buffer pool size 65528 Free buffers 1023 Database pages 63688 Old database pages 23489 Modified db pages 1947 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1283183, not young 18737210 0.00 youngs/s, 0.00 non-youngs/s Pages read 5716749, created 105688, written 2088364 0.00 reads/s, 0.11 creates/s, 0.46 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: 63688, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 30 Buffer pool size 65536 Free buffers 1024 Database pages 63712 Old database pages 23498 Modified db pages 1732 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2667288, not young 16894125 0.00 youngs/s, 0.00 non-youngs/s Pages read 5333832, created 106270, written 2076766 0.00 reads/s, 0.00 creates/s, 0.47 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: 63712, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] ---BUFFER POOL 31 Buffer pool size 65528 Free buffers 1024 Database pages 63692 Old database pages 23491 Modified db pages 1545 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1122263, not young 18538351 0.00 youngs/s, 0.00 non-youngs/s Pages read 5788346, created 105201, written 2126583 0.00 reads/s, 0.00 creates/s, 0.47 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: 63692, unzip_LRU len: 0 I/O sum[895]:cur[7], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB Process ID=24564, Main thread ID=139781983954688, state: sleeping Number of rows inserted 622506487, updated 19331456, deleted 502581, read 14782752420 620.11 inserts/s, 39.37 updates/s, 0.02 deletes/s, 13479.22 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set (0.01 sec)