mysql数据库中,如何分析SHOW ENGINE INNODB STATUS命令查询的status状态内容?以下是status具体状态内容:---TRANSACTION 421404629562648, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421404629563624, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421404629564600, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421404629565576, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421404629566552, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421404629567528, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421404629568504, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421404629569480, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421404629570456, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421404629571432, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421404629572408, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421404629573384, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421404629574360, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421404629576312, not started
0 lock struct(s), heap size 1128, 0 row lock(s)
---TRANSACTION 421404629577288, not started
0 lock struct(s), heap size 1128, 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:
Pending flushes (fsync) log: 0; buffer pool: 471742
156526629 OS file reads, 3674182546 OS file writes, 1759120682 OS fsyncs
10.44 reads/s, 16384 avg bytes/read, 166.03 writes/s, 84.62 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 810, seg size 812, 47095351 merges
merged operations:
insert 47065383, delete mark 19475262, delete 130
discarded operations:
insert 0, delete mark 0, delete 0
Hash table size 3187567, node heap has 0 buffer(s)
Hash table size 3187567, node heap has 0 buffer(s)
Hash table size 3187567, node heap has 0 buffer(s)
Hash table size 3187567, node heap has 0 buffer(s)
Hash table size 3187567, node heap has 0 buffer(s)
Hash table size 3187567, node heap has 0 buffer(s)
Hash table size 3187567, node heap has 0 buffer(s)
Hash table size 3187567, node heap has 0 buffer(s)
0.00 hash searches/s, 814.73 non-hash searches/s
---
LOG
---
Log sequence number 3330574935903
Log buffer assigned up to 3330574935903
Log buffer completed up to 3330574935903
Log written up to 3330574935652
Log flushed up to 3330574935652
Added dirty pages up to 3330574935903
Pages flushed up to 3330415619252
Last checkpoint at 3330415602572
Log minimum file id is 11990
Log maximum file id is 12015
2617778760 log i/o's done, 190.33 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 0
Dictionary memory allocated 11696030
Buffer pool size 786363
Free buffers 8185
Database pages 778178
Old database pages 287097
Modified db pages 88854
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 183887271, not young 394584552
15.26 youngs/s, 8.03 non-youngs/s
Pages read 156528367, created 38875034, written 747882266
10.44 reads/s, 1.34 creates/s, 6.43 writes/s
Buffer pool hit rate 998 / 1000, young-making rate 3 / 1000 not 2 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 778178, unzip_LRU len: 0
I/O sum[5264]:cur[16], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size 98296
Free buffers 1024
Database pages 97272
Old database pages 35887
Modified db pages 11270
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 15652571, not young 49850012
1.34 youngs/s, 0.80 non-youngs/s
Pages read 20104859, created 3002366, written 92590187
0.80 reads/s, 0.00 creates/s, 0.80 writes/s
Buffer pool hit rate 999 / 1000, young-making rate 3 / 1000 not 1 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahea
最新发布