MySQL Forums :: Performance :: buffer pool read/write?
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
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
| Subject | Views | Written By | Posted |
|---|---|---|---|
| buffer pool read/write? | 556 | Rizwan Mian | 01/03/2013 08:38PM |
| Re: buffer pool read/write? | 277 | Rick James | 01/05/2013 02:37PM |
| Re: buffer pool read/write? | 272 | Rizwan Mian | 01/05/2013 04:50PM |
| Re: buffer pool read/write? | 247 | Rick James | 01/06/2013 06:01PM |
| Re: buffer pool read/write? | 223 | 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.
© 2013, Oracle Corporation and/or its affiliates