PROFILING table provides
statement profiling information. Its contents correspond to the
information produced by the
statements (see SHOW PROFILE Statement). The table is
empty unless the
session variable is set to 1.
This table is deprecated; expect it to be removed in a future MySQL release. Use the Performance Schema instead; see Query Profiling Using Performance Schema.
PROFILING table has these
A numeric statement identifier.
A sequence number indicating the display order for rows with the same
The profiling state to which the row measurements apply.
How long statement execution remained in the given state, in seconds.
User and system CPU use, in seconds.
How many voluntary and involuntary context switches occurred.
The number of block input and output operations.
The number of communication messages sent and received.
The number of major and minor page faults.
How many swaps occurred.
Information indicating where in the source code the profiled state executes.
PROFILINGis a nonstandard
Profiling information is also available from the
SHOW PROFILE and
SHOW PROFILES statements. See
SHOW PROFILE Statement. For example, the following queries
SHOW PROFILE FOR QUERY 2; SELECT STATE, FORMAT(DURATION, 6) AS DURATION FROM INFORMATION_SCHEMA.PROFILING WHERE QUERY_ID = 2 ORDER BY SEQ;