How to Modify sync-log Online in TiDB V3 Version

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

Original topic: TiDB-V3版本如何在线修改sync-log

| username: Ann_ann

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?

| username: Billmay表妹 | Original post link

Set sync_log=false

| username: Billmay表妹 | Original post link

Specifically, see:

| username: 大飞哥online | Original post link

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.

| username: Fly-bird | Original post link

Modify configuration reload

| username: Kongdom | Original post link

:joy: I don’t recommend using this configuration because it has been disabled in the new version. Only synchronous writing is allowed.

| username: Jellybean | Original post link

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.

| username: Kongdom | Original post link

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 :yum:

| username: Ann_ann | Original post link

Restarted sequentially.

| username: 大飞哥online | Original post link

Yes, without using tiup, the maintenance cost is very high.

| username: 大飞哥online | Original post link

The sync-log parameter cannot be changed in versions after v3.0; it has been fixed.

| username: 像风一样的男子 | Original post link

It is not recommended to close it.

| username: Kongdom | Original post link

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.

| username: andone | Original post link

Modify the configuration file and reload.

| username: system | Original post link

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