tencent cloud

TDSQL Boundless

LOGSERVICE_DD_TABLES

PDF
Mode fokus
Ukuran font
Terakhir diperbarui: 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)


Bantuan dan Dukungan

Apakah halaman ini membantu?

masukan