SHOW GLOBAL STATUS LIKE 'Innodb%';
Then do some math -- usually dividing by Uptime.
That will give you some insight in how hard the I/O is working, and how full the
> -----Original Message-----
> From: Rafał Radecki [mailto:radecki.rafal@stripped]
> Sent: Friday, June 21, 2013 4:59 AM
> To: mysql@stripped
> Subject: SHOW INNODB STATUS - FILE I/O - OS reads/writes/syncs?
> Hi All.
> I've searched but with no luck... what do exactly these variables mean:
> 1343928 OS file reads, 1085452262 OS file writes, 19976022 OS fsyncs
> I am wondering if my innodb_buffer_pool setting is not to low. Does 'file
> reads' show number of times innodb files have been read into memory from
> server's start? What about file writes/fsyncs?
> Best regards,
> Rafal Radecki.