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) Email Updates:
Status: Verified Impact on me:
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
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