What command can be used to check if the tikv sync_log parameter is currently disabled? Thank you

Translated
1

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

Original topic: tikv sync_log 参数用什么命令可以查看当前参数是否关闭呢？ 谢谢

| username: TiDBer_mvrpvfaN

How is the write performance under the strictest sync-log = true data availability mode?

Generally speaking, enabling sync-log will result in a performance loss of about 30%. For performance when sync-log is disabled, please refer to the TiDB Sysbench Performance Test Report.

show global VARIABLES like ‘%sync-log%’;
show config where name like ‘%sync-log%’;
I tried using the above two commands to check the parameter situation, but I did not find the parameter.

2
| username: Kongdom | Original post link

What version?

3
| username: TiDBer_mvrpvfaN | Original post link

5.7.25-TiDB-v6.0.0

4
| username: Kongdom | Original post link

Starting from version 5.0, manual configuration is no longer allowed, and the default is set to true.

  • The raftstore.sync-log configuration item has been removed. By default, data will be forcibly written to disk. If raftstore.sync-log was explicitly disabled before, it will be forcibly set to true after successfully upgrading to version 5.0.
5
| username: TiDBer_mvrpvfaN | Original post link

Hello, does this mean that the sync_log of this 5.7.25-TiDB-v6.0.0 TiKV can no longer be turned off?

6
| username: Kongdom | Original post link

Yes.
Additionally, this is a configuration file setting, not a system parameter.

7
| username: TiDBer_mvrpvfaN | Original post link

Okay, thank you, but I still want to try if this method is feasible.
I understand that I modify the configuration file through the command
tiup cluster edit-config tidb-test
in the configuration file as follows:

image
image1268×970 86.6 KB

Then, tiup cluster reload tidb-test
to make the configuration parameters take effect.

8
| username: Kongdom | Original post link

The location is incorrect, raftstore.sync-log: false