|
*********************** 1. row **********************
|
Type: InnoDB
|
Name:
|
Status:
|
=====================================
|
2019-03-22 04:02:13 7f7251d86b00 INNODB MONITOR OUTPUT
|
=====================================
|
Per second averages calculated from the last 21 seconds
|
-----------------
|
BACKGROUND THREAD
|
-----------------
|
srv_master_thread loops: 40531425 srv_active, 0 srv_shutdown, 150699 srv_idle
|
srv_master_thread log flush and writes: 40681757
|
----------
|
SEMAPHORES
|
----------
|
OS WAIT ARRAY INFO: reservation count 9447206567
|
OS WAIT ARRAY INFO: signal count 10437990026
|
Mutex spin waits 945754110162, rounds 7723699928973, OS waits 6031972365
|
RW-shared spins 1385469837, rounds 9119611806, OS waits 68569143
|
RW-excl spins 7454870242, rounds 61749566591, OS waits 235509667
|
Spin rounds per wait: 8.17 mutex, 6.58 RW-shared, 8.28 RW-excl
|
------------
|
TRANSACTIONS
|
------------
|
Trx id counter 72323530086
|
Purge done for trx's n:o < 72321663909 undo n:o < 0 state: running but idle
|
History list length 24
|
LIST OF TRANSACTIONS FOR EACH SESSION:
|
---TRANSACTION 0, not started
|
MySQL thread id 8443428, OS thread handle 0x7f7251d86b00, query id 140263150527 localhost root init
|
show engine innodb status
|
---TRANSACTION 72323529147, not started
|
MySQL thread id 8443412, OS thread handle 0x7f71c0432b00, query id 140263147712 172.22.50.182 li_search cleaning up
|
---TRANSACTION 0, not started
|
MySQL thread id 8442794, OS thread handle 0x7f7252db6b00, query id 140258644073 localhost root checking permissions
|
start slave
|
---TRANSACTION 72323529443, not started
|
MySQL thread id 8441864, OS thread handle 0x7f72b8720b00, query id 140263148600 172.22.50.4 li_search cleaning up
|
---TRANSACTION 72323529329, not started
|
MySQL thread id 8441429, OS thread handle 0x7f72565cab00, query id 140263148258 172.22.50.154 li_search cleaning up
|
---TRANSACTION 72323530085, not started
|
MySQL thread id 8441330, OS thread handle 0x7f7258e42b00, query id 140263150526 172.22.50.162 li_search cleaning up
|
---TRANSACTION 72323529461, not started
|
MySQL thread id 8440893, OS thread handle 0x7f72527a4b00, query id 140263148654 172.22.50.55 li_search cleaning up
|
---TRANSACTION 72323529551, not started
|
MySQL thread id 8440181, OS thread handle 0x7f72533c8b00, query id 140263148924 172.22.50.43 li_search cleaning up
|
---TRANSACTION 18981431251, not started
|
MySQL thread id 180, OS thread handle 0x7f84bf760b00, query id 0 Waiting for room in worker thread event queue
|
---TRANSACTION 72315275363, not started
|
MySQL thread id 173, OS thread handle 0x7f84bf716b00, query id 140238348005 Waiting for prior transaction to start commit before starting next transaction
|
---TRANSACTION 72315275347, not started
|
MySQL thread id 172, OS thread handle 0x7f8493dc2b00, query id 140238347969 Waiting for prior transaction to start commit before starting next transaction
|
---TRANSACTION 72315275361, not started
|
MySQL thread id 176, OS thread handle 0x7f8493ce4b00, query id 140238348001 Waiting for prior transaction to commit
|
---TRANSACTION 72315275362, not started
|
MySQL thread id 177, OS thread handle 0x7f8487ffdb00, query id 140238348003 Waiting for prior transaction to start commit before starting next transaction
|
---TRANSACTION 2310, not started
|
MySQL thread id 171, OS thread handle 0x7f84bf7aab00, query id 0 Waiting for master to send event
|
---TRANSACTION 2307, not started
|
MySQL thread id 1, OS thread handle 0x7f84c0994b00, query id 0 Waiting for background binlog tasks
|
---TRANSACTION 72315275353, ACTIVE (PREPARED) 8561 sec
|
3 lock struct(s), heap size 1184, 1 row lock(s), undo log entries 2
|
MySQL thread id 179, OS thread handle 0x7f8493c9ab00, query id 140238347980 Unlocking tables
|
Trx #rec lock waits 330906860 #table lock waits 0
|
Trx total rec lock wait time 787891 SEC
|
Trx total table lock wait time 0 SEC
|
---TRANSACTION 72315275351, ACTIVE (PREPARED) 8561 sec
|
3 lock struct(s), heap size 1184, 1 row lock(s), undo log entries 2
|
MySQL thread id 175, OS thread handle 0x7f8493d78b00, query id 140238347977 Unlocking tables
|
Trx #rec lock waits 331065984 #table lock waits 0
|
Trx total rec lock wait time 788857 SEC
|
Trx total table lock wait time 0 SEC
|
---TRANSACTION 72315275349, ACTIVE (PREPARED) 8561 sec
|
3 lock struct(s), heap size 1184, 1 row lock(s), undo log entries 2
|
MySQL thread id 178, OS thread handle 0x7f8493c50b00, query id 140238347975 Unlocking tables
|
Trx #rec lock waits 330986199 #table lock waits 0
|
Trx total rec lock wait time 789185 SEC
|
Trx total table lock wait time 0 SEC
|
---TRANSACTION 72315275348, ACTIVE (PREPARED) 8561 sec
|
3 lock struct(s), heap size 1184, 1 row lock(s), undo log entries 2
|
MySQL thread id 174, OS thread handle 0x7f8493d2eb00, query id 140238347971 Unlocking tables
|
Trx #rec lock waits 331122811 #table lock waits 0
|
Trx total rec lock wait time 789145 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 (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)
|
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] , aio writes: 0 [0, 0, 0, 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
|
4968882 OS file reads, 38303692643 OS file writes, 708650231 OS fsyncs
|
0.00 reads/s, 0 avg bytes/read, 4.38 writes/s, 4.38 fsyncs/s
|
-------------------------------------
|
INSERT BUFFER AND ADAPTIVE HASH INDEX
|
-------------------------------------
|
Ibuf: size 1, free list len 0, seg size 2, 799783 merges
|
merged operations:
|
insert 292912, delete mark 507066, delete 25
|
discarded operations:
|
insert 0, delete mark 0, delete 0
|
1397.41 hash searches/s, 19.00 non-hash searches/s
|
---
|
LOG
|
---
|
Log sequence number 17984575687814
|
Log flushed up to 17984575687814
|
Pages flushed up to 17984575687794
|
Last checkpoint at 17984575687794
|
Max checkpoint age 6955245159
|
Checkpoint age target 6737893748
|
Modified age 20
|
Checkpoint age 20
|
0 pending log writes, 0 pending chkp writes
|
35500575835 log i/o's done, 2.48 log i/o's/second
|
----------------------
|
BUFFER POOL AND MEMORY
|
----------------------
|
Total memory allocated 71974256640; in additional pool allocated 0
|
Total memory allocated by read views 2064
|
Internal hash tables (constant factor + variable factor)
|
Adaptive hash index 5993782880 (1211076088 + 4782706792)
|
Page hash 8851208 (buffer pool 0 only)
|
Dictionary cache 285621838 (283213232 + 2408606)
|
File system 1041888 (812272 + 229616)
|
Lock system 170009104 (169998968 + 10136)
|
Recovery system 0 (0 + 0)
|
Dictionary memory allocated 2408606
|
Buffer pool size 4194296
|
Buffer pool size, bytes 68719345664
|
Free buffers 8193
|
Database pages 3894190
|
Old database pages 1437339
|
Modified db pages 1
|
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 188142885, not young 50188703
|
5.24 youngs/s, 0.00 non-youngs/s
|
Pages read 4779703, created 10188373, written 2737775498
|
0.00 reads/s, 0.00 creates/s, 0.95 writes/s
|
Buffer pool hit rate 1000 / 1000, young-making rate 2 / 1000 not 0 / 1000
|
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
|
LRU len: 3894190, unzip_LRU len: 0
|
I/O sum[400]:cur[0], unzip sum[0]:cur[0]
|
----------------------
|
INDIVIDUAL BUFFER POOL INFO
|
----------------------
|
---BUFFER POOL 0
|
Buffer pool size 524287
|
Buffer pool size, bytes 8589918208
|
Free buffers 1024
|
Database pages 486637
|
Old database pages 179617
|
Modified db pages 1
|
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 22730999, not young 6402634
|
0.52 youngs/s, 0.00 non-youngs/s
|
Pages read 598621, created 1274125, written 343294511
|
0.00 reads/s, 0.00 creates/s, 0.95 writes/s
|
Buffer pool hit rate 1000 / 1000, young-making rate 2 / 1000 not 0 / 1000
|
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
|
LRU len: 486637, unzip_LRU len: 0
|
I/O sum[50]:cur[0], unzip sum[0]:cur[0]
|
---BUFFER POOL 1
|
Buffer pool size 524287
|
Buffer pool size, bytes 8589918208
|
Free buffers 1024
|
Database pages 486841
|
Old database pages 179692
|
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 24875356, not young 6265219
|
0.71 youngs/s, 0.00 non-youngs/s
|
Pages read 594823, created 1262517, written 338885016
|
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
|
Buffer pool hit rate 1000 / 1000, young-making rate 3 / 1000 not 0 / 1000
|
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
|
LRU len: 486841, unzip_LRU len: 0
|
I/O sum[50]:cur[0], unzip sum[0]:cur[0]
|
---BUFFER POOL 2
|
Buffer pool size 524287
|
Buffer pool size, bytes 8589918208
|
Free buffers 1024
|
Database pages 486711
|
Old database pages 179644
|
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 21215244, not young 6020941
|
0.81 youngs/s, 0.00 non-youngs/s
|
Pages read 582819, created 1275871, written 341678374
|
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
|
Buffer pool hit rate 1000 / 1000, young-making rate 3 / 1000 not 0 / 1000
|
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
|
LRU len: 486711, unzip_LRU len: 0
|
I/O sum[50]:cur[0], unzip sum[0]:cur[0]
|
---BUFFER POOL 3
|
Buffer pool size 524287
|
Buffer pool size, bytes 8589918208
|
Free buffers 1024
|
Database pages 486880
|
Old database pages 179707
|
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 22196336, not young 6341332
|
0.57 youngs/s, 0.00 non-youngs/s
|
Pages read 596546, created 1274963, written 345140893
|
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
|
Buffer pool hit rate 1000 / 1000, young-making rate 2 / 1000 not 0 / 1000
|
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
|
LRU len: 486880, unzip_LRU len: 0
|
I/O sum[50]:cur[0], unzip sum[0]:cur[0]
|
---BUFFER POOL 4
|
Buffer pool size 524287
|
Buffer pool size, bytes 8589918208
|
Free buffers 1024
|
Database pages 486998
|
Old database pages 179750
|
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 24771076, not young 6270540
|
0.76 youngs/s, 0.00 non-youngs/s
|
Pages read 592251, created 1271903, written 344117527
|
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
|
Buffer pool hit rate 1000 / 1000, young-making rate 3 / 1000 not 0 / 1000
|
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
|
LRU len: 486998, unzip_LRU len: 0
|
I/O sum[50]:cur[0], unzip sum[0]:cur[0]
|
---BUFFER POOL 5
|
Buffer pool size 524287
|
Buffer pool size, bytes 8589918208
|
Free buffers 1025
|
Database pages 486733
|
Old database pages 179652
|
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 22241102, not young 6352619
|
0.67 youngs/s, 0.00 non-youngs/s
|
Pages read 609116, created 1277639, written 344031490
|
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
|
Buffer pool hit rate 1000 / 1000, young-making rate 2 / 1000 not 0 / 1000
|
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
|
LRU len: 486733, unzip_LRU len: 0
|
I/O sum[50]:cur[0], unzip sum[0]:cur[0]
|
---BUFFER POOL 6
|
Buffer pool size 524287
|
Buffer pool size, bytes 8589918208
|
Free buffers 1024
|
Database pages 486644
|
Old database pages 179620
|
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 25346030, not young 6343041
|
0.57 youngs/s, 0.00 non-youngs/s
|
Pages read 607742, created 1277906, written 335465918
|
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
|
Buffer pool hit rate 1000 / 1000, young-making rate 1 / 1000 not 0 / 1000
|
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
|
LRU len: 486644, unzip_LRU len: 0
|
I/O sum[50]:cur[0], unzip sum[0]:cur[0]
|
---BUFFER POOL 7
|
Buffer pool size 524287
|
Buffer pool size, bytes 8589918208
|
Free buffers 1024
|
Database pages 486746
|
Old database pages 179657
|
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 24766742, not young 6192377
|
0.62 youngs/s, 0.00 non-youngs/s
|
Pages read 597785, created 1273449, written 345161769
|
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
|
Buffer pool hit rate 1000 / 1000, young-making rate 2 / 1000 not 0 / 1000
|
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
|
LRU len: 486746, unzip_LRU len: 0
|
I/O sum[50]:cur[0], unzip sum[0]:cur[0]
|
--------------
|
ROW OPERATIONS
|
--------------
|
0 queries inside InnoDB, 0 queries in queue
|
0 read views open inside InnoDB
|
4 RW transactions active inside InnoDB
|
0 RO transactions active inside InnoDB
|
4 out of 1000 descriptors used
|
Main thread process no. 31732, id 140131931506432, state: sleeping
|
Number of rows inserted 1342177386, updated 18606012069, deleted 0, read 257704600451
|
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 1414.31 reads/s
|
Number of system rows inserted 19526117552, updated 0, deleted 19526117545, read 19526117545
|
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.00 sec)
|