List:General Discussion« Previous MessageNext Message »
From:Rafał Radecki Date:June 21 2013 11:59am
Subject:SHOW INNODB STATUS - FILE I/O - OS reads/writes/syncs?
View as plain text  
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