TIDB 4.0.7 修改lower_case_table_names=1不生效

请选择具体子# WARNING: This file is auto-generated. Do not edit! All your modification will be overwritten!

You can use ‘tiup cluster edit-config’ and ‘tiup cluster reload’ to update the configuration

All configuration items you want to change can be added to:

server_configs:

tidb:

aa.b1.c3: value

aa.b2.c4: value

new_collations_enabled_on_first_bootstrap = true
lower_case_table_names = 1

[binlog]
enable = false
ignore-error = false

[log]
slow-threshold = 300版块发表问答帖子,多谢。

tiup cluster restart tidb-hytest -R tidb

mysql> show variables like ‘%lower_case%’;
±-----------------------±------+
| Variable_name | Value |
±-----------------------±------+
| lower_case_file_system | 1 |
| lower_case_table_names | 2 |
±-----------------------±------+
2 rows in set (0.01 sec)

重启后还是2, 还需要哪里要配置。

目前 TiDB 只支持将该选项的值设为 2,即按照大小写来保存表名,按照小写来比较(不区分大小写)。
https://docs.pingcap.com/zh/tidb/stable/tidb-configuration-file#lower-case-table-names

那OGG数据同步到TIDB,怎么配置这个参数值。

可以搜一下 lower_case_table_names 会有几个帖子,有说过 ogg 都是配置的 1