Mysql 5.6 how to understands output for Buffer Pool and Memory in show engine innodb status

I have following information  from show engine innodb status output. I'm a bit puzzle how  to calculate the values ? for example the Buffer pool size   524288 in Buffer Pool 0, is this written in bytes ? or there is a way to calculate the value here ?


----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 70363643904; in additional pool allocated 0
Dictionary memory allocated 1177057
Buffer pool size   4194304
Free buffers       3537347
Database pages     614648
Old database pages 226967
Modified db pages  38
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 851, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 606746, created 7902, written 1493885
0.02 reads/s, 0.06 creates/s, 9.42 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: 614648, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
----------------------
INDIVIDUAL BUFFER POOL INFO
----------------------
---BUFFER POOL 0
Buffer pool size   524288
Free buffers       442772
Database pages     76229
Old database pages 28128
Modified db pages  9
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 114, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 74824, created 1405, written 246681
0.00 reads/s, 0.00 creates/s, 1.98 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: 76229, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
motioneyeAsked:
Who is Participating?
 
theGhost_k8Database ConsultantCommented:
This is pretty old writeup but doesn't this explain enough?  --> https://www.percona.com/blog/2006/07/17/show-innodb-status-walk-through/

Just to make things easy and quick... let'see whatyou have:

" Buffer pool size   4194304" >> That's your total buffferpool size.
By default you have 8 buffer pool instances.
so you will see BUFFER POOL 0 till 7.. and all will have  "Buffer pool size   524288"

Refer to above article for more info.
1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.