Bug #71698 Add instrumentation for the doublewrite buffer and undo segments

• Submitted: 13 Feb 2014 9:05
• Modified: 12 Mar 2015 23:45
• Reporter: Daniël van Eeden (OCA)
• Status: Verified
• Category: MySQL Server: Performance Schema
• Severity: S4 (Feature request)
• Version: 5.6.15
• OS: Any
• Assigned to: Marc ALFF
• CPU Architecture: Any

[13 Feb 2014 9:05] Daniël van Eeden

Description:
Performance shema shows that I'm doing a lot of I/O to ibdata1. I'm using innodb_file_per_table, so there are no tables in that tablespace. Is it the doublewrite buffer or is it the undo tablespace which is generating the I/O?

How to repeat:
Try to get information about what is causing I/O on ibdata1 (in file per table mode).

[13 Mar 2015 6:59] MySQL Verification Team

you can also monitor innodb by querying information_schema.innodb_metrics after appropriate monitors are enabled