MySQL Bugs: #70350: profiling is deprecated in 5.6 but it's not clear how to use P

Bug #70350	profiling is deprecated in 5.6 but it's not clear how to use P_S instead
Submitted:	16 Sep 2013 9:31	Modified:	12 Jun 2015 19:43
Reporter:	Simon Mudd (OCA)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S4 (Feature request)
Version:	5.6.13	OS:	Any
Assigned to:	Daniel Price	CPU Architecture:	Any

Description:
http://dev.mysql.com/doc/refman/5.6/en/show-profile.html says that this functionality is deprecated in favour of using performance_schema, but does not explain how to get the equivalent information using this new way.

How to repeat:
SET profiling = 1;
... some stuff to get some profiling on ...
SHOW PROFILE FOR QUERY X; -- to get the profile for query X

There are warnings shown to indicate this functionality is going away, but no pointers on how to do this differently.

Suggested fix:
Please add to http://dev.mysql.com/doc/refman/5.X/en/performance-schema-examples.html a reference on how to use P_S instead of using SHOW PROFILE FOR QUERY X;

Thank you for the reasonable doc request.

Posted by developer:
 
The following documentation has been added for query profiling using Performance Schema:

https://dev.mysql.com/doc/refman/5.6/en/performance-schema-query-profiling.html
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-query-profiling.html

Thank you for the bug report.