Updated on 2023-10-09 GMT+08:00

SHOW TOPOLOGY

Command Format:

It is used to view physical tables corresponding to a specified logical table.

show topology from <table_name>

Output Details:

Rds_instance_id: indicates the ID of the RDS instance.

HOST: indicates the IP address of the RDS instance.

PORT: indicates the port number of the RDS instance.

DATABASE: indicates the physical database in the RDS instance.

TABLE: indicates the physical table.

ROW_COUNT: indicates the estimated number of data entries in each physical table. The value is obtained from information_schema.TABLES.