Updated on 2022-12-08 GMT+08:00

SHOW PHYSICAL PROCESSLIST

Command Format 1:

show physical processlist: Displays the processes that run on the associated RDS DB 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.

The command output is as follows:

Figure 1 Command output

Output details:

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

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

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

type:master: indicates that the associated DB instance is the primary type, and readreplica indicates that the associated DB instance is the read-only type.

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

Command Format 3:

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