How to cancel the setting after modifying the Engine isolation according to the manual when running queries on TiFlash. Previously, the Engine isolation was modified to TiFlash

Translated
1

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

Original topic: 设置查询运行tiflash时，按照手册修改了Engine 隔离，现在想要取消这个设置，应该怎么做呢。前面修改Engine 隔离为tiflash了。

| username: TiDBer_NUP2nMAg

After setting: set SESSION tidb_isolation_read_engines = "tiflash";
Then restoring with the command: set SESSION tidb_isolation_read_engines = "tikv, tidb, tiflash";

After running the statement: alter table test.test set tiflash replica 1;
Query: select * from information_schema.tiflash_replica where table_schema = 'test';
Shows that the AVALIABLE value for test.test is 0.

2
| username: 我是咖啡哥 | Original post link

You set it at the session level, which does not affect other sessions.
These two are not directly related, right?
It should be about why “alter table test.test set tiflash replica 1;” did not take effect.

3
| username: tidb菜鸟一只 | Original post link

The two steps do not conflict. The engine setting above has already been successfully restored, but the replica below has not been synchronized successfully. First, check if the TiFlash node is functioning properly. If it is, wait a bit to see if the synchronization of the replica is just a bit slow.

4
| username: system | Original post link

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