PROFILINGtable provides statement profiling information. Its contents correspond to the information produced by the
SHOW PROFILEstatements (see Section 184.108.40.206, “
SHOW PROFILESSyntax”). The table is empty unless the
profilingsession variable is set to 1.
PROFILINGtable was added in MySQL 5.1.24 but contains no information unless the
SHOW PROFILEfeature is enabled. The
SHOW PROFILEfeature is not included in binary distributions by default until MySQL 5.1.28.
QUERY_IDis a numeric statement identifier.
SEQis a sequence number indicating the display order for rows with the same
STATEis the profiling state to which the row measurements apply.
DURATIONindicates how long statement execution remained in the given state, in seconds.
CPU_SYSTEMindicate user and system CPU use, in seconds.
CONTEXT_INVOLUNTARYindicate how many voluntary and involuntary context switches occurred.
BLOCK_OPS_OUTindicate the number of block input and output operations.
MESSAGES_RECEIVEDindicate the number of communication messages sent and received.
PAGE_FAULTS_MINORindicate the number of major and minor page faults.
SWAPSindicates how many swaps occurred.
SOURCE_LINEprovide information indicating where in the source code the profiled state executes.