20.17. The INFORMATION_SCHEMA PROFILING Table

20.17. The `INFORMATION_SCHEMA PROFILING` Table

This section does not apply to MySQL Enterprise Server users.

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

`INFORMATION_SCHEMA` Name	`SHOW` Name	Remarks
`QUERY_ID`	`Query_ID`
`SEQ`
`STATE`	`Status`
`DURATION`	`Duration`
`CPU_USER`	`CPU_user`
`CPU_SYSTEM`	`CPU_system`
`CONTEXT_VOLUNTARY`	`Context_voluntary`
`CONTEXT_INVOLUNTARY`	`Context_involuntary`
`BLOCK_OPS_IN`	`Block_ops_in`
`BLOCK_OPS_OUT`	`Block_ops_out`
`MESSAGES_SENT`	`Messages_sent`
`MESSAGES_RECEIVED`	`Messages_received`
`PAGE_FAULTS_MAJOR`	`Page_faults_major`
`PAGE_FAULTS_MINOR`	`Page_faults_minor`
`SWAPS`	`Swaps`
`SOURCE_FUNCTION`	`Source_function`
`SOURCE_FILE`	`Source_file`
`SOURCE_LINE`	`Source_line`

Notes:

The PROFILING table was added in MySQL 5.0.37.
QUERY_ID is a numeric statement identifier.
SEQ is a sequence number indicating the display order for rows with the same QUERY_ID value.
STATE is the profiling state to which the row measurements apply.
DURATION indicates how long statement execution remained in the given state, in seconds.
CPU_USER and CPU_SYSTEM indicate user and system CPU use, in seconds.
CONTEXT_VOLUNTARY and CONTEXT_INVOLUNTARY indicate how many voluntary and involuntary context switches occurred.
BLOCK_OPS_IN and BLOCK_OPS_OUT indicate the number of block input and output operations.
MESSAGES_SENT and MESSAGES_RECEIVED indicate the number of communication messages sent and received.
PAGE_FAULTS_MAJOR and PAGE_FAULTS_MINOR indicate the number of major and minor page faults.
SWAPS indicates how many swaps occurred.
SOURCE_FUNCTION, SOURCE_FILE, and SOURCE_LINE provide information indicating where in the source code the profiled state executes.