tencent cloud

TDSQL Boundless

LOGSERVICE_DD_TABLES

PDF
Focus Mode
Font Size
Last updated: 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)


Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback