Skip navigation links

MySQL Forums :: Performance :: buffer pool read/write?


Advanced Search

buffer pool read/write?
Posted by: Rizwan Mian ()
Date: January 03, 2013 08:38PM

Dear Friends,

Happy new year. :-)

Re: Innodb_data_read and Innodb_data_written [1]

Innodb_data_read represents the "amount of data read since the server was started", while Innodb_data_written represents the "amount of data written so far, in bytes".

In both cases, the source or the destination is not mentioned. In all likelihood, the data is being written to disk. Does Innodb_data_read represent the data being read from the disk? If yes, is the data read from the buffer pool to perform query operation (such as sorting) accounted by another variable?

Thanking in advance and I look forward to your reply.

[1] http://dev.mysql.com/doc/refman/5.0/en/server-status-variables.html#statvar_Innodb_data_read

--
Rizwan Mian
Doctoral Candidate
Computer Science
Queens University
http://ca.linkedin.com/in/rizwanmian

Options: ReplyQuote


Subject Views Written By Posted
buffer pool read/write? 1124 Rizwan Mian 01/03/2013 08:38PM
Re: buffer pool read/write? 625 Rick James 01/05/2013 02:37PM
Re: buffer pool read/write? 463 Rizwan Mian 01/05/2013 04:50PM
Re: buffer pool read/write? 455 Rick James 01/06/2013 06:01PM
Re: buffer pool read/write? 373 aftab khan 01/08/2013 06:18AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.