推荐链接：
    总结——》【Java】
    总结——》【JVM】
    总结——》【Mysql】
    总结——》【Spring】
    总结——》【SpringBoot】

一、 查看InnoDB存储引擎运行过程中的一些状态信息

SHOW ENGINE INNODB STATUS;
1

202207200851SHOW ENGINE INNODB STATUS（全部）.txt
202207200851SHOW ENGINE INNODB STATUS（BufferPool相关信息）.txt

二、BufferPool相关信息

26826768384B = 24.984375GB
25766658048B = 23.9970703GB

----------------------
BUFFER POOL AND MEMORY
----------------------
Total large memory allocated 26826768384
Dictionary memory allocated 156608199
Internal hash tables (constant factor + variable factor)
    Adaptive hash index 1038461120 	(407954752 + 630506368)
    Page hash           3187928 (buffer pool 0 only)
    Dictionary cache    258596887 	(101988688 + 156608199)
    File system         9986392 	(812272 + 9174120)
    Lock system         63778552 	(63750152 + 28400)
    Recovery system     0 	(0 + 0)
Buffer pool size   1572672
Buffer pool size, bytes 25766658048
Free buffers       32768
Database pages     1501423
Old database pages 554072
Modified db pages  0
Pending reads      0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 509913737, not young 16908464306
0.00 youngs/s, 0.00 non-youngs/s
Pages read 834246715, created 30683415, written 249886514
0.00 reads/s, 0.00 creates/s, 0.75 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
LRU len: 1501423, unzip_LRU len: 0
I/O sum[72]:cur[0], unzip sum[0]:cur[0]
----------------------
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29