功能
INFORMATION_SCHEMA.PERSIST用于展示持久化到 MC 侧的 variables。字段说明
字段名 | 类型 | 描述 |
VARIABLE_NAME | varchar(64) | 变量名字。 |
VARIABLE_VALUE | varchar(1024) | 变量值。 |
示例
可以通过
SELECT 或者 SHOW 查询持久化到 MC 侧的变量。tdsql>SELECT * FROM INFORMATION_SCHEMA.PERSIST;+-------------------------+----------------+| VARIABLE_NAME | VARIABLE_VALUE |+-------------------------+----------------+| tdstore_deadlock_detect | ON || tdsql_lock_wait_timeout | 50 |+-------------------------+----------------+2 rows in set (0.01 sec)tdsql>SHOW PERSIST VARIABLES;+-------------------------+-------+| Variable_name | Value |+-------------------------+-------+| tdstore_deadlock_detect | ON || tdsql_lock_wait_timeout | 50 |+-------------------------+-------+2 rows in set (0.00 sec)
