Help Center/ Distributed Database Middleware/ User Guide/ SQL Syntax/ Supported SQL Statements/ SHOW PHYSICAL PROCESSLIST
Updated on 2024-07-30 GMT+08:00
View PDF
Share

SHOW PHYSICAL PROCESSLIST

  • Command 1: returns all processes that run on the associated RDS instance.

    show physical processlist

  • Command 2: filters out the data records whose info is empty from result sets of command 1 and returns only the data records whose info is not empty.

    show physical processlist with info

    Command Output:

    Figure 1 Command execution effect

    Output Details:

    IP: indicates the IP address of the RDS instance.

    Port: indicates the port number of the RDS instance.

    Instance_id: indicates the ID of the RDS instance.

    Type:master: indicates that the RDS instance is a primary instance, and readreplica indicates that the RDS instance is a read replica.

    Columns after column Type provide information about processes running on the associated RDS instance. Such information is the same as the output of command show processlist when you execute it on the associated RDS instance.

  • Command 3: kills the execution thread on the associated RDS instance:

    kill physical <physical_thread_id>@<rds_ip>:<rds_port>

    <physical_thread_id>: indicates the ID of the execution thread on the associated RDS instance. You can obtain it from result sets of command 2.

    <rds_ip>: indicates the IP address of the associated RDS instance. You can obtain it from result sets of command 2.

    <rds_port>: indicates the port number of the associated RDS instance. You can obtain it from result sets of command 2.

  • This feature is available only in kernel 3.0.1 or later.
  • You need to log in to the DDM instance and run the preceding commands on it.
Parent topic: Supported SQL Statements