Re: InnoDB memory usage discrepancies

[Ankur Shukla]

Output of pt-mysql-summary
# InnoDB #####################################################
Version | 8.0.23
Buffer Pool Size | 80.0G
Buffer Pool Fill | 90%
Buffer Pool Dirty | 0%
File Per Table | ON
Page Size | 16k
Log File Size | 2 * 512.0M = 1.0G
Log Buffer Size | 32M
Flush Method | fsync
Flush Log At Commit | 0
XA Support |
Checksums |
Doublewrite | ON
R/W I/O Threads | 32 32
I/O Capacity | 200
Thread Concurrency | 0
Concurrency Tickets | 5000
Commit Concurrency | 0
Txn Isolation Level |
Adaptive Flushing | ON
Adaptive Checkpoint |
Checkpoint Age | 3M
InnoDB Queue | 0 queries inside InnoDB, 0 queries in queue
Oldest Transaction | 0 Seconds
History List Len | 36
Read Views | 0
Undo Log Entries | 1 transactions, 2 total undo, 2 max undo
Pending I/O Reads | 0 buf pool reads, 0 normal AIO, 0 ibuf AIO, 0 preads
Pending I/O Writes | 0 buf pool (0 LRU, 0 flush list, 0 page); 0 AIO, 0 sync, 0 log IO (0 log, 0 chkp); 0 pwrites
Pending I/O Flushes | 478553 buf pool, 0 log
Transaction States | 1xACTIVE (PREPARED), 4xnot started