SHOW Statements The value of this column corresponds to the  COM_ xxx  commands of the client/server protocol and Com_ xxx  status variables. See Section 5.1.10, “Server Status Variables” . The time in seconds that the thread has been in its current state. For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. See Section 17.2.3, “Replication Threads” . An action, event, or state that indicates what the thread is doing. For descriptions of  State  values, see Section 8.14, “Examining Server Thread (Process) Information” . Most states correspond to very quick operations. If a thread stays in a given state for many seconds, there might be a problem that needs to be investigated. The statement the thread is executing, or  NULL  if it is executing no statement. The statement might be the one sent to the server, or an innermost statement if the statement executes other statements. For example, if a  CALL  statement executes a stored procedure that is executing a  SELECT  statement, the Info  value shows the  SELECT  statement. • Time • State • Info 13.7.7.30 SHOW PROFILE Statement SHOW PROFILE [ type  [,  type ] ... ] [FOR QUERY  n ] [LIMIT  row_count  [OFFSET  offset ]] type : { ALL | BLOCK IO | CONTEXT SWITCHES | CPU | IPC | MEMORY | PAGE FAULTS | SOURCE | SWAPS } The  SHOW PROFILE  and  SHOW PROFILES  statements display profiling information that indicates resource usage for statements executed during the course of the current session. The  SHOW PROFILE  and  SHOW PROFILES  statements are deprecated; expect them to be removed in a future MySQL release. Use the Performance Schema instead; see Section 27.19.1, “Query Profiling Using Performance Schema” . To control profiling, use the  profiling  session variable, which has a default value of 0 ( OFF ). Enable profiling by setting  profiling  to 1 or  ON : Note mysql>  SET profiling = 1; SHOW PROFILES  displays a list of the most recent statements sent to the server. The size of the list is controlled by the  profiling_history_size  session variable, which has a default value of 15. The maximum value is 100. Setting the value to 0 has the practical effect of disabling profiling. 2944