PROFILING table provides
statement profiling information. Its contents correspond to the
information produced by the
statements (see Section 220.127.116.11, “SHOW PROFILES Syntax”). The table is
empty unless the
session variable is set to 1.
PROFILING table was added in
MySQL 5.1.24 but contains no information unless the
SHOW PROFILE feature is
feature is not included in binary distributions by default
until MySQL 5.1.28.
QUERY_ID is a numeric statement identifier.
SEQ is a sequence number indicating the
display order for rows with the same
STATE is the profiling state to which the
row measurements apply.
DURATION indicates how long statement
execution remained in the given state, in seconds.
indicate user and system CPU use, in seconds.
CONTEXT_INVOLUNTARY indicate how many
voluntary and involuntary context switches occurred.
BLOCK_OPS_OUT indicate the number of block
input and output operations.
MESSAGES_RECEIVED indicate the number of
communication messages sent and received.
PAGE_FAULTS_MINOR indicate the number of
major and minor page faults.
SWAPS indicates how many swaps occurred.
SOURCE_LINE provide information indicating
where in the source code the profiled state executes.