When optimizing queries and investigating performance issues, MySQL comes with built in support for profiling queries aka [crayon-553ff71491111181756811-i/] . This is already awesome and simple to use, but why the PERFORMANCE_SCHEMA alternative? Because profiling will be removed soon (already deprecated on MySQL 5.6 ad 5.7); the built-in profiling capability can only be enabled per session. This [&]

The post Profiling MySQL queries from Performance Schema appeared first on MySQL Performance Blog.

https://www.percona.com/blog/2015/04/16/profiling-mysql-queries-from-performance-schema/