Bug #68574 No instrumentation for InnoDB files in P_S on windows
Submitted: 5 Mar 2013 13:42 Modified: 23 Feb 2014 11:25
Reporter: Daniël van Eeden (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical)
Version:5.5.30, 5.6.16 OS:Microsoft Windows (win7 sp1 ent)
Assigned to: Marc Alff CPU Architecture:Any
Tags: performance_schema, windows

[5 Mar 2013 13:42] Daniël van Eeden
Description:
A "SELECT * FROM performance_schema.setup_instruments WHERE name LIKE 'wait/io/file/innodb/%'" On 5.5.30/Win7_64 does return an empty set. On 5.5.29/Linux_64 it does return rows for innodb_data_file, innodb_log_file and innodb_temp_file. I use a noinstall zip and I run mysqld with the standalone option.

It looks similar to Bug #63340

Are the InnoDB files instrumented on Windows? 
If yes, why are they missing from the performance_schema?
If not, where is this documented? 
I would expect it to be listed on http://dev.mysql.com/doc/refman/5.5/en/performance-schema-restrictions.html
Or on http://dev.mysql.com/doc/mysql-windows-excerpt/5.5/en/index.html

[mysqld]
basedir=C:/somedir/MySQL/mysql-5.5.30-winx64
datadir=C:/somedir/MySQL/mysql-5.5.30-winx64/data
tmpdir=C:/somedir/MySQL/mysql-5.5.30-winx64/tmp
innodb_buffer_pool_size=4G
innodb_buffer_pool_instances=8
innodb_log_file_size=1G
innodb_flush_log_at_trx_commit=0
innodb_file_per_table=1
innodb_io_capacity=600
performance_schema=1

How to repeat:
Try to instrument InnoDB file I/O on windows with performance schema.

Suggested fix:
1. Enable InnoDB File I/O instrumentation on Windows
2. Document the differences between Linux and Windows for InnoDB File I/O instrumentation.
[29 Mar 2013 18:19] Umesh Shastry
Hello Daniel,

Thank you for the report.
Verified as described.

Thanks,
Umesh
[22 Feb 2014 15:49] Valeriy Kravchuk
Same problem with 5.6.1.6 on Windows also. I wonder why nobody cares to fix this?
[23 Feb 2014 11:25] Daniël van Eeden
Updated version info
[24 Mar 2016 19:01] Shane Bester
also: http://bugs.mysql.com/bug.php?id=80851
[3 Oct 2017 7:47] Shane Bester
From:
 FILE IO INSTRUMENTATION DISABLED IN PERFORMANCE SCHEMA FOR INNODB

Fixed as of the upcoming 5.6.36, 5.7.18, 8.0.1 release, and here's the
changelog entry:

Performance Schema instrumentation for InnoDB file I/O was disabled on
Windows.