SHOW PROCESSLIST

This topic describes how to execute the SHOW PROCESSLIST and SHOW PHYSICAL_PROCESSLIST statements.

SHOW PROCESSLIST

You can execute the following statement to view connections in PolarDB-X and SQL statements that are being executed.

• Syntax

  SHOW PROCESSLIST
  

• Examples

  SHOW PROCESSLIST\G
       ID: 1971050
     USER: admin
     HOST: 111.111.111.111:4303
       DB: drds_test
  COMMAND: Query
     TIME: 0
    STATE: 
     INFO: show processlist
  1 row in set (0.01 sec)
  

  | Parameter | Description | |---------------|-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| | ID | The ID of the connection. The value is a number of the LONG data type. | | USER | The username used to establish the connection. | | HOST | The IP address and port number of the host for which the connection is established. | | DB | The name of the database accessed over the connection. | | COMMAND | Valid values:

  • Query: The connection has an SQL statement that is being executed.
  • Sleep: The connection is idle.
  | | TIME | The duration for which the connection is in the current state.
  • If the value of the COMMAND parameter is Query, the TIME parameter indicates how long the SQL statement is executed over the connection.
  • If the value of the COMMAND parameter is Sleep, the TIME parameter indicates how long the connection remains idle.
  | | STATE | This parameter is meaningless and is always empty. | | INFO |
  • If the value of the COMMAND parameter is Query, the INFO parameter indicates the content of the SQL statement that is being executed over the connection.
    **Note** If the statement excludes the FULL keyword, only the first 30 characters of the SQL statement that is being executed are returned. If the statement includes the FULL keyword, only the first 1,000 characters of the SQL statement that is being executed are returned.
  • If the value of the COMMAND parameter is Sleep, the INFO parameter is meaningless and is empty.
  |

SHOW PHYSICAL_PROCESSLIST

You can execute the following statement to view information about all physical SQL statements that are being executed.

• Syntax

  SHOW PHYSICAL_PROCESSLIST
  

Note If an SQL statement is excessively long, the SQL statement is truncated in the results returned by the SHOW PHYSICAL_PROCESSLIST statement. You can execute the SHOW FULL PHYSICAL_PROCESSLIST statement to query the complete SQL statement.

• Examples

  SHOW PHYSICAL_PROCESSLIST\G
  *************************** 1. row ***************************
             ID: 0-0-521414
           USER: tddl5
             DB: tddl5_00
        COMMAND: Query
           TIME: 0
          STATE: init
           INFO: show processlist
  *************************** 2. row ***************************
             ID: 0-0-521570
           USER: tddl5
             DB: tddl5_00
        COMMAND: Query
           TIME: 0
          STATE: User sleep
           INFO: /*DRDS /88.88.88.88/b67a0e4d8800000/ */ select sleep(1000)
  2 rows in set (0.01 sec)
  

Note

• The meaning of each column in the returned results is equivalent to that in the result returned by the SHOW PROCESSLIST statement in MySQL. For more information, see SHOW PROCESSLIST syntax.

• MySQL returns a number in the ID column for a physical connection, but a PolarDB-X instance returns a string in the ID column for a physical connection.