tencent cloud

TDSQL Boundless

LOGSERVICE_MYSQL_UNSUPPORTED_TABLE

PDF
Modo Foco
Tamanho da Fonte
Última atualização: 2026-03-06 18:48:08

Function

LOGSERVICE_MYSQL_UNSUPPORTED_TABLE is designed to quickly query whether tables not supported by the disaster recovery feature exist in the current instance.

Field Description

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

Examples

tdsql > SELECT * FROM information_schema.LOGSERVICE_MYSQL_UNSUPPORTED_TABLE\\G
*************************** 1. row ***************************
table_type: hidden_pk_table
table_name: test.log_events
1 row in set (0.02 sec)
The above result indicates that the table 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.

Ajuda e Suporte

Esta página foi útil?

comentários