List:General Discussion« Previous MessageNext Message »
From:Rick James Date:June 25 2013 3:51pm
Subject:RE: SHOW INNODB STATUS - FILE I/O - OS reads/writes/syncs?
View as plain text  
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
buffer_pool is.

> -----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.
Thread
SHOW INNODB STATUS - FILE I/O - OS reads/writes/syncs?Rafał Radecki21 Jun
  • Re: SHOW INNODB STATUS - FILE I/O - OS reads/writes/syncs?Hartmut Holzgraefe21 Jun
    • Re: SHOW INNODB STATUS - FILE I/O - OS reads/writes/syncs?Rafał Radecki24 Jun
      • Re: SHOW INNODB STATUS - FILE I/O - OS reads/writes/syncs?shawn green24 Jun
  • RE: SHOW INNODB STATUS - FILE I/O - OS reads/writes/syncs?Rick James25 Jun