KILL

You can execute the KILL statement to kill an SQL thread that is running on a PolarDB-X instance.

Syntax

You can kill an SQL thread by using the following methods:

  • Execute the following statement to kill the logical and physical SQL threads of a connection, and then close the connection:

    KILL PROCESS_ID
    

Note

  • You can execute the SHOW [FULL] PROCESSLIST statement to query the value of PROCESS_ID.

  • PolarDB-X does not support KILL QUERY.

  • Execute the following statement to kill a specified physical SQL thread:

    KILL 'PHYSICAL_PROCESS_ID'
    

Examples

  KILL '0-0-521570'; 
  Query OK, 0 rows affected (0.01 sec)

Note

  • You can execute the SHOW PHYSICAL_PROCESS_ID statement to query the value of PHYSICAL_PROCESS_ID.

  • The value of PHYSICAL_PROCESS_ID is a string instead of a numeric value. Therefore, you must enclose the value of PHYSICAL_PROCESS_ID in single quotation marks (').

  • Kill all physical SQL threads that are running on a PolarDB-X instance.

    KILL 'ALL'
    

results matching ""

    No results matching ""