| InnoDB | | ===================================== 2018-08-29 05:19:31 0x7f90bc185700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 51 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 542 srv_active, 0 srv_shutdown, 107 srv_idle srv_master_thread log flush and writes: 649 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 5400 OS WAIT ARRAY INFO: signal count 4367 RW-shared spins 0, rounds 230, OS waits 116 RW-excl spins 0, rounds 964, OS waits 34 RW-sx spins 0, rounds 0, OS waits 0 Spin rounds per wait: 230.00 RW-shared, 964.00 RW-excl, 0.00 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 1814942 Purge done for trx's n:o < 0 undo n:o < 0 state: running but idle History list length 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421737339267832, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 1814852, ACTIVE 1 sec 0 lock struct(s), heap size 1136, 0 row lock(s) MySQL thread id 478, OS thread handle 140259607934720, query id 1025430 localhost root Opening tables show table status like 'tbl\_rest\_package' Trx read view will not see trx with id >= 1814851, sees < 1814851 -------- 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 366066 OS file reads, 534 OS file writes, 449 OS fsyncs 1 pending preads, 0 pending pwrites 499.34 reads/s, 16384 avg bytes/read, 0.98 writes/s, 0.98 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 553193, node heap has 16 buffer(s) Hash table size 553193, node heap has 6 buffer(s) Hash table size 553193, node heap has 245 buffer(s) Hash table size 553193, node heap has 189 buffer(s) Hash table size 553193, node heap has 141 buffer(s) Hash table size 553193, node heap has 102 buffer(s) Hash table size 553193, node heap has 101 buffer(s) Hash table size 553193, node heap has 50 buffer(s) 1055.88 hash searches/s, 438.29 non-hash searches/s --- LOG --- Log sequence number 5309424955 Log flushed up to 5309424955 Pages flushed up to 5309421323 Last checkpoint at 5309421314 0 pending log flushes, 0 pending chkp writes 444 log i/o's done, 0.98 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 2198863872 Dictionary memory allocated 108995398 Buffer pool size 131056 Free buffers 7811 Database pages 122395 Old database pages 45250 Modified db pages 4 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 827, not young 3835407 1.22 youngs/s, 5345.76 non-youngs/s Pages read 306324, created 35, written 79 355.56 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 980 / 1000, young-making rate 0 / 1000 not 311 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 122395, unzip_LRU len: 0 I/O sum[142784]:cur[2288], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 16382 Free buffers 987 Database pages 15288 Old database pages 5645 Modified db pages 1 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 128, not young 469672 0.10 youngs/s, 741.91 non-youngs/s Pages read 38186, created 0, written 6 43.92 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 947 / 1000, young-making rate 0 / 1000 not 896 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 15288, unzip_LRU len: 0 I/O sum[17848]:cur[286], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 16382 Free buffers 954 Database pages 15315 Old database pages 5673 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 105, not young 438485 0.06 youngs/s, 839.00 non-youngs/s Pages read 37604, created 0, written 0 46.18 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 961 / 1000, young-making rate 0 / 1000 not 710 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 15315, unzip_LRU len: 0 I/O sum[17848]:cur[286], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 16382 Free buffers 965 Database pages 15312 Old database pages 5669 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 130, not young 543682 0.16 youngs/s, 727.81 non-youngs/s Pages read 39510, created 0, written 0 43.98 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 946 / 1000, young-making rate 0 / 1000 not 899 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 15312, unzip_LRU len: 0 I/O sum[17848]:cur[286], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 16382 Free buffers 981 Database pages 15300 Old database pages 5653 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 87, not young 445793 0.73 youngs/s, 509.79 non-youngs/s Pages read 37987, created 0, written 0 46.53 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 948 / 1000, young-making rate 0 / 1000 not 579 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 15300, unzip_LRU len: 0 I/O sum[17848]:cur[286], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 16382 Free buffers 984 Database pages 15294 Old database pages 5650 Modified db pages 3 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 59, not young 541009 0.02 youngs/s, 336.25 non-youngs/s Pages read 39152, created 35, written 73 42.55 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 996 / 1000, young-making rate 0 / 1000 not 32 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 15294, unzip_LRU len: 0 I/O sum[17848]:cur[286], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 16382 Free buffers 965 Database pages 15312 Old database pages 5670 Modified db pages 0 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 62, not young 465585 0.02 youngs/s, 513.75 non-youngs/s Pages read 37948, created 0, written 0 43.96 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 924 / 1000, young-making rate 0 / 1000 not 894 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 15312, unzip_LRU len: 0 I/O sum[17848]:cur[286], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 16382 Free buffers 986 Database pages 15291 Old database pages 5648 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 123, not young 460062 0.04 youngs/s, 674.28 non-youngs/s Pages read 37608, created 0, written 0 43.47 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 943 / 1000, young-making rate 0 / 1000 not 899 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 15291, unzip_LRU len: 0 I/O sum[17848]:cur[286], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 16382 Free buffers 989 Database pages 15283 Old database pages 5642 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 133, not young 471119 0.10 youngs/s, 1002.96 non-youngs/s Pages read 38329, created 0, written 0 44.98 reads/s, 0.00 creates/s, 0.00 writes/s Buffer pool hit rate 973 / 1000, young-making rate 0 / 1000 not 605 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 15283, unzip_LRU len: 0 I/O sum[17848]:cur[286], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Process ID=5610, Main thread ID=140259499407104, state: sleeping Number of rows inserted 933478, updated 0, deleted 0, read 19020127 2259.96 inserts/s, 0.00 updates/s, 0.00 deletes/s, 8377.42 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================