*************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2019-12-04 14:22:19 0x7f48cd7fa700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 58 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 853 srv_active, 0 srv_shutdown, 238 srv_idle srv_master_thread log flush and writes: 1091 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 21200 OS WAIT ARRAY INFO: signal count 264095 RW-shared spins 0, rounds 2066012, OS waits 7897 RW-excl spins 0, rounds 786903, OS waits 4435 RW-sx spins 2698, rounds 16815, OS waits 160 Spin rounds per wait: 2066012.00 RW-shared, 786903.00 RW-excl, 6.23 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 52399428 Purge done for trx's n:o < 52393016 undo n:o < 0 state: running but idle History list length 2194 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421479629352368, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629322856, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629360800, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629381880, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629348152, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629343936, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629335504, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629331288, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629356584, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629314424, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629297560, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629339720, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629310208, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629305992, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629263832, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629276480, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629251184, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629272264, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629242752, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629301776, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629327072, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629318640, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629289128, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629280696, ACTIVE 148 sec mysql tables in use 20, locked 0 0 lock struct(s), heap size 1136, 0 row lock(s) MySQL thread id 4201, OS thread handle 140004593047296, query id 894674 localhost web_magento Sending data SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=5 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 LEFT JOIN `catalog_product_relation` AS `child_link_color_group` ON e.entity_id = child_link_color_group.parent_id LEFT JOIN `cataloginventory_stock_status` AS `child_ Trx read view will not see trx with id >= 52393009, sees < 52393008 ---TRANSACTION 421479629293344, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629268048, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629284912, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629259616, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629255400, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629238536, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629246968, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421479629234320, 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 537333 OS file reads, 451971 OS file writes, 118618 OS fsyncs 0.02 reads/s, 16384 avg bytes/read, 20.45 writes/s, 9.40 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 432, seg size 434, 4 merges merged operations: insert 4, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 12750011, node heap has 1897 buffer(s) Hash table size 12750011, node heap has 651 buffer(s) Hash table size 12750011, node heap has 1131 buffer(s) Hash table size 12750011, node heap has 2875 buffer(s) Hash table size 12750011, node heap has 333 buffer(s) Hash table size 12750011, node heap has 843 buffer(s) Hash table size 12750011, node heap has 1439 buffer(s) Hash table size 12750011, node heap has 1971 buffer(s) 21041.59 hash searches/s, 8557.68 non-hash searches/s --- LOG --- Log sequence number 286767750214 Log flushed up to 286767750214 Pages flushed up to 286767750214 Last checkpoint at 286767750205 0 pending log flushes, 0 pending chkp writes 29825 log i/o's done, 1.95 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 52755955712 Dictionary memory allocated 2276640 Buffer pool size 3145728 Free buffers 2525394 Database pages 609194 Old database pages 224221 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 5, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 534321, created 74873, written 393164 0.02 reads/s, 0.00 creates/s, 15.05 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: 609194, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 98304 Free buffers 79538 Database pages 18419 Old database pages 6779 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16214, created 2205, written 14477 0.00 reads/s, 0.00 creates/s, 0.50 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: 18419, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 98304 Free buffers 78260 Database pages 19693 Old database pages 7249 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 17120, created 2573, written 11360 0.00 reads/s, 0.00 creates/s, 0.36 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: 19693, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 98304 Free buffers 78508 Database pages 19447 Old database pages 7158 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 17264, created 2183, written 12728 0.00 reads/s, 0.00 creates/s, 0.34 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: 19447, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 98304 Free buffers 78928 Database pages 19022 Old database pages 7001 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16911, created 2111, written 15606 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: 19022, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 98304 Free buffers 79115 Database pages 18848 Old database pages 6937 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16442, created 2406, written 17241 0.00 reads/s, 0.00 creates/s, 1.12 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: 18848, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 98304 Free buffers 77997 Database pages 19968 Old database pages 7351 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 17116, created 2852, written 14422 0.00 reads/s, 0.00 creates/s, 0.07 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: 19968, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 98304 Free buffers 78221 Database pages 19735 Old database pages 7264 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 17115, created 2620, written 16265 0.00 reads/s, 0.00 creates/s, 0.22 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: 19735, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 98304 Free buffers 78813 Database pages 19146 Old database pages 7047 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16639, created 2507, written 16493 0.00 reads/s, 0.00 creates/s, 0.26 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: 19146, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 8 Buffer pool size 98304 Free buffers 79604 Database pages 18364 Old database pages 6758 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 15830, created 2534, written 16515 0.00 reads/s, 0.00 creates/s, 0.07 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: 18364, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 9 Buffer pool size 98304 Free buffers 77942 Database pages 20009 Old database pages 7366 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 17115, created 2894, written 17243 0.00 reads/s, 0.00 creates/s, 0.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: 20009, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 10 Buffer pool size 98304 Free buffers 78088 Database pages 19883 Old database pages 7319 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 17268, created 2615, written 15679 0.00 reads/s, 0.00 creates/s, 0.02 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: 19883, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 11 Buffer pool size 98304 Free buffers 78892 Database pages 19049 Old database pages 7011 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16422, created 2627, written 14602 0.00 reads/s, 0.00 creates/s, 0.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: 19049, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 12 Buffer pool size 98304 Free buffers 79310 Database pages 18650 Old database pages 6864 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16225, created 2425, written 15571 0.00 reads/s, 0.00 creates/s, 0.03 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: 18650, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 13 Buffer pool size 98304 Free buffers 78285 Database pages 19665 Old database pages 7239 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16916, created 2749, written 13457 0.00 reads/s, 0.00 creates/s, 0.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: 19665, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 14 Buffer pool size 98304 Free buffers 78311 Database pages 19651 Old database pages 7233 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 17166, created 2485, written 13857 0.00 reads/s, 0.00 creates/s, 0.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: 19651, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 15 Buffer pool size 98304 Free buffers 78990 Database pages 18962 Old database pages 6979 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16573, created 2389, written 13117 0.00 reads/s, 0.00 creates/s, 0.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: 18962, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 16 Buffer pool size 98304 Free buffers 79603 Database pages 18352 Old database pages 6754 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16052, created 2300, written 13416 0.00 reads/s, 0.00 creates/s, 0.07 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: 18352, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 17 Buffer pool size 98304 Free buffers 78468 Database pages 19483 Old database pages 7171 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16909, created 2574, written 12328 0.00 reads/s, 0.00 creates/s, 0.86 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: 19483, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 18 Buffer pool size 98304 Free buffers 78926 Database pages 19025 Old database pages 7002 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16877, created 2148, written 11493 0.00 reads/s, 0.00 creates/s, 1.07 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: 19025, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 19 Buffer pool size 98304 Free buffers 79231 Database pages 18721 Old database pages 6890 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16533, created 2188, written 11494 0.00 reads/s, 0.00 creates/s, 1.24 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: 18721, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 20 Buffer pool size 98304 Free buffers 79565 Database pages 18398 Old database pages 6772 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16185, created 2213, written 10384 0.02 reads/s, 0.00 creates/s, 1.28 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: 18398, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 21 Buffer pool size 98304 Free buffers 78789 Database pages 19162 Old database pages 7053 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16759, created 2403, written 10284 0.00 reads/s, 0.00 creates/s, 1.02 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: 19162, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 22 Buffer pool size 98304 Free buffers 78975 Database pages 18983 Old database pages 6987 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16878, created 2105, written 9951 0.00 reads/s, 0.00 creates/s, 1.28 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: 18983, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 23 Buffer pool size 98304 Free buffers 79295 Database pages 18663 Old database pages 6869 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16694, created 1969, written 7940 0.00 reads/s, 0.00 creates/s, 1.02 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: 18663, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 24 Buffer pool size 98304 Free buffers 79683 Database pages 18289 Old database pages 6731 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16321, created 1968, written 9019 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: 18289, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 25 Buffer pool size 98304 Free buffers 78528 Database pages 19419 Old database pages 7148 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 17024, created 2395, written 9980 0.00 reads/s, 0.00 creates/s, 0.98 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: 19419, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 26 Buffer pool size 98304 Free buffers 78998 Database pages 18952 Old database pages 6975 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16900, created 2052, written 7790 0.00 reads/s, 0.00 creates/s, 0.02 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: 18952, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 27 Buffer pool size 98304 Free buffers 79450 Database pages 18486 Old database pages 6803 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16467, created 2019, written 6389 0.00 reads/s, 0.00 creates/s, 0.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: 18486, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 28 Buffer pool size 98304 Free buffers 80025 Database pages 17927 Old database pages 6597 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 15967, created 1960, written 9338 0.00 reads/s, 0.00 creates/s, 0.83 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: 17927, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 29 Buffer pool size 98304 Free buffers 79012 Database pages 18957 Old database pages 6977 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16690, created 2267, written 6947 0.00 reads/s, 0.00 creates/s, 0.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: 18957, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 30 Buffer pool size 98304 Free buffers 78906 Database pages 19042 Old database pages 7009 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 17035, created 2007, written 7835 0.00 reads/s, 0.00 creates/s, 0.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: 19042, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 31 Buffer pool size 98304 Free buffers 79138 Database pages 18824 Old database pages 6928 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16694, created 2130, written 9943 0.00 reads/s, 0.00 creates/s, 0.24 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: 18824, unzip_LRU len: 0 I/O sum[0]: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=20742, Main thread ID=139950944954112, state: sleeping Number of rows inserted 14042138, updated 18953, deleted 834091, read 996685465 0.14 inserts/s, 1.00 updates/s, 0.45 deletes/s, 522228.81 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 ============================