Does the parameter innodb_write_io_threads have an effect when used in TiDB?

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

Original topic: tidb使用innodb_write_io_threads这个参数有效果吗

| username: 舞动梦灵

I found that the default value is 4. If I modify this value in TiDB, will it take effect? I couldn’t find information about this parameter in the official documentation.

| username: TiDBer_jYQINSnf | Original post link

Useless, the underlying layer is not InnoDB.

| username: 舞动梦灵 | Original post link

I don’t think it’s useful either. Haha, does TiDB have similar parameters to improve concurrent writes?

| username: TiDBer_jYQINSnf | Original post link

Here are some optimizations.

| username: zhanggame1 | Original post link

Anything related to InnoDB is useless.

| username: zhanggame1 | Original post link

The official documentation has it
TiDB High Concurrency Write Best Practices | PingCAP Documentation Center

| username: 哈喽沃德 | Original post link

The innodb_write_io_threads parameter does not have a direct impact on TiDB. TiDB uses the TiKV distributed storage engine. If you need to adjust the performance parameters of the storage engine, you should focus on the configuration parameters related to TiKV or TiFlash.

| username: 舞动梦灵 | Original post link

Okay, thank you.

| username: zhang_2023 | Original post link

It’s just that the server layer is compatible with the MySQL protocol.

| username: system | Original post link

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