We have set up some monitoring on many of our databases that serve many different applications. It seems that they all report back more writes than reads when in reality that is very unlikely. I know much of the code inside and out and we do far more reads than we do writes. It has me wondering if a read is counted if it comes out of the cache (InnoDB buffer pool)?
Most of the stats seem to be based off of the innodb_data_reads system variable. Our buffer pools are large enough to contain all of our InnoDB tables.
One server I checked says it is like 10/1 writes to reads. However, when I view these two status variables:
Innodb_buffer_pool_read_requests: 1458637157995
Innodb_buffer_pool_reads: 516322
Innodb_data_reads: 643489
Innodb_data_writes: 17209580
Something doesn't work here..
Thanks for any help you can give!