tencent cloud

TDSQL Boundless

LOGSERVICE_DD_TABLES

Download
포커스 모드
폰트 크기
마지막 업데이트 시간: 2026-02-10 11:03:02

Function

Stores the table schema information required for logservice to replay parsing raft logs, and updates the table schema during the logservice process of replaying DDL.

Field Description

Field Name
Type
Description
sid
bigint unsigned
Stores the identifier for logservice.
tindex_id
int unsigned
The ID for each primary table.
info
longtext
Stores the serialized metadata of the table schema.

Examples

tdsql> DESC sys.logservice_dd_tables;
+-----------+-----------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+-----------------+------+-----+---------+-------+
| sid | bigint unsigned | NO | PRI | NULL | |
| tindex_id | int unsigned | NO | PRI | NULL | |
| info | longtext | YES | | NULL | |
+-----------+-----------------+------+-----+---------+-------+

tdsql> SELECT * FROM sys.logservice_dd_tables WHERE tindex_id = 10029 \\G
*************************** 1. row ***************************
sid: 29473053092085985
tindex_id: 10029
info: {"mysqld_version_id":80026,"dd_version":80023,"sdi_version":80019,"dd_object_type":"Table","dd_object":{"name":"t2","tindex_id":10029,"schema_version":1,"schema_status":0,"mysql_version_id":80026,"created":20250902021912,"last_altered":20250902021912,"hidden":1,"options":"avg_row_length=0;explicit_encryption=0;key_block_size=0;keys_disabled=0;pack_record=0;stats_auto_recalc=0;stats_sample_pages=0;","columns":[{"name":"c1","type":4,"is_nullable":false,"is_zerofill":false,"is_unsigned":false,"is_auto_increment":false,"schema_version":1,"is_virtual":false,"hidden":1,"ordinal_position":1,"char_length":11,"numeric_precision":10,"numeric_scale":0,"numeric_scale_null":false,"datetime_precision":0,"datetime_precision_null":1,"has_no_default":true,"default_value_null":false,"init_default_value_null":true,"srs_id_null":true,"srs_id":0,"default_value":"AAAAAA==","init_default_value":"","default_value_utf8_null":true,"default_value_utf8":"","default_option":"","update_option":"","comment":"","generation_expression":"","generation_expression_utf8":"","options":"interval_count=0;","se_private_data":"","engine_attribute":"","secondary_engine_attribute":"","column_key":2,"column_type_utf8":"int","elements":[],"collation_id":8,"is_explicit_collation":false},{"name":"c2","type":4,"is_nullable":true,"is_zerofill":false,"is_unsigned":false,"is_auto_increment":false,"schema_version":1,"is_virtual":false,"hidden":1,"ordinal_position":2,"char_length":11,"numeric_precision":10,"numeric_scale":0,"numeric_scale_null":false,"datetime_precision":0,"datetime_precision_null":1,"has_no_default":false,"default_value_null":true,"init_default_value_null":true,"srs_id_null":true,"srs_id":0,"default_value":"","init_default_value":"","default_value_utf8_null":true,"default_value_utf8":"","default_option":"","update_option":"","comment":"","generation_expression":"","generation_expression_utf8":"","options":"interval_count=0;","se_private_data":"","engine_attribute":"","secondary_engine_attribute":"","column_key":1,"column_type_utf8":"int","elements":[],"collation_id":8,"is_explicit_collation":false}],"schema_ref":"test2","autoinc_tindex_id":0,"hidden_pk_autoinc_tindex_id":0,"se_private_id":18446744073709551615,"engine":"ROCKSDB","last_checked_for_upgrade_version_id":0,"comment":"","se_private_data":"autoinc_version=1;create_data_obj_task_id=29473869991510193;distribution_policy_id=1;origin_db=test2;origin_table=t2;partition_policy_id=0;sync_table=0;","engine_attribute":"","secondary_engine_attribute":"","row_format":1,"partition_type":0,"partition_expression":"","partition_expression_utf8":"","default_partitioning":0,"subpartition_type":0,"subpartition_expression":"","subpartition_expression_utf8":"","default_subpartitioning":0,"indexes":[{"name":"PRIMARY","id":334,"tindex_id":10029,"hidden":false,"is_generated":false,"ordinal_position":1,"comment":"","options":"flags=0;","se_private_data":"create_data_obj_task_id=29473869991510193;distribution_policy_id=1;kv_format_version=1;","type":1,"algorithm":1,"is_algorithm_explicit":false,"is_visible":true,"engine":"ROCKSDB","engine_attribute":"","secondary_engine_attribute":"","elements":[{"ordinal_position":1,"length":4,"order":2,"hidden":false,"column_opx":0}]}],"foreign_keys":[],"check_constraints":[],"partitions":[],"collation_id":33,"extra_info":"{\\"version\\":3,\\"create_ts\\":0}"}}
1 row in set, 1 warning (0.00 sec)


도움말 및 지원

문제 해결에 도움이 되었나요?

피드백