Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.Original topic: 禁用tiflash
|
username: 等一分钟
【TiDB Usage Environment】Production Environment
【TiDB Version】6.1.0
set session tidb_isolation_read_engines=‘tidb,tikv’;
This can only disable TiFlash at the session level. Is there a way to disable TiFlash globally?
After using TiFlash, the script actually consumes more memory in the TiDB server.
You need to edit the configuration file parameter isolation-read.engines.
Configuration items related to isolation read.
|
username: 
|
username: 
|
username: 
|
username: 
|
username: enginesModify the configuration file, and then restart the tidb_server node, right?
I tested it, and after restarting TiDB, the changes were not successful. I don’t know why.
Is the parameter name written incorrectly?
Is it supposed to be isolation-read?
I made a mistake, it’s isolation-read.engines. Just reload after changing it.
Has anyone encountered that after adding TiFlash, the memory usage actually increased?
TiFlash, just by looking at the name, follows the approach of using more memory and increasing data caching to speed up performance.
Previously consulted with the official technical team, and they said that adding all the tables in SQL to TiFlash would save more memory.
Directly use ALTER DATABASE database_name SET TIFLASH REPLICA 0 to remove TiFlash replicas, so queries will no longer go to TiFlash.
|
username: 
|
username: 
|
username: 
|
username: 
|
username: