MySQL Forums
Forum List  »  Performance

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?
2114
January 03, 2013 08:38PM
1332
January 05, 2013 02:37PM
850
January 05, 2013 04:50PM
819
January 06, 2013 06:01PM
785
January 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.