Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
[...]
----------------------
BUFFER POOL AND MEMORY
----------------------
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

1 Answer 1

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 at 21:40

Your Answer

 
discard

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.