pingcap / pingcap/tidb

Variables related to DDL are not auto adjusting

Open
#33,723 0 comments 0 reactions 0 assignees View on GitHub
type/enhancement
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Enhancement

The variables related to DDL are not being adjusted on the size of the machine (CPU cores, etc)

```
sql> SHOW VARIABLES LIKE 'tidb_ddl%';
+----------------------------+--------------+
| Variable_name | Value |
+----------------------------+--------------+
| tidb_ddl_error_count_limit | 512 |
| tidb_ddl_reorg_batch_size | 256 |
| tidb_ddl_reorg_priority | PRIORITY_LOW |
| tidb_ddl_reorg_worker_cnt | 4 |
+----------------------------+--------------+
4 rows in set (0.0017 sec)
```

This means that manual tuning is needed to get better DDL performance

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.