Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.
Original topic: TiDB-V3版本如何在线修改sync-log
I deployed version 3 using Ansible, and the current performance is relatively low, so I’m considering turning off sync-log. How can I change it online? I have already set this value to false in the tikv.toml configuration file. How can I make it take effect? Do I need to restart the TiKV nodes?
Modified the configuration file, and need to restart the TiKV nodes in the TiDB cluster to make the configuration changes take effect.
You can either restart or reload.
Modify configuration reload
I don’t recommend using this configuration because it has been disabled in the new version. Only synchronous writing is allowed.
There are still people using the V3 version? The official team stopped maintaining this version a long time ago. I strongly recommend that you quickly research and arrange for an upgrade. The performance and stability of the higher versions will definitely give you a pleasant surprise.
It’s normal, as long as it’s stable, you can keep using it. We recently upgraded our last customer using version 3 to version 6 because the maintenance cost was too high, and version 3 doesn’t support tiup 
Yes, without using tiup, the maintenance cost is very high.
The sync-log parameter cannot be changed in versions after v3.0; it has been fixed.
It is not recommended to close it.
I can understand him. When using a mechanical hard drive in the past, the IO performance was particularly poor. If not turned off, the IO would be maxed out, causing the system to be sluggish. After turning it off, the system would be much faster.
Modify the configuration file and reload.
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.