Updated on 2022-09-16 GMT+08:00

SHOW PHYSICAL PROCESSLIST

Command Format 1:

show physical processlist: Displays the processes that run on the associated RDS instance.

Command Format 2:

show physical processlist with info: Filters out the data whose info is empty from the result set of command 1 and displays only the data whose info is not empty.

Command Output

Figure 1 Command execution effect

Output Details:

ip: indicates the IP address of the associated RDS instance.

port: indicates the port number of the associated RDS instance.

instance id: indicates the ID of the associated RDS instance.

type:master: indicates that the associated instance is a primary instance, and readreplica indicates that the associated instance is a read replica.

Columns after column type indicate the information about processes running on the associated RDS instance. Such information is the same as the output of command show processlist executed on the associated RDS instance.

Command Format 3:

kill physical physical_thread_id@rds_ip:rds_port: kills the execution thread on the associated RDS instance.

This feature is available only in kernel 3.0.1 or later.