LOGSERVICE_MYSQL_UNSUPPORTED_TABLE is designed to quickly query whether tables not supported by the disaster recovery feature exist in the current instance.Field Name | Type | Description |
table_type | varchar(64) | The table type is not supported. |
table_name | longtext | The names of tables not supported by the disaster recovery feature |
tdsql > SELECT * FROM information_schema.LOGSERVICE_MYSQL_UNSUPPORTED_TABLE\\G*************************** 1. row ***************************table_type: hidden_pk_tabletable_name: test.log_events1 row in set (0.02 sec)
test.log_events is not supported by the disaster recovery feature because it is a hidden primary key table (hidden_pk_table). It is recommended to add explicit primary keys to such tables to ensure they can be synchronized normally. If the query returns no results, it indicates that all current tables are compatible with the disaster recovery feature.피드백