MySQL: Tracing a single query with PERFORMANCE_SCHEMA | Percona Community

My task is to collect performance data about a single query, using PERFORMANCE_SCHEMA (P_S for short) in MySQL, to ship it elsewhere for integration with other data.


This is a companion discussion topic for the original entry at https://percona.community/blog/2022/10/18/mysql-tracing-a-single-query-with-performance_schema/

Comment by @lefred:

Hi Kristian,

Nice post (as usual), just one little comment, on 8.0 it’s advised to use the format_pico_time() internal function instead of the sys.format_time() :wink:

Cheers.