Comments on: MySQL query digest with Performance Schema https://www.percona.com/blog/mysql-query-digest-with-performance-schema/ Fri, 12 May 2023 18:10:41 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: ku https://www.percona.com/blog/mysql-query-digest-with-performance-schema/#comment-10968104 Wed, 24 May 2017 08:03:03 +0000 https://www.percona.com/blog/?p=32065#comment-10968104 Hello !
1. Is possible to use SHOW PROFILES and store output from it into some variable/ or table, like in example:
SHOW PROFILES INTO @myOutput;
2. I know that now perfromance scheema is preferred instead of “SHOW PROFILE” but:
a.) do I need to change performance_schema=ON and restart MySql server ? With using SHOW PROFILE it is not needed AFAIK.
b.) is possible to get only queries from currect session using performance_schema and queries will be numbered starting at 1 ? With using SHOW PROFILE we have queries only for session and starting from queryid=1

Jakub

]]> By: SuperQ https://www.percona.com/blog/mysql-query-digest-with-performance-schema/#comment-10965432 Wed, 14 Oct 2015 17:04:10 +0000 https://www.percona.com/blog/?p=32065#comment-10965432 I also noticed that P_S is disabled on Amazon Aurora. A quick look over the various console settings didn’t reveal a way to enable it.

]]>