4. take a look in innodb status ``` root@yejr.run [(none)]>show engine innodb status\G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2020-09-07 20:55:49 0x7f737414f700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 7 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 61 srv_active, 0 srv_shutdown, 715384 srv_idle srv_master_thread log flush and writes: 0 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 3584241 OS WAIT ARRAY INFO: signal count 2954893 RW-shared spins 3, rounds 3, OS waits 0 RW-excl spins 84, rounds 2507, OS waits 83 RW-sx spins 17, rounds 218, OS waits 6 Spin rounds per wait: 1.00 RW-shared, 29.85 RW-excl, 12.82 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 784950916 Purge done for trx's n:o < 784950915 undo n:o < 0 state: running but idle History list length 0 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421609137102232, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421609137101376, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421609137100520, 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 18039 OS file reads, 66014 OS file writes, 8996 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 5, free list len 33243, seg size 33249, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 2212699, node heap has 4 buffer(s) Hash table size 2212699, node heap has 0 buffer(s) Hash table size 2212699, node heap has 0 buffer(s) Hash table size 2212699, node heap has 0 buffer(s) Hash table size 2212699, node heap has 0 buffer(s) Hash table size 2212699, node heap has 1 buffer(s) Hash table size 2212699, node heap has 1 buffer(s) Hash table size 2212699, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 1290975843597 Log buffer assigned up to 1290975843597 Log buffer completed up to 1290975843597 Log written up to 1290975843597 Log flushed up to 1290975843597 Added dirty pages up to 1290975843597 Pages flushed up to 1290975843597 Last checkpoint at 1290975843597 44457 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 8791261184 Dictionary memory allocated 505917 Buffer pool size 524288 Free buffers 506948 Database pages 17334 Old database pages 6252 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 96017, not young 82690 0.00 youngs/s, 0.00 non-youngs/s Pages read 11091, created 8608, written 12254 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: 17334, 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 65536 Free buffers 63304 Database pages 2232 Old database pages 804 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 12198, not young 1986 0.00 youngs/s, 0.00 non-youngs/s Pages read 1463, created 1062, written 1604 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: 2232, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 65536 Free buffers 63425 Database pages 2110 Old database pages 764 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 11197, not young 1828 0.00 youngs/s, 0.00 non-youngs/s Pages read 1393, created 1039, written 1423 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: 2110, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 65536 Free buffers 63379 Database pages 2156 Old database pages 778 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 11187, not young 4587 0.00 youngs/s, 0.00 non-youngs/s Pages read 1423, created 1027, written 1564 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: 2156, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 65536 Free buffers 63381 Database pages 2154 Old database pages 775 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 12286, not young 1741 0.00 youngs/s, 0.00 non-youngs/s Pages read 1383, created 1063, written 1463 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: 2154, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 65536 Free buffers 63384 Database pages 2151 Old database pages 779 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 12079, not young 1821 0.00 youngs/s, 0.00 non-youngs/s Pages read 1403, created 1006, written 1514 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: 2151, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 65536 Free buffers 63350 Database pages 2185 Old database pages 786 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 12788, not young 1672 0.00 youngs/s, 0.00 non-youngs/s Pages read 1289, created 1153, written 1525 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: 2185, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 65536 Free buffers 63310 Database pages 2225 Old database pages 803 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 12207, not young 67327 0.00 youngs/s, 0.00 non-youngs/s Pages read 1363, created 1191, written 1707 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: 2225, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 65536 Free buffers 63415 Database pages 2121 Old database pages 763 Modified db pages 0 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 12075, not young 1728 0.00 youngs/s, 0.00 non-youngs/s Pages read 1374, created 1067, written 1454 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: 2121, 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 0 read views open inside InnoDB Process ID=31458, Main thread ID=140124523935488 , state=sleeping Number of rows inserted 2002427, updated 6, deleted 0, read 12502850 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 128, updated 475, deleted 49, read 6658 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ ```