*************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2019-12-05 13:47:24 0x7f11c42af700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 49 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 429 srv_active, 0 srv_shutdown, 139 srv_idle srv_master_thread log flush and writes: 568 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 7953 OS WAIT ARRAY INFO: signal count 56768 RW-shared spins 0, rounds 119472, OS waits 988 RW-excl spins 0, rounds 265584, OS waits 1734 RW-sx spins 1413, rounds 8043, OS waits 67 Spin rounds per wait: 119472.00 RW-shared, 265584.00 RW-excl, 5.69 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 54222052 Purge done for trx's n:o < 54214993 undo n:o < 0 state: running but idle History list length 2438 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421189460781744, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460764880, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460756448, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460760664, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460752232, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460777528, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460743800, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460769096, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460773312, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460739584, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460731152, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460714288, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460748016, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460722720, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460726936, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460735368, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460718504, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460697424, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460710072, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460693208, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460680560, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460705856, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460676344, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460672128, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460701640, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460688992, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460684776, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460655264, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460596240, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460608888, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460667912, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460659480, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460663696, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460651048, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460629968, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460625752, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460621536, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460646832, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460642616, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460638400, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460613104, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460617320, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460634184, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460562512, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460604672, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460570944, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460575160, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460600456, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460587808, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460583592, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460554080, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460541432, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460592024, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460579376, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460558296, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460566728, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460549864, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460545648, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460537216, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460499272, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460473976, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460524568, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460516136, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460520352, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460490840, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460427600, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460482408, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460507704, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460495056, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460503488, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460533000, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460528784, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460511920, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460478192, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460486624, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460469760, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460448680, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460461328, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460457112, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460465544, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460444464, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460440248, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460452896, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460436032, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460431816, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460410736, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460423384, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460419168, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460414952, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460313768, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460406520, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460402304, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460398088, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460393872, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460389656, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460385440, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460364360, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460355928, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460351712, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460347496, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460343280, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460381224, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460377008, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460372792, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460334848, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460368576, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460360144, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460339064, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460330632, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460317984, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460309552, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460305336, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460288472, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460284256, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460280040, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460275824, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460296904, ACTIVE 286 sec starting index read mysql tables in use 20, locked 0 0 lock struct(s), heap size 1136, 0 row lock(s) MySQL thread id 2683, OS thread handle 139660594046720, query id 396069 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=3 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 >= 54214984, sees < 54214982 ---TRANSACTION 421189460322200, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460326416, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460301120, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460292688, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460271608, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460267392, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460263176, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421189460258960, 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 290641 OS file reads, 213039 OS file writes, 67111 OS fsyncs 0.37 reads/s, 16384 avg bytes/read, 9.65 writes/s, 7.29 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 432, seg size 434, 18 merges merged operations: insert 18, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 12750011, node heap has 1723 buffer(s) Hash table size 12750011, node heap has 528 buffer(s) Hash table size 12750011, node heap has 496 buffer(s) Hash table size 12750011, node heap has 2997 buffer(s) Hash table size 12750011, node heap has 273 buffer(s) Hash table size 12750011, node heap has 999 buffer(s) Hash table size 12750011, node heap has 1125 buffer(s) Hash table size 12750011, node heap has 1765 buffer(s) 24195.18 hash searches/s, 4173.20 non-hash searches/s --- LOG --- Log sequence number 295481734747 Log flushed up to 295481734747 Pages flushed up to 295481734190 Last checkpoint at 295481734190 0 pending log flushes, 0 pending chkp writes 15751 log i/o's done, 2.73 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 52755955712 Dictionary memory allocated 2254608 Buffer pool size 3145728 Free buffers 2813343 Database pages 322479 Old database pages 118991 Modified db pages 4 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 3, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 287667, created 34812, written 181010 0.37 reads/s, 0.00 creates/s, 4.65 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: 322479, 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 88770 Database pages 9239 Old database pages 3391 Modified db pages 1 Percent of dirty pages(LRU & free pages): 0.001 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 7969, created 1270, written 10698 0.00 reads/s, 0.00 creates/s, 0.18 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: 9239, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 98304 Free buffers 86957 Database pages 11028 Old database pages 4052 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 9324, created 1704, written 10240 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: 11028, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 98304 Free buffers 88702 Database pages 9299 Old database pages 3415 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 7964, created 1335, written 9577 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: 9299, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 98304 Free buffers 86011 Database pages 11995 Old database pages 4409 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 10848, created 1147, written 10282 0.02 reads/s, 0.00 creates/s, 1.04 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: 11995, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 98304 Free buffers 88817 Database pages 9173 Old database pages 3377 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 8027, created 1146, written 8769 0.04 reads/s, 0.00 creates/s, 0.45 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: 9173, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 98304 Free buffers 87431 Database pages 10551 Old database pages 3891 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 9095, created 1456, written 8563 0.04 reads/s, 0.00 creates/s, 0.04 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: 10551, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 98304 Free buffers 89081 Database pages 8903 Old database pages 3277 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 7799, created 1104, written 7071 0.04 reads/s, 0.00 creates/s, 0.02 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: 8903, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 98304 Free buffers 86236 Database pages 11752 Old database pages 4325 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 10631, created 1121, written 6928 0.04 reads/s, 0.00 creates/s, 0.06 writes/s Buffer pool hit rate 997 / 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: 11752, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 8 Buffer pool size 98304 Free buffers 88773 Database pages 9223 Old database pages 3400 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 8181, created 1042, written 6882 0.04 reads/s, 0.00 creates/s, 0.10 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: 9223, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 9 Buffer pool size 98304 Free buffers 87575 Database pages 10412 Old database pages 3828 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 9108, created 1304, written 6370 0.04 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 10412, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 10 Buffer pool size 98304 Free buffers 89378 Database pages 8611 Old database pages 3165 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 7599, created 1012, written 5941 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: 8611, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 11 Buffer pool size 98304 Free buffers 86242 Database pages 11745 Old database pages 4319 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 10709, created 1036, written 5800 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: 11745, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 12 Buffer pool size 98304 Free buffers 89115 Database pages 8892 Old database pages 3278 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 7916, created 976, written 5946 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: 8892, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 13 Buffer pool size 98304 Free buffers 87310 Database pages 10677 Old database pages 3961 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 9351, created 1326, written 5571 0.02 reads/s, 0.00 creates/s, 0.04 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: 10677, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 14 Buffer pool size 98304 Free buffers 89508 Database pages 8481 Old database pages 3150 Modified db pages 1 Percent of dirty pages(LRU & free pages): 0.001 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 7536, created 945, written 5435 0.00 reads/s, 0.00 creates/s, 0.67 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: 8481, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 15 Buffer pool size 98304 Free buffers 86722 Database pages 11278 Old database pages 4183 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 10366, created 912, written 3794 0.04 reads/s, 0.00 creates/s, 0.06 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: 11278, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 16 Buffer pool size 98304 Free buffers 89238 Database pages 8750 Old database pages 3249 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 7817, created 933, written 3782 0.00 reads/s, 0.00 creates/s, 0.04 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: 8750, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 17 Buffer pool size 98304 Free buffers 87289 Database pages 10706 Old database pages 3972 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 9429, created 1277, written 3565 0.02 reads/s, 0.00 creates/s, 0.06 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: 10706, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 18 Buffer pool size 98304 Free buffers 89188 Database pages 8805 Old database pages 3270 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 7896, created 909, written 2990 0.00 reads/s, 0.00 creates/s, 0.06 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: 8805, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 19 Buffer pool size 98304 Free buffers 86363 Database pages 11620 Old database pages 4309 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 10696, created 924, written 3323 0.00 reads/s, 0.00 creates/s, 0.16 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: 11620, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 20 Buffer pool size 98304 Free buffers 88837 Database pages 9150 Old database pages 3397 Modified db pages 1 Percent of dirty pages(LRU & free pages): 0.001 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 8248, created 902, written 3138 0.02 reads/s, 0.00 creates/s, 0.39 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: 9150, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 21 Buffer pool size 98304 Free buffers 87001 Database pages 10984 Old database pages 4074 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 9698, created 1286, written 4504 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: 10984, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 22 Buffer pool size 98304 Free buffers 88976 Database pages 9019 Old database pages 3349 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 8020, created 999, written 3995 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: 9019, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 23 Buffer pool size 98304 Free buffers 86194 Database pages 11796 Old database pages 4374 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 10893, created 903, written 2476 0.00 reads/s, 0.00 creates/s, 0.06 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: 11796, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 24 Buffer pool size 98304 Free buffers 89214 Database pages 8782 Old database pages 3261 Modified db pages 1 Percent of dirty pages(LRU & free pages): 0.001 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 7946, created 836, written 2457 0.00 reads/s, 0.00 creates/s, 0.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: 8782, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 25 Buffer pool size 98304 Free buffers 87174 Database pages 10830 Old database pages 3977 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 9685, created 1145, written 2966 0.00 reads/s, 0.00 creates/s, 0.08 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: 10830, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 26 Buffer pool size 98304 Free buffers 89324 Database pages 8671 Old database pages 3182 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 7919, created 752, written 2399 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: 8671, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 27 Buffer pool size 98304 Free buffers 86516 Database pages 11487 Old database pages 4220 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 10680, created 807, written 2834 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: 11487, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 28 Buffer pool size 98304 Free buffers 89066 Database pages 8948 Old database pages 3283 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 8110, created 838, written 5160 0.00 reads/s, 0.00 creates/s, 0.06 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: 8948, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 29 Buffer pool size 98304 Free buffers 87297 Database pages 10712 Old database pages 3942 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 9437, created 1275, written 5641 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: 10712, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 30 Buffer pool size 98304 Free buffers 89153 Database pages 8850 Old database pages 3261 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 7785, created 1065, written 6322 0.00 reads/s, 0.00 creates/s, 0.41 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: 8850, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 31 Buffer pool size 98304 Free buffers 85885 Database pages 12110 Old database pages 4450 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 10985, created 1125, written 7591 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: 12110, 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=35468, Main thread ID=139660606846720, state: sleeping Number of rows inserted 6002478, updated 10287, deleted 55188, read 211238976 0.22 inserts/s, 1.43 updates/s, 0.00 deletes/s, 73518.21 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set (0.001 sec)