Details
- 
    Bug 
- 
    Status: Closed (View Workflow)
- 
    Critical 
- 
    Resolution: Fixed
- 
    10.6, 10.11, 10.5(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 11.0(EOL), 11.1(EOL)
Description
Starting with MDEV-18115 in MariaDB Server 10.5.1, the counter Innodb_data_written no longer includes writes to the redo log file ib_logfile0, which will continue to be counted by Innodb_os_log_written.
When the asynchronous doublewrite was implemented in MDEV-23855, the writes via the doublewrite buffer started to be counted incorrectly, without multiplying them by innodb_page_size. The code has since then been refactored, but the error has been preserved.
While we are at it, it looks like we can remove the separate counter buf_dblwr.pages_submitted (initiated writes) and only report buf_dblwr.pages_written (completed writes).
A work-around for the error could be the following formulae:
real_data_written = Innodb_data_written + (innodb_page_size - 1) * Innodb_dblwr_pages_written
innodb_written = real_data_written + Innodb_os_log_written
Attachments
Issue Links
- is caused by
- 
                    MDEV-23855 InnoDB log checkpointing causes regression for write-heavy OLTP -         
- Closed
 
-         
- relates to
- 
                    MDEV-18115 Remove dummy tablespace for the redo log -         
- Closed
 
-         
- 
                    MDEV-31171 Document MDEV-31124 Innodb_data_written miscounts doublewrites -         
- Closed
 
-