How to modify tidb_enable_enhanced_security? What impact does the modification have on the existing cluster?

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: tidb_enable_enhanced_security 如何修改?修改后对现有集群那些影响?

| username: JOJO_DB

[TiDB Usage Environment] Production Environment / Testing / PoC
[TiDB Version]
[Reproduction Path] What operations were performed that led to the issue
[Encountered Issue: Issue Phenomenon and Impact]
[Resource Configuration]
[Attachments: Screenshots/Logs/Monitoring]
The current version is 5.3.0, and I want to enable the read-only function on a schedule. I would like to ask how to enable security enhancements currently, and if there are any other better solutions? Thank you.

| username: 大飞哥online | Original post link

tidb_enable_enhanced_security=OFF (default)
In the TiDB configuration file under [security], add enable-sem=true, save, and then restart TiDB.

| username: 大飞哥online | Original post link

There is an impact. Inaccurate statistics may affect the query execution plan and performance.

If the table is frequently subjected to DML, you should execute ANALYZE in a timely manner to avoid pseudo-statistics.

| username: dba远航 | Original post link

Be cautious after enabling safe mode to avoid connection anomalies.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.