Forum Moderators: open

Message Too Old, No Replies

Decoding "Innodb buffer pool reads"

Understanding performance of InnoDB

         

craig1972

8:29 pm on Apr 19, 2009 (gmt 0)

10+ Year Member



I see this in my phpmyadmin stats for the database:


Innodb_buffer_pool_reads 9,404
The number of logical reads that InnoDB could not satisfy from buffer pool and had to do a single-page read.

This number is in red, and is therefore quite high. My innodb_buffer is 11GB on a 32GB RAM dual quadcore server with 5 SCSI hard disks on RAID10.

With that hardware and that much RAM available to a basically small DB (largest table has 100,000 records!) why are the queries doing "single page read"s at all?

Is there a way for me to find queries that require this? The slow query log is now almost empty, so I cannot find much there.

Thanks!