Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

There are no errors in the log file, but this doesn't seem to add up to me. Maybe I'm misunderstanding something:

mysql> show variables like '%buffer_pool%';
| Variable_name           | Value     |
| innodb_buffer_pool_size | 268435456 |
1 row in set (0.00 sec)

mysql> show innodb status\G
Total memory allocated 307469458; in additional pool allocated 1046016
Dictionary memory allocated 1258016
Buffer pool size   16384
Free buffers       10303
Database pages     5702
Modified db pages  30
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 2818, created 2884, written 659615
0.00 reads/s, 0.03 creates/s, 3.48 writes/s
Buffer pool hit rate 1000 / 1000

Is the Buffer pool size in the status different from the configuration setting? I was expecting them to be the same, or pretty close...

share|improve this question
up vote 2 down vote accepted

I'm not a MySQL expert but at first sight it looks like the variable innodb_buffer_pool_size is in bytes while the value below is in pages. The default InnoDB page size is 16KB so in bytes, you will get the same value:

16384 * 16 * 1024 = 268435456
share|improve this answer
Looks like you're right. I halved the pool size and it dropped to 8k. – Josh Feb 14 '14 at 21:40

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.