Aurora MySQL–specific information_schema tables
Aurora MySQL has certain information_schema tables that are specific to Aurora.
information_schema.replica_host_status
The information_schema.replica_host_status table contains replication information. The columns that you can
use are shown in the following table. The remaining columns are for Aurora internal use only.
| Column | Data type | Description |
|---|---|---|
| CPU | double | The CPU percentage usage of the replica host. |
| IS_CURRENT | tinyint | Whether the replica is current. |
| LAST_UPDATE_TIMESTAMP | datetime(6) | The time the last update occurred. Used to determine whether a record is stale. |
| REPLICA_LAG_IN_MILLISECONDS | double | The replica lag in milliseconds. |
| SERVER_ID | varchar(100) | The ID of the database server. |
| SESSION_ID | varchar(100) | The ID of the database session. Used to determine whether a DB instance is a writer or reader instance. |
When a replica instance falls behind, the information queried from its information_schema.replica_host_status
table might be outdated. In this situation, we recommend that you query from the writer instance instead.
While the mysql.ro_replica_status table has similar information, we don't recommend that you use
it.