Home PageApsaraDB for SelectDBUser GuideDeveloper GuideData queriesQuery termination
Search for Help Content

Query termination

Updated at: 2024-05-09 07:50
Product
Community

This topic describes the query termination feature provided by ApsaraDB for SelectDB to help you manage SQL queries.

Overview

Each query in ApsaraDB for SelectDB is running in a session connection. If you need to terminate a session connection, you can use the query termination feature provided by ApsaraDB for SelectDB.

Method

To terminate a session connection, execute the KILL statement. This way, the query that is running in the session connection is also terminated. To view the IDs of all session connections, run the SHOW PROCESSLIST command. You can also run the SELECT CONNECTION_ID() command to query the ID of the current session connection.

Syntax: 

KILL [CONNECTION | QUERY] processlist_id

Examples

  1. The following code shows an example on how to query the ID of the current session connection: 

SELECT connection_id();
+-----------------+
| connection_id() |
+-----------------+
| 48              |
+-----------------+
1 row in set (0.00 sec)

  1. The following code shows an example on how to query the IDs of all session connections: 

SHOW PROCESSLIST;
+------------------+------+------+--------------------+---------------------+----------+---------+---------+------+-------+-----------------------------------+---------------------------------------------------------------------------------------+
| CurrentConnected | Id   | User | Host               | LoginTime           | Catalog  | Db      | Command | Time | State | QueryId                           | Info                                                                                  |
+------------------+------+------+--------------------+---------------------+----------+---------+---------+------+-------+-----------------------------------+---------------------------------------------------------------------------------------+
| Yes              |   48 | root | 10.16.xx.xx:44834   | 2023-12-29 16:49:47 | internal | test | Query   |    0 | OK    | e6e4ce9567b04859-8eeab8d6b5513e38 | SHOW PROCESSLIST                                                                      |
|                  |   50 | root | 192.168.xx.xx:52837 | 2023-12-29 16:51:34 | internal |      | Sleep   | 1837 | EOF   | deaf13c52b3b4a3b-b25e8254b50ff8cb | SELECT @@session.transaction_isolation                                                |
|                  |   51 | root | 192.168.xx.xx:52843 | 2023-12-29 16:51:35 | internal |      | Sleep   |  907 | EOF   | 437f219addc0404f-9befe7f6acf9a700 | /* ApplicationName=DBeaver Ultimate 23.1.3 - Metadata */ SHOW STATUS                  |
|                  |   55 | root | 192.168.xx.xx:55533 | 2023-12-29 17:09:32 | internal | test | Sleep   |  271 | EOF   | f02603dc163a4da3-beebbb5d1ced760c | /* ApplicationName=DBeaver Ultimate 23.1.3 - SQLEditor <Console> */ SELECT DATABASE() |
|                  |   47 | root | 10.16.xx.xx:35678   | 2023-12-29 16:21:56 | internal | test | Sleep   | 3528 | EOF   | f4944c543dc34a99-b0d0f3986c8f1c98 | select * from test                                                                    |
+------------------+------+------+--------------------+---------------------+----------+---------+---------+------+-------+-----------------------------------+---------------------------------------------------------------------------------------+
5 rows in set (0.00 sec)

  1. If you terminate a running query, the returned result shows that the query is terminated. The following code shows an example: 

KILL QUERY 55;
Query OK, 0 rows affected (0.01 sec)

Previous: Data queriesNext: SQL blocking
  • On this page （1, O）
  • Overview
  • Method
  • Examples
Feedback
phone Contact Us

Chat now with Alibaba Cloud Customer Service to assist you in finding the right products and services to meet your needs.

alicare alicarealicarealicare