Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 请问set global sql_mode = ‘’;是存储在哪个配置文件里了？
|
username: Hacker_7b2KWuuo
I executed the command set global sql_mode = '';, can you tell me which configuration file it is stored in? Because I found that even if I restart the TiDB cluster, this parameter persists.
Check if there is a table named mysql.global_variables.
TiDB supports modifying the
sql_modesystem variable at the session or global scope.
- Modifications to global scope variables will take effect on other servers in the cluster after being set, and the changes will remain effective after a restart. Therefore, you do not need to change the
sql_modevalue on each TiDB server.- Modifications to session scope variables will only affect the current session after being set, and the changes will disappear after a restart.
If you want to check the current sql_mode, simply use
SHOW GLOBAL VARIABLES LIKE ‘sql_mode’;
Got it, I haven’t really paid attention to where it’s stored usually.
The official documentation describes that “some variables with the GLOBAL scope will be persisted to the TiDB cluster,” which means they will be stored in TiKV. 系统变量 | PingCAP 文档中心
System parameters are stored in TiKV. If you only want the session to take effect, you can execute:
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: set session sql_mode = '';
Write to TiKV, specifically in the mysql.global_variables table.
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: 
|
username: