MySQL 8.0 Reference Manual Including MySQL NDB Cluster 8.0

25.20 The INFORMATION_SCHEMA PROFILING Table

The PROFILING table provides statement profiling information. Its contents correspond to the information produced by the SHOW PROFILE and SHOW PROFILES statements (see Section 13.7.6.30, “SHOW PROFILE Syntax”). The table is empty unless the profiling session variable is set to 1.

Note

This table is deprecated and will be removed in a future MySQL release. Use the Performance Schema instead; see Section 26.19.1, “Query Profiling Using Performance Schema”.

The PROFILING table has these columns:

Notes

Profiling information is also available from the SHOW PROFILE and SHOW PROFILES statements. See Section 13.7.6.30, “SHOW PROFILE Syntax”. For example, the following queries are equivalent:

SHOW PROFILE FOR QUERY 2;

SELECT STATE, FORMAT(DURATION, 6) AS DURATION
FROM INFORMATION_SCHEMA.PROFILING
WHERE QUERY_ID = 2 ORDER BY SEQ;