*************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2017-10-03 03:40:16 0x7f3ab06d0700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 244 srv_active, 0 srv_shutdown, 41 srv_idle srv_master_thread log flush and writes: 285 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 155550 OS WAIT ARRAY INFO: signal count 155924 RW-shared spins 0, rounds 174830, OS waits 72861 RW-excl spins 0, rounds 2307390, OS waits 86901 RW-sx spins 8883, rounds 200818, OS waits 3865 Spin rounds per wait: 174830.00 RW-shared, 2307390.00 RW-excl, 22.61 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 47427391602 Purge done for trx's n:o < 47400140703 undo n:o < 0 state: running History list length 3919609 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421566895399624, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895396008, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895395104, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895400528, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895397816, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895398720, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895396912, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895394200, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895389680, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895401432, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895393296, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895385160, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895387872, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895392392, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895388776, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895391488, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895390584, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895386968, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895386064, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895384256, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895373408, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895379736, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895383352, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895380640, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895376120, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895364368, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895382448, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895381544, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895378832, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895377024, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895377928, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895375216, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895372504, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895371600, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895370696, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895369792, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895374312, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895368888, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895365272, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895367984, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895367080, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895363464, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895353520, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895366176, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895362560, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895360752, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895361656, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895358944, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895348096, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895359848, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895358040, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895357136, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895356232, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895355328, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895354424, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895352616, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895344480, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895350808, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895351712, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895342672, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895334536, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895349904, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895349000, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895347192, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895346288, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895345384, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895343576, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895341768, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895339960, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895340864, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895336344, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895339056, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895338152, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895324592, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895321880, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895337248, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895335440, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895330920, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895333632, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895332728, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895331824, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895329112, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895323688, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895330016, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895328208, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895315552, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895325496, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895327304, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895326400, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895319168, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895322784, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895320072, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895320976, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895317360, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895313744, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895316456, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895294760, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895318264, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895314648, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895312840, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895311936, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895311032, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895306512, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895308320, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895307416, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895310128, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895301992, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895309224, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895305608, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895304704, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895298376, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895289336, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895285720, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895302896, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895303800, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895299280, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895295664, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895301088, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895300184, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895291144, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895297472, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895296568, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895292048, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895293856, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895287528, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895290240, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895292952, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895288432, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895286624, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895280296, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895267640, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895284816, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895283912, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895282104, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895281200, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895269448, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895276680, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895265832, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895270352, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895283008, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895279392, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895278488, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895273968, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895277584, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895275776, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895274872, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895273064, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895271256, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895272160, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895268544, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895264024, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895264928, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895261312, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895238712, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895266736, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895260408, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895259504, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895251368, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895245040, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895239616, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895263120, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895262216, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895258600, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895257696, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895256792, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895255888, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895254984, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895254080, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895252272, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895253176, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895245944, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895250464, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895249560, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895248656, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895247752, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895246848, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895244136, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895243232, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895242328, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895241424, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895240520, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895237808, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421566895236904, 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 (read thread) I/O thread 7 state: waiting for completed aio requests (read thread) I/O thread 8 state: waiting for completed aio requests (read thread) I/O thread 9 state: waiting for completed aio requests (read thread) I/O thread 10 state: waiting for completed aio requests (write thread) I/O thread 11 state: waiting for completed aio requests (write thread) I/O thread 12 state: waiting for completed aio requests (write thread) I/O thread 13 state: waiting for completed aio requests (write thread) I/O thread 14 state: waiting for completed aio requests (write thread) I/O thread 15 state: waiting for completed aio requests (write thread) I/O thread 16 state: waiting for completed aio requests (write thread) I/O thread 17 state: waiting for completed aio requests (write thread) Pending normal aio reads: [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: [0, 0, 0, 0, 0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 0; buffer pool: 0 1392085 OS file reads, 154709 OS file writes, 57637 OS fsyncs 3716.89 reads/s, 16384 avg bytes/read, 227.49 writes/s, 181.55 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 52535, seg size 52537, 2264 merges merged operations: insert 2113, delete mark 396, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 47812069, node heap has 57 buffer(s) Hash table size 47812069, node heap has 3074 buffer(s) Hash table size 47812069, node heap has 2069 buffer(s) Hash table size 47812069, node heap has 596 buffer(s) Hash table size 47812069, node heap has 1050 buffer(s) Hash table size 47812069, node heap has 95 buffer(s) Hash table size 47812069, node heap has 2011 buffer(s) Hash table size 47812069, node heap has 101 buffer(s) 21465.53 hash searches/s, 36645.33 non-hash searches/s --- LOG --- Log sequence number 3797290293419 Log flushed up to 3797290093820 Pages flushed up to 3796944101029 Last checkpoint at 3796943995608 0 pending log flushes, 0 pending chkp writes 6373 log i/o's done, 39.56 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 198086492160 Dictionary memory allocated 2073284 Buffer pool size 11796480 Free buffers 10395464 Database pages 1391963 Old database pages 514610 Modified db pages 711767 Percent of dirty pages(LRU & free pages): 6.038 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 6812, not young 0 25.37 youngs/s, 0.00 non-youngs/s Pages read 1391769, created 194, written 132440 3702.83 reads/s, 0.25 creates/s, 134.99 writes/s Buffer pool hit rate 986 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 11.06/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 1391963, unzip_LRU len: 0 I/O sum[0]:cur[35840], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 294912 Free buffers 259550 Database pages 35138 Old database pages 12990 Modified db pages 17828 Percent of dirty pages(LRU & free pages): 6.050 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 131, not young 0 0.50 youngs/s, 0.00 non-youngs/s Pages read 35136, created 2, written 3311 91.12 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 990 / 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: 35138, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 294912 Free buffers 259826 Database pages 34860 Old database pages 12888 Modified db pages 18001 Percent of dirty pages(LRU & free pages): 6.109 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 218, not young 0 1.31 youngs/s, 0.00 non-youngs/s Pages read 34860, created 0, written 3311 99.49 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 986 / 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: 34860, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 294912 Free buffers 259055 Database pages 35622 Old database pages 13169 Modified db pages 18894 Percent of dirty pages(LRU & free pages): 6.412 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 169, not young 0 1.00 youngs/s, 0.00 non-youngs/s Pages read 35621, created 1, written 3311 99.49 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 989 / 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: 35622, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 294912 Free buffers 260465 Database pages 34205 Old database pages 12646 Modified db pages 17489 Percent of dirty pages(LRU & free pages): 5.935 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 172, not young 0 0.31 youngs/s, 0.00 non-youngs/s Pages read 34203, created 2, written 3311 93.56 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 996 / 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: 34205, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 294912 Free buffers 260317 Database pages 34373 Old database pages 12708 Modified db pages 17243 Percent of dirty pages(LRU & free pages): 5.851 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 148, not young 0 0.44 youngs/s, 0.00 non-youngs/s Pages read 34370, created 3, written 3311 94.87 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 989 / 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: 34373, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 294912 Free buffers 260071 Database pages 34609 Old database pages 12795 Modified db pages 17781 Percent of dirty pages(LRU & free pages): 6.034 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 164, not young 0 0.62 youngs/s, 0.00 non-youngs/s Pages read 34609, created 0, written 3311 94.49 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 986 / 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: 34609, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 294912 Free buffers 261686 Database pages 32996 Old database pages 12200 Modified db pages 17006 Percent of dirty pages(LRU & free pages): 5.771 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 175, not young 0 1.81 youngs/s, 0.00 non-youngs/s Pages read 32996, created 0, written 3311 93.68 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 987 / 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: 32996, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 294912 Free buffers 260555 Database pages 34133 Old database pages 12619 Modified db pages 17128 Percent of dirty pages(LRU & free pages): 5.812 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 158, not young 0 0.31 youngs/s, 0.00 non-youngs/s Pages read 34131, created 2, written 3311 95.93 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 988 / 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: 34133, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 8 Buffer pool size 294912 Free buffers 259695 Database pages 35001 Old database pages 12940 Modified db pages 18979 Percent of dirty pages(LRU & free pages): 6.440 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 198, not young 0 0.50 youngs/s, 0.00 non-youngs/s Pages read 35000, created 1, written 3311 89.06 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 987 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 4.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 35001, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 9 Buffer pool size 294912 Free buffers 259225 Database pages 35457 Old database pages 13108 Modified db pages 17883 Percent of dirty pages(LRU & free pages): 6.069 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 232, not young 0 0.12 youngs/s, 0.00 non-youngs/s Pages read 35454, created 3, written 3311 91.18 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 966 / 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: 35457, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 10 Buffer pool size 294912 Free buffers 261040 Database pages 33646 Old database pages 12440 Modified db pages 16983 Percent of dirty pages(LRU & free pages): 5.763 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 234, not young 0 0.37 youngs/s, 0.00 non-youngs/s Pages read 33645, created 1, written 3311 91.68 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 977 / 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: 33646, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 11 Buffer pool size 294912 Free buffers 259401 Database pages 35280 Old database pages 13043 Modified db pages 17305 Percent of dirty pages(LRU & free pages): 5.872 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 196, not young 0 0.69 youngs/s, 0.00 non-youngs/s Pages read 35278, created 2, written 3311 100.12 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 984 / 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: 35280, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 12 Buffer pool size 294912 Free buffers 259107 Database pages 35585 Old database pages 13155 Modified db pages 18795 Percent of dirty pages(LRU & free pages): 6.378 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 178, not young 0 0.37 youngs/s, 0.00 non-youngs/s Pages read 35585, created 0, written 3311 87.62 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 981 / 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: 35585, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 13 Buffer pool size 294912 Free buffers 259894 Database pages 34798 Old database pages 12865 Modified db pages 17712 Percent of dirty pages(LRU & free pages): 6.010 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 136, not young 0 0.31 youngs/s, 0.00 non-youngs/s Pages read 34796, created 2, written 3311 93.06 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 968 / 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: 34798, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 14 Buffer pool size 294912 Free buffers 259611 Database pages 35065 Old database pages 12963 Modified db pages 17770 Percent of dirty pages(LRU & free pages): 6.030 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 210, not young 0 0.62 youngs/s, 0.00 non-youngs/s Pages read 35064, created 1, written 3311 85.24 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 987 / 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: 35065, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 15 Buffer pool size 294912 Free buffers 260031 Database pages 34648 Old database pages 12809 Modified db pages 17879 Percent of dirty pages(LRU & free pages): 6.067 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 207, not young 0 2.56 youngs/s, 0.00 non-youngs/s Pages read 34648, created 0, written 3311 103.56 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 984 / 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: 34648, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 16 Buffer pool size 294912 Free buffers 259131 Database pages 35542 Old database pages 13139 Modified db pages 18511 Percent of dirty pages(LRU & free pages): 6.282 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 166, not young 0 0.56 youngs/s, 0.00 non-youngs/s Pages read 35542, created 0, written 3311 92.81 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 978 / 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: 35542, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 17 Buffer pool size 294912 Free buffers 258860 Database pages 35822 Old database pages 13243 Modified db pages 18049 Percent of dirty pages(LRU & free pages): 6.125 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 138, not young 0 0.62 youngs/s, 0.00 non-youngs/s Pages read 35822, created 0, written 3311 91.18 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 958 / 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: 35822, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 18 Buffer pool size 294912 Free buffers 259640 Database pages 35043 Old database pages 12955 Modified db pages 17821 Percent of dirty pages(LRU & free pages): 6.047 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 137, not young 0 0.44 youngs/s, 0.00 non-youngs/s Pages read 35041, created 2, written 3311 94.12 reads/s, 0.06 creates/s, 3.37 writes/s Buffer pool hit rate 981 / 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: 35043, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 19 Buffer pool size 294912 Free buffers 259486 Database pages 35196 Old database pages 13012 Modified db pages 17570 Percent of dirty pages(LRU & free pages): 5.962 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 182, not young 0 0.56 youngs/s, 0.00 non-youngs/s Pages read 35196, created 0, written 3311 88.06 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 968 / 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: 35196, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 20 Buffer pool size 294912 Free buffers 259885 Database pages 34797 Old database pages 12864 Modified db pages 18117 Percent of dirty pages(LRU & free pages): 6.148 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 233, not young 0 0.50 youngs/s, 0.00 non-youngs/s Pages read 34796, created 1, written 3311 85.74 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 971 / 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: 34797, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 21 Buffer pool size 294912 Free buffers 259345 Database pages 35334 Old database pages 13063 Modified db pages 17904 Percent of dirty pages(LRU & free pages): 6.076 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 163, not young 0 0.44 youngs/s, 0.00 non-youngs/s Pages read 35327, created 7, written 3311 88.06 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 974 / 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: 35334, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 22 Buffer pool size 294912 Free buffers 260370 Database pages 34322 Old database pages 12689 Modified db pages 17743 Percent of dirty pages(LRU & free pages): 6.021 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 154, not young 0 0.50 youngs/s, 0.00 non-youngs/s Pages read 34259, created 63, written 3311 84.81 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 963 / 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: 34322, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 23 Buffer pool size 294912 Free buffers 259899 Database pages 34782 Old database pages 12859 Modified db pages 18464 Percent of dirty pages(LRU & free pages): 6.266 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 212, not young 0 0.44 youngs/s, 0.00 non-youngs/s Pages read 34718, created 64, written 3311 87.74 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 984 / 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: 34782, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 24 Buffer pool size 294912 Free buffers 260511 Database pages 34186 Old database pages 12639 Modified db pages 17099 Percent of dirty pages(LRU & free pages): 5.802 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 121, not young 0 0.37 youngs/s, 0.00 non-youngs/s Pages read 34176, created 10, written 3311 86.37 reads/s, 0.06 creates/s, 3.37 writes/s Buffer pool hit rate 987 / 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: 34186, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 25 Buffer pool size 294912 Free buffers 260376 Database pages 34313 Old database pages 12686 Modified db pages 17756 Percent of dirty pages(LRU & free pages): 6.025 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 176, not young 0 0.56 youngs/s, 0.00 non-youngs/s Pages read 34313, created 0, written 3311 88.87 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 978 / 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: 34313, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 26 Buffer pool size 294912 Free buffers 260140 Database pages 34556 Old database pages 12776 Modified db pages 17269 Percent of dirty pages(LRU & free pages): 5.860 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 149, not young 0 2.00 youngs/s, 0.00 non-youngs/s Pages read 34555, created 1, written 3311 93.81 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 995 / 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: 34556, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 27 Buffer pool size 294912 Free buffers 260218 Database pages 34465 Old database pages 12742 Modified db pages 17225 Percent of dirty pages(LRU & free pages): 5.845 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 160, not young 0 0.75 youngs/s, 0.00 non-youngs/s Pages read 34465, created 0, written 3311 93.68 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 985 / 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: 34465, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 28 Buffer pool size 294912 Free buffers 259637 Database pages 35046 Old database pages 12956 Modified db pages 18841 Percent of dirty pages(LRU & free pages): 6.394 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 172, not young 0 0.56 youngs/s, 0.00 non-youngs/s Pages read 35046, created 0, written 3311 93.87 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 987 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 3.75/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 35046, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 29 Buffer pool size 294912 Free buffers 259325 Database pages 35370 Old database pages 13076 Modified db pages 17943 Percent of dirty pages(LRU & free pages): 6.089 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 177, not young 0 0.56 youngs/s, 0.00 non-youngs/s Pages read 35370, created 0, written 3311 91.37 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 976 / 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: 35370, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 30 Buffer pool size 294912 Free buffers 259330 Database pages 35345 Old database pages 13067 Modified db pages 17945 Percent of dirty pages(LRU & free pages): 6.090 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 188, not young 0 0.37 youngs/s, 0.00 non-youngs/s Pages read 35341, created 4, written 3311 103.81 reads/s, 0.06 creates/s, 3.37 writes/s Buffer pool hit rate 989 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 3.31/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 35345, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 31 Buffer pool size 294912 Free buffers 259736 Database pages 34941 Old database pages 12918 Modified db pages 17681 Percent of dirty pages(LRU & free pages): 6.000 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 161, not young 0 0.31 youngs/s, 0.00 non-youngs/s Pages read 34939, created 2, written 3311 94.49 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 983 / 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: 34941, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 32 Buffer pool size 294912 Free buffers 259044 Database pages 35646 Old database pages 13178 Modified db pages 18196 Percent of dirty pages(LRU & free pages): 6.175 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 141, not young 0 0.50 youngs/s, 0.00 non-youngs/s Pages read 35643, created 3, written 3311 97.99 reads/s, 0.06 creates/s, 3.37 writes/s Buffer pool hit rate 985 / 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: 35646, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 33 Buffer pool size 294912 Free buffers 260213 Database pages 34478 Old database pages 12747 Modified db pages 18152 Percent of dirty pages(LRU & free pages): 6.160 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 193, not young 0 0.44 youngs/s, 0.00 non-youngs/s Pages read 34468, created 10, written 3311 87.31 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 983 / 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: 34478, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 34 Buffer pool size 294912 Free buffers 260736 Database pages 33959 Old database pages 12555 Modified db pages 16686 Percent of dirty pages(LRU & free pages): 5.662 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 138, not young 0 0.31 youngs/s, 0.00 non-youngs/s Pages read 33958, created 1, written 3311 89.12 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 971 / 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: 33959, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 35 Buffer pool size 294912 Free buffers 260055 Database pages 34638 Old database pages 12806 Modified db pages 17519 Percent of dirty pages(LRU & free pages): 5.945 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 104, not young 0 0.31 youngs/s, 0.00 non-youngs/s Pages read 34638, created 0, written 3311 81.74 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 973 / 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: 34638, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 36 Buffer pool size 294912 Free buffers 260141 Database pages 34559 Old database pages 12777 Modified db pages 17032 Percent of dirty pages(LRU & free pages): 5.779 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 161, not young 0 0.62 youngs/s, 0.00 non-youngs/s Pages read 34557, created 2, written 3311 93.68 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 985 / 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: 34559, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 37 Buffer pool size 294912 Free buffers 259984 Database pages 34702 Old database pages 12829 Modified db pages 17218 Percent of dirty pages(LRU & free pages): 5.843 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 122, not young 0 0.56 youngs/s, 0.00 non-youngs/s Pages read 34701, created 1, written 3311 99.93 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 983 / 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: 34702, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 38 Buffer pool size 294912 Free buffers 260386 Database pages 34314 Old database pages 12686 Modified db pages 18404 Percent of dirty pages(LRU & free pages): 6.245 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 168, not young 0 0.44 youngs/s, 0.00 non-youngs/s Pages read 34313, created 1, written 3311 94.68 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 984 / 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: 34314, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] ---BUFFER POOL 39 Buffer pool size 294912 Free buffers 259487 Database pages 35191 Old database pages 13010 Modified db pages 17946 Percent of dirty pages(LRU & free pages): 6.090 Max dirty pages percent: 90.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 170, not young 0 0.75 youngs/s, 0.00 non-youngs/s Pages read 35189, created 2, written 3311 95.43 reads/s, 0.00 creates/s, 3.37 writes/s Buffer pool hit rate 983 / 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: 35191, unzip_LRU len: 0 I/O sum[0]:cur[896], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 0 read views open inside InnoDB Process ID=12951, Main thread ID=139890193954560, state: sleeping Number of rows inserted 4729, updated 3040, deleted 289, read 1841985 24.94 inserts/s, 27.44 updates/s, 0.81 deletes/s, 3340.42 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 2 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================