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.ra...@gmail.com] > Sent: Friday, June 21, 2013 4:59 AM > To: mysql@lists.mysql.com > 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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
