The INFORMATION_SCHEMA PROFILING Table 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. 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” . The  PROFILING  table has these columns: A numeric statement identifier. A sequence number indicating the display order for rows with the same  QUERY_ID  value. 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. • PROFILING  is a nonstandard  INFORMATION_SCHEMA  table. • SOURCE_FUNCTION ,  SOURCE_FILE , and  SOURCE_LINE • SWAPS • PAGE_FAULTS_MAJOR ,  PAGE_FAULTS_MINOR • MESSAGES_SENT ,  MESSAGES_RECEIVED • BLOCK_OPS_IN ,  BLOCK_OPS_OUT • CONTEXT_VOLUNTARY ,  CONTEXT_INVOLUNTARY • CPU_USER ,  CPU_SYSTEM • DURATION • STATE • SEQ • QUERY_ID Note Notes 4811