Bug #63339 Incorrect file path in Performance_schema on Windows
Submitted: 20 Nov 2011 11:58 Modified: 9 Apr 2012 2:08
Reporter: Peter Laursen (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Performance Schema Severity:S3 (Non-critical)
Version:5.5.18 OS:Microsoft Windows
Assigned to: CPU Architecture:Any
Tags: qc

[20 Nov 2011 11:58] Peter Laursen
Double backslashes ("\\") display in file path in P_S tables `file_instances` and `file_summary_by_instance` between last folder in path and file name. Between folders a single backslash is correctly used like


(example: C:\ProgramData\MySQL\MySQL Server 5.5\Data\mysql\\db.opt)

How to repeat:
SELECT * FROM `performance_schema`.`file_instances`;
SELECT * FROM `performance_schema`.`file_summary_by_instance`;

Suggested fix:

should be 

[20 Nov 2011 12:04] Peter Laursen
Edited 'file name' >> 'file path' in synopsis.
[20 Nov 2011 12:46] Valeriy Kravchuk
Thank you for the problem report. Verified just as described on Windows XP.
[9 Apr 2012 2:08] Paul Dubois
Noted in 5.5.23, 5.6.6 changelogs. 

The Performance Schema incorrectly displayed some backslashes in 
Windows file names (by doubling them).