INNODB STATUS
94 removals
| Lines | |
|---|---|
| Total | 116 |
| Removed | -58.6%68 |
| Words | |
| Total | 621 |
| Removed | -44.3%275 |
116 lines
64 additions
| Lines | |
|---|---|
| Total | 86 |
| Added | +44.2%38 |
| Words | |
| Total | 421 |
| Added | +17.8%75 |
86 lines
| InnoDB | |
| InnoDB | |
=====================================
=====================================
2021-08-29 11:51:48 0x7f72c82e1700 INNODB MONITOR OUTPUT
2021-08-29 15:54:30 0x7f146cbee700 INNODB MONITOR OUTPUT
=====================================
=====================================
Per second averages calculated from the last 19 seconds
Per second averages calculated from the last 56 seconds
-----------------
-----------------
BACKGROUND THREAD
BACKGROUND THREAD
-----------------
-----------------
srv_master_thread loops: 349 srv_active, 0 srv_shutdown, 1529 srv_idle
srv_master_thread loops: 42 srv_active, 0 srv_shutdown, 42081 srv_idle
srv_master_thread log flush and writes: 1878
srv_master_thread log flush and writes: 42115
----------
----------
SEMAPHORES
SEMAPHORES
----------
----------
OS WAIT ARRAY INFO: reservation count 269
OS WAIT ARRAY INFO: reservation count 300
OS WAIT ARRAY INFO: signal count 19026
OS WAIT ARRAY INFO: signal count 189
RW-shared spins 1965, rounds 1488, OS waits 14
RW-shared spins 56, rounds 548, OS waits 12
RW-excl spins 3665, rounds 2812, OS waits 31
RW-excl spins 32, rounds 688, OS waits 20
RW-sx spins 0, rounds 0, OS waits 0
RW-sx spins 9, rounds 211, OS waits 7
Spin rounds per wait: 0.76 RW-shared, 0.77 RW-excl, 0.00 RW-sx
Spin rounds per wait: 9.79 RW-shared, 21.50 RW-excl, 23.44 RW-sx
------------
------------
TRANSACTIONS
TRANSACTIONS
------------
------------
Trx id counter 107200170
Trx id counter 48871
Purge done for trx's n:o < 107200095 undo n:o < 0 state: running
Purge done for trx's n:o < 48718 undo n:o < 0 state: running but idle
History list length 4
History list length 0
LIST OF TRANSACTIONS FOR EACH SESSION:
LIST OF TRANSACTIONS FOR EACH SESSION:
---TRANSACTION 421634874116656, not started
---TRANSACTION 421201009074384, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421634874112400, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421634874108144, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421634874103888, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421634874099632, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421634874095376, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421634874091120, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421634874086864, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421634874082608, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421634874074096, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421634874078352, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421634874069840, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421634874065584, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421634874061328, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421634874057072, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421634874052816, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
0 lock struct(s), heap size 1128, 0 row lock(s)
--------
--------
FILE I/O
FILE I/O
--------
--------
Pending flushes (fsync) log: 0; buffer pool: 0
Pending flushes (fsync) log: 0; buffer pool: 0
159203 OS file reads, 1315 OS file writes, 1315 OS fsyncs
6123 OS file reads, 32693 OS file writes, 3028 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 0.26 writes/s, 0.26 fsyncs/s
0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
-------------------------------------
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
-------------------------------------
Ibuf: size 487, free list len 2542, seg size 3030, 84 merges
Ibuf: size 43, free list len 6108, seg size 6152, 0 merges
merged operations:
merged operations:
insert 1586, delete mark 105, delete 99
insert 0, delete mark 0, delete 0
discarded operations:
discarded operations:
insert 0, delete mark 0, delete 0
insert 0, delete mark 0, delete 0
0.00 hash searches/s, 12.68 non-hash searches/s
0.00 hash searches/s, 0.00 non-hash searches/s
---
---
LOG
LOG
---
---
Log sequence number 113687891447
Log sequence number 18510914009
Log flushed up to 113687891447
Log flushed up to 18510914009
Pages flushed up to 113685527064
Pages flushed up to 18502681255
Last checkpoint at 113685527052
Last checkpoint at 18502681255
0 pending log flushes, 0 pending chkp writes
0 pending log flushes, 0 pending chkp writes
1316 log i/o's done, 0.26 log i/o's/second
1005 log i/o's done, 0.00 log i/o's/second
----------------------
----------------------
BUFFER POOL AND MEMORY
BUFFER POOL AND MEMORY
----------------------
----------------------
Total large memory allocated 27950841856
Total large memory allocated 285212672
Dictionary memory allocated 166318008
Dictionary memory allocated 1790640
Buffer pool size 1677520
Buffer pool size 16130
Free buffers 1518347
Free buffers 3756
Database pages 159173
Database pages 12374
Old database pages 58777
Old database pages 4547
Modified db pages 764
Modified db pages 778
Percent of dirty pages(LRU & free pages): 0.046
Percent of dirty pages(LRU & free pages): 4.823
Max dirty pages percent: 90.000
Max dirty pages percent: 90.000
Pending reads 0
Pending reads 0
Pending writes: LRU 0, flush list 0
Pending writes: LRU 0, flush list 0
Pages made young 8, not young 0
Pages made young 8606, not young 1132327
0.00 youngs/s, 0.00 non-youngs/s
0.00 youngs/s, 0.00 non-youngs/s
Pages read 158953, created 208, written 0
Pages read 6068, created 25262, written 31562
0.00 reads/s, 0.00 creates/s, 0.00 writes/s
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
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
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 159173, unzip_LRU len: 0
LRU len: 12374, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
--------------
ROW OPERATIONS
ROW OPERATIONS
--------------
--------------
0 read views open inside InnoDB
0 read views open inside InnoDB
Process ID=0, Main thread ID=0, state: sleeping
Process ID=0, Main thread ID=0, state: sleeping
Number of rows inserted 643, updated 352, deleted 137, read 104574906
Number of rows inserted 2094220, updated 0, deleted 215152, read 50579205067
0.00 inserts/s, 0.05 updates/s, 0.05 deletes/s, 0.58 reads/s
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 0
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
0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
----------------------------
----------------------------
END OF INNODB MONITOR OUTPUT
END OF INNODB MONITOR OUTPUT
============================
============================