Bug #68574 No instrumentation for InnoDB files in P_S on windows

• Submitted: 5 Mar 2013 13:42
• Modified: 13 Aug 2021 10:40
• Reporter: Daniël van Eeden (OCA)
• Status: Closed
• Category: MySQL Server: InnoDB storage engine
• Severity: S3 (Non-critical)
• Version: 5.5.30, 5.6.16
• OS: 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] MySQL Verification Team

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] MySQL Verification Team

also: http://bugs.mysql.com/bug.php?id=80851

[3 Oct 2017 7:47] MySQL Verification Team

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.

[13 Aug 2021 10:40] Marc ALFF

Closing Bug #68574 No instrumentation for InnoDB files in P_S on windows.

It was documented as fixed on Oct 2017, but the status was forgotten.