Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC -------- 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) Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 170671 OS file reads, 320961 OS file writes, 1656 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 15048, seg size 15050, 5 merges merged operations: insert 245, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 259075169386 Log flushed up to 259075169386 Pages flushed up to 258587889914 Last checkpoint at 258587889914 Max checkpoint age 651231499 Checkpoint age target 630880515 Modified age 487279472 Checkpoint age 487279472 0 pending log writes, 0 pending chkp writes 124409 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 2252341248; in additional pool allocated 0 Total memory allocated by read views 13384 Internal hash tables (constant factor + variable factor) Adaptive hash index 35406016 (35401816 + 4200) Page hash 1107208 (buffer pool 0 only) Dictionary cache 9476565 (8851984 + 624581) File system 88048 (82672 + 5376) Lock system 23344392 (5313416 + 18030976) Recovery system 0 (0 + 0) Dictionary memory allocated 624581 Buffer pool size 131070 Buffer pool size, bytes 2147450880 Free buffers 31 Database pages 129982 Old database pages 48019 Modified db pages 37397 Percent of dirty pages(LRU & free pages): 28.764 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 697, not young 1704534 0.00 youngs/s, 0.00 non-youngs/s Pages read 170654, created 194043, written 196563 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 129982, 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 65535 Buffer pool size, bytes 1073725440 Free buffers 0 Database pages 65006 Old database pages 24015 Modified db pages 20018 Percent of dirty pages(LRU & free pages): 30.794 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 520, not young 854712 0.00 youngs/s, 0.00 non-youngs/s Pages read 86108, created 97514, written 101850 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 65006, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 65535 Buffer pool size, bytes 1073725440 Free buffers 31 Database pages 64976 Old database pages 24004 Modified db pages 17379 Percent of dirty pages(LRU & free pages): 26.734 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 177, not young 849822 0.00 youngs/s, 0.00 non-youngs/s Pages read 84546, created 96529, written 94713 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 64976, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 6 queries inside InnoDB, 674 queries in queue 4 read views open inside InnoDB 3 RW transactions active inside InnoDB 0 RO transactions active inside InnoDB 3 out of 1000 descriptors used ---OLDEST VIEW--- Normal read view Read view low limit trx n:o 971320415 Read view up limit trx id 970985893 Read view low limit trx id 971320415 Read view individually stored trx ids: Read view trx id 970985893 Read view trx id 971287638 ----------------- 3 tablespace extents now reserved for B-tree split operations Main thread process no. 57182, id 140494583604992, state: sleeping Number of rows inserted 2640818, updated 38895, deleted 0, read 4283845 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 1 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC -------- 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) Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 170671 OS file reads, 320961 OS file writes, 1656 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 15048, seg size 15050, 5 merges merged operations: insert 245, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 259075169386 Log flushed up to 259075169386 Pages flushed up to 258587889914 Last checkpoint at 258587889914 Max checkpoint age 651231499 Checkpoint age target 630880515 Modified age 487279472 Checkpoint age 487279472 0 pending log writes, 0 pending chkp writes 124409 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 2252341248; in additional pool allocated 0 Total memory allocated by read views 13384 Internal hash tables (constant factor + variable factor) Adaptive hash index 35406016 (35401816 + 4200) Page hash 1107208 (buffer pool 0 only) Dictionary cache 9476565 (8851984 + 624581) File system 88048 (82672 + 5376) Lock system 23364192 (5313416 + 18050776) Recovery system 0 (0 + 0) Dictionary memory allocated 624581 Buffer pool size 131070 Buffer pool size, bytes 2147450880 Free buffers 31 Database pages 129982 Old database pages 48019 Modified db pages 37397 Percent of dirty pages(LRU & free pages): 28.764 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 697, not young 1704534 0.00 youngs/s, 0.00 non-youngs/s Pages read 170654, created 194043, written 196563 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 129982, 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 65535 Buffer pool size, bytes 1073725440 Free buffers 0 Database pages 65006 Old database pages 24015 Modified db pages 20018 Percent of dirty pages(LRU & free pages): 30.794 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 520, not young 854712 0.00 youngs/s, 0.00 non-youngs/s Pages read 86108, created 97514, written 101850 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 65006, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 65535 Buffer pool size, bytes 1073725440 Free buffers 31 Database pages 64976 Old database pages 24004 Modified db pages 17379 Percent of dirty pages(LRU & free pages): 26.734 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 177, not young 849822 0.00 youngs/s, 0.00 non-youngs/s Pages read 84546, created 96529, written 94713 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 64976, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 6 queries inside InnoDB, 703 queries in queue 4 read views open inside InnoDB 3 RW transactions active inside InnoDB 0 RO transactions active inside InnoDB 3 out of 1000 descriptors used ---OLDEST VIEW--- Normal read view Read view low limit trx n:o 971320415 Read view up limit trx id 970985893 Read view low limit trx id 971320415 Read view individually stored trx ids: Read view trx id 970985893 Read view trx id 971287638 ----------------- 3 tablespace extents now reserved for B-tree split operations Main thread process no. 57182, id 140494583604992, state: sleeping Number of rows inserted 2640818, updated 38895, deleted 0, read 4283845 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 1 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC -------- 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) Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 170671 OS file reads, 320961 OS file writes, 1656 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 15048, seg size 15050, 5 merges merged operations: insert 245, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 259075169386 Log flushed up to 259075169386 Pages flushed up to 258587889914 Last checkpoint at 258587889914 Max checkpoint age 651231499 Checkpoint age target 630880515 Modified age 487279472 Checkpoint age 487279472 0 pending log writes, 0 pending chkp writes 124409 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 2252341248; in additional pool allocated 0 Total memory allocated by read views 13384 Internal hash tables (constant factor + variable factor) Adaptive hash index 35406016 (35401816 + 4200) Page hash 1107208 (buffer pool 0 only) Dictionary cache 9476565 (8851984 + 624581) File system 88048 (82672 + 5376) Lock system 23364192 (5313416 + 18050776) Recovery system 0 (0 + 0) Dictionary memory allocated 624581 Buffer pool size 131070 Buffer pool size, bytes 2147450880 Free buffers 31 Database pages 129982 Old database pages 48019 Modified db pages 37397 Percent of dirty pages(LRU & free pages): 28.764 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 697, not young 1704534 0.00 youngs/s, 0.00 non-youngs/s Pages read 170654, created 194043, written 196563 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 129982, 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 65535 Buffer pool size, bytes 1073725440 Free buffers 0 Database pages 65006 Old database pages 24015 Modified db pages 20018 Percent of dirty pages(LRU & free pages): 30.794 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 520, not young 854712 0.00 youngs/s, 0.00 non-youngs/s Pages read 86108, created 97514, written 101850 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 65006, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 65535 Buffer pool size, bytes 1073725440 Free buffers 31 Database pages 64976 Old database pages 24004 Modified db pages 17379 Percent of dirty pages(LRU & free pages): 26.734 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 177, not young 849822 0.00 youngs/s, 0.00 non-youngs/s Pages read 84546, created 96529, written 94713 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 64976, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 6 queries inside InnoDB, 703 queries in queue 4 read views open inside InnoDB 3 RW transactions active inside InnoDB 0 RO transactions active inside InnoDB 3 out of 1000 descriptors used ---OLDEST VIEW--- Normal read view Read view low limit trx n:o 971320415 Read view up limit trx id 970985893 Read view low limit trx id 971320415 Read view individually stored trx ids: Read view trx id 970985893 Read view trx id 971287638 ----------------- 3 tablespace extents now reserved for B-tree split operations Main thread process no. 57182, id 140494583604992, state: sleeping Number of rows inserted 2640818, updated 38895, deleted 0, read 4283845 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 1 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC -------- 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) Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 170671 OS file reads, 320961 OS file writes, 1656 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 15048, seg size 15050, 5 merges merged operations: insert 245, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 259075169386 Log flushed up to 259075169386 Pages flushed up to 258587889914 Last checkpoint at 258587889914 Max checkpoint age 651231499 Checkpoint age target 630880515 Modified age 487279472 Checkpoint age 487279472 0 pending log writes, 0 pending chkp writes 124409 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 2252341248; in additional pool allocated 0 Total memory allocated by read views 13384 Internal hash tables (constant factor + variable factor) Adaptive hash index 35406016 (35401816 + 4200) Page hash 1107208 (buffer pool 0 only) Dictionary cache 9476565 (8851984 + 624581) File system 88048 (82672 + 5376) Lock system 23364192 (5313416 + 18050776) Recovery system 0 (0 + 0) Dictionary memory allocated 624581 Buffer pool size 131070 Buffer pool size, bytes 2147450880 Free buffers 31 Database pages 129982 Old database pages 48019 Modified db pages 37397 Percent of dirty pages(LRU & free pages): 28.764 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 697, not young 1704534 0.00 youngs/s, 0.00 non-youngs/s Pages read 170654, created 194043, written 196563 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 129982, 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 65535 Buffer pool size, bytes 1073725440 Free buffers 0 Database pages 65006 Old database pages 24015 Modified db pages 20018 Percent of dirty pages(LRU & free pages): 30.794 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 520, not young 854712 0.00 youngs/s, 0.00 non-youngs/s Pages read 86108, created 97514, written 101850 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 65006, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 65535 Buffer pool size, bytes 1073725440 Free buffers 31 Database pages 64976 Old database pages 24004 Modified db pages 17379 Percent of dirty pages(LRU & free pages): 26.734 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 177, not young 849822 0.00 youngs/s, 0.00 non-youngs/s Pages read 84546, created 96529, written 94713 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 64976, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 6 queries inside InnoDB, 703 queries in queue 4 read views open inside InnoDB 3 RW transactions active inside InnoDB 0 RO transactions active inside InnoDB 3 out of 1000 descriptors used ---OLDEST VIEW--- Normal read view Read view low limit trx n:o 971320415 Read view up limit trx id 970985893 Read view low limit trx id 971320415 Read view individually stored trx ids: Read view trx id 970985893 Read view trx id 971287638 ----------------- 3 tablespace extents now reserved for B-tree split operations Main thread process no. 57182, id 140494583604992, state: sleeping Number of rows inserted 2640818, updated 38895, deleted 0, read 4283845 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 1 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ................................................ Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC -------- 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) Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 170671 OS file reads, 320961 OS file writes, 1656 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 15048, seg size 15050, 5 merges merged operations: insert 245, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 259075169386 Log flushed up to 259075169386 Pages flushed up to 258587889914 Last checkpoint at 258587889914 Max checkpoint age 651231499 Checkpoint age target 630880515 Modified age 487279472 Checkpoint age 487279472 0 pending log writes, 0 pending chkp writes 124409 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 2252341248; in additional pool allocated 0 Total memory allocated by read views 13384 Internal hash tables (constant factor + variable factor) Adaptive hash index 35406016 (35401816 + 4200) Page hash 1107208 (buffer pool 0 only) Dictionary cache 9476565 (8851984 + 624581) File system 88048 (82672 + 5376) Lock system 23364192 (5313416 + 18050776) Recovery system 0 (0 + 0) Dictionary memory allocated 624581 Buffer pool size 131070 Buffer pool size, bytes 2147450880 Free buffers 31 Database pages 129982 Old database pages 48019 Modified db pages 37397 Percent of dirty pages(LRU & free pages): 28.764 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 697, not young 1704534 0.00 youngs/s, 0.00 non-youngs/s Pages read 170654, created 194043, written 196563 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 129982, 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 65535 Buffer pool size, bytes 1073725440 Free buffers 0 Database pages 65006 Old database pages 24015 Modified db pages 20018 Percent of dirty pages(LRU & free pages): 30.794 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 520, not young 854712 0.00 youngs/s, 0.00 non-youngs/s Pages read 86108, created 97514, written 101850 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 65006, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 65535 Buffer pool size, bytes 1073725440 Free buffers 31 Database pages 64976 Old database pages 24004 Modified db pages 17379 Percent of dirty pages(LRU & free pages): 26.734 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 177, not young 849822 0.00 youngs/s, 0.00 non-youngs/s Pages read 84546, created 96529, written 94713 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 64976, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 6 queries inside InnoDB, 703 queries in queue 4 read views open inside InnoDB 3 RW transactions active inside InnoDB 0 RO transactions active inside InnoDB 3 out of 1000 descriptors used ---OLDEST VIEW--- Normal read view Read view low limit trx n:o 971320415 Read view up limit trx id 970985893 Read view low limit trx id 971320415 Read view individually stored trx ids: Read view trx id 970985893 Read view trx id 971287638 ----------------- 3 tablespace extents now reserved for B-tree split operations Main thread process no. 57182, id 140494583604992, state: sleeping Number of rows inserted 2640818, updated 38895, deleted 0, read 4283845 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 1 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Trx #rec lock waits 0 #table lock waits 0 Trx total rec lock wait time 0 SEC Trx total table lock wait time 0 SEC -------- 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) Pending normal aio reads: 0 [0, 0, 0, 0, 0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 170671 OS file reads, 320961 OS file writes, 1656 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 15048, seg size 15050, 5 merges merged operations: insert 245, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 259075169386 Log flushed up to 259075169386 Pages flushed up to 258587889914 Last checkpoint at 258587889914 Max checkpoint age 651231499 Checkpoint age target 630880515 Modified age 487279472 Checkpoint age 487279472 0 pending log writes, 0 pending chkp writes 124409 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 2252341248; in additional pool allocated 0 Total memory allocated by read views 13384 Internal hash tables (constant factor + variable factor) Adaptive hash index 35406016 (35401816 + 4200) Page hash 1107208 (buffer pool 0 only) Dictionary cache 9476565 (8851984 + 624581) File system 88048 (82672 + 5376) Lock system 23364192 (5313416 + 18050776) Recovery system 0 (0 + 0) Dictionary memory allocated 624581 Buffer pool size 131070 Buffer pool size, bytes 2147450880 Free buffers 31 Database pages 129982 Old database pages 48019 Modified db pages 37397 Percent of dirty pages(LRU & free pages): 28.764 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 697, not young 1704534 0.00 youngs/s, 0.00 non-youngs/s Pages read 170654, created 194043, written 196563 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 129982, 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 65535 Buffer pool size, bytes 1073725440 Free buffers 0 Database pages 65006 Old database pages 24015 Modified db pages 20018 Percent of dirty pages(LRU & free pages): 30.794 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 520, not young 854712 0.00 youngs/s, 0.00 non-youngs/s Pages read 86108, created 97514, written 101850 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 65006, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 65535 Buffer pool size, bytes 1073725440 Free buffers 31 Database pages 64976 Old database pages 24004 Modified db pages 17379 Percent of dirty pages(LRU & free pages): 26.734 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 177, not young 849822 0.00 youngs/s, 0.00 non-youngs/s Pages read 84546, created 96529, written 94713 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 64976, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 6 queries inside InnoDB, 703 queries in queue 4 read views open inside InnoDB 3 RW transactions active inside InnoDB 0 RO transactions active inside InnoDB 3 out of 1000 descriptors used ---OLDEST VIEW--- Normal read view Read view low limit trx n:o 971320415 Read view up limit trx id 970985893 Read view low limit trx id 971320415 Read view individually stored trx ids: Read view trx id 970985893 Read view trx id 971287638 ----------------- 3 tablespace extents now reserved for B-tree split operations Main thread process no. 57182, id 140494583604992, state: sleeping Number of rows inserted 2640818, updated 38895, deleted 0, read 4283845 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 1 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================