TiDB configuration

pd.toml

# PD Configuration.

[log]
level = "info"

[replication]
max-replicas = 3
location-labels = ["failure-domain.beta.kubernetes.io/region", "failure-domain.beta.kubernetes.io/zone", "kubernetes.io/hostname"]

[dashboard]
internal-proxy = true
enable-telemetry = false

tidb.toml

# TiDB Configuration.

# Whether new collations are enabled, as indicated by its name, this configuration entry take effect ONLY when a TiDB cluster bootstraps for the first time.
new_collations_enabled_on_first_bootstrap = true

# When enabled, usage data (for example, instance versions) will be reported to PingCAP periodically for user experience analytics.
# If this config is set to `false` on all TiDB servers, telemetry will be always disabled regardless of the value of the global variable `tidb_enable_telemetry`.
# See PingCAP privacy policy for details: https://pingcap.com/en/privacy-policy/
enable-telemetry = false

[log]
level = "info"

[performance]
# Max CPUs to use, 0 use number of CPUs in the machine.
max-procs = 0

# Set keep alive option for tcp connection.
tcp-keep-alive = true

tikv.toml

log-level = "info"

[readpool.storage]
## Whether to use the unified read pool to handle storage requests.
use-unified-pool = true

[readpool.coprocessor]
## Whether to use the unified read pool to handle coprocessor requests.
use-unified-pool = true

[server]
grpc-concurrency = 2

[raftstore]
apply-pool-size = 1
store-pool-size = 1

[rocksdb]
max-background-jobs = 8
max-sub-compactions = 2

[rocksdb.defaultcf]
soft-pending-compaction-bytes-limit = "1024GB"
hard-pending-compaction-bytes-limit = "1024GB"
level0-slowdown-writes-trigger = 64
level0-stop-writes-trigger = 128
max-write-buffer-number = 10

[rocksdb.writecf]
max-write-buffer-number = 10
level0-slowdown-writes-trigger = 64
level0-stop-writes-trigger = 128
soft-pending-compaction-bytes-limit = "1024GB"
hard-pending-compaction-bytes-limit = "1024GB"

[rocksdb.lockcf]
write-buffer-size = "128MB"
max-write-buffer-number = 10
level0-slowdown-writes-trigger = 64
level0-stop-writes-trigger = 128

TiFlash 默认配置