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!