content_image/699438.jpg content_image/699439.jpg
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.7.30, “SHOW PROFILE Statement” ). The table is empty unless the profiling  session variable is set to 1. 

<img src='content_image/699438.jpg'>

The PROFILING  table has these columns: 

• QUERY_ID 

A numeric statement identifier. 

• SEQ 

<img src='content_image/699439.jpg'>

## Note 

This table is deprecated; expect it to be removed in a future MySQL release. Use the Performance Schema instead; see Section 27.19.1, “Query Profiling Using Performance Schema” . 

A sequence number indicating the display order for rows with the same QUERY_ID  value. 

## Notes 

• STATE 

The profiling state to which the row measurements apply. 

• DURATION 

How long statement execution remained in the given state, in seconds. 

• CPU_USER , CPU_SYSTEM 

User and system CPU use, in seconds. 

• CONTEXT_VOLUNTARY , CONTEXT_INVOLUNTARY 

How many voluntary and involuntary context switches occurred. 

• BLOCK_OPS_IN , BLOCK_OPS_OUT 

The number of block input and output operations. 

• MESSAGES_SENT , MESSAGES_RECEIVED 

The number of communication messages sent and received. 

• PAGE_FAULTS_MAJOR , PAGE_FAULTS_MINOR 

The number of major and minor page faults. 

• SWAPS 

How many swaps occurred. 

• SOURCE_FUNCTION , SOURCE_FILE , and SOURCE_LINE 

Information indicating where in the source code the profiled state executes. 

• PROFILING  is a nonstandard INFORMATION_SCHEMA  table. 

