LOGSERVICE_DD_TABLES

最近更新时间:2025-11-18 10:10:23

我的收藏

功能

存储logservice回放解析 raft log 所需的表结构信息,并在logservice回放 DDL 的过程中对其中的表结构进行更新。

字段说明

字段名
类型
描述
sid
bigint unsigned
用于标识logservice的编号。
tindex_id
int unsigned
用于标识每个主表的 ID。
info
longtext
存储序列化之后的表结构元信息。

示例

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)