文档勘误,系统变量页面

文档错误,请按照下方模板反馈

  • 问题分类:更新不及时、描述错误、代码错误、参数错误、链接错误、错别字
  • 出现的页面:链接+截图
  • 出现的错误:

系统变量页面增加了【是否受 Hint SET_VAR 控制】说明项,但有些参数的标记有误,请确认。

https://docs.pingcap.com/zh/tidb/v7.4/system-variables#tidb_enable_new_cost_interface-从-v620-版本开始引入
tidb_enable_new_cost_interface
是否受 Hint SET_VAR 控制:是 → 否

mysql> select /*+ set_var(tidb_enable_new_cost_interface=1) */ @@tidb_enable_new_cost_interface;
+----------------------------------+
| @@tidb_enable_new_cost_interface |
+----------------------------------+
|                                1 |
+----------------------------------+
1 row in set, 1 warning (0.00 sec)

Warning (Code 3637): Variable 'tidb_enable_new_cost_interface' might not be affected by SET_VAR hint.

https://docs.pingcap.com/zh/tidb/v7.4/system-variables#tidb_last_ddl_info-从-v600-版本开始引入
tidb_last_ddl_info
是否受 Hint SET_VAR 控制:是 → 否

mysql> select /*+ set_var(tidb_last_ddl_info=1) */ @@tidb_last_ddl_info;
+--------------------------+
| @@tidb_last_ddl_info     |
+--------------------------+
| {"query":"","seq_num":0} |
+--------------------------+
1 row in set, 2 warnings (0.00 sec)

Warning (Code 3637): Variable 'tidb_last_ddl_info' might not be affected by SET_VAR hint.
Warning (Code 1238): Variable 'tidb_last_ddl_info' is a read only variable

https://docs.pingcap.com/zh/tidb/v7.4/system-variables#tidb_isolation_read_engines-从-v40-版本开始引入
tidb_isolation_read_engines
是否受 Hint SET_VAR 控制:否 → 是

mysql> select /*+ set_var(tidb_isolation_read_engines=tikv) */ @@tidb_isolation_read_engines;
+-------------------------------+
| @@tidb_isolation_read_engines |
+-------------------------------+
| tikv                          |
+-------------------------------+
1 row in set (0.00 sec)

是否受 Hint SET_VAR 控制:否 → 是
mpp_exchange_compression_mode
tidb_allow_fallback_to_tikv
tiflash_fastscan
tiflash_fine_grained_shuffle_stream_count
tiflash_fine_grained_shuffle_batch_size
这几个参数的相关pr
https://github.com/pingcap/tidb/pull/47258
planner: change SET_VAR behavior for non-verified vars and add some var #47258
https://github.com/pingcap/tidb/pull/47609
sessionctx: fix var typo #47609

@Billmay表妹 PTAL

你提 PR 了吗?

对哦,我直接提pr吧。

raise the pr:
cn:
https://github.com/pingcap/docs-cn/pull/15207
en:
https://github.com/pingcap/docs/pull/15059

此话题已在最后回复的 60 天后被自动关闭。不再允许新回复。