Re: Innodb_buffer_pool_pages_free = 0

[Aftab Khan]

You should check following status variables:

a) Innodb_buffer_pool_read_requests

The number of logical read requests InnoDB has done.

b) Innodb_buffer_pool_reads

The number of logical reads that InnoDB could not satisfy from the buffer pool, and had to read directly from the disk. If this is high then your innodb buffer pool is probably too small.

http://mysqlopt.blogspot.co.uk/search?q=server+tuning

Provide output of the following please:

SHOW GLOBAL STATUS LIKE 'innodb_%';



Edited 1 time(s). Last edit at 09/27/2012 01:48AM by Aftab Khan.