为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- 【TiDB 版本】:v4.0.0
- 【问题描述】:写入性能低下
服务器配置
服务器类型
云盘
tidb 以及 tikv 导出内容
tidb-test-TiDB_2021-01-19T03_56_51.493Z.json (1.4 MB) tidb-test-TiKV-Details_2021-01-19T03_58_36.426Z.json (5.1 MB)
topology.yaml 文件内容
global:
user: “root”
ssh_port: 22
deploy_dir: “/home/tidb/tidb-deploy”
data_dir: “/home/tidb/tidb-data”
monitored:
node_exporter_port: 9100
blackbox_exporter_port: 9115
server_configs:
tidb:
tikv-client.grpc-connection-count: 32
token-limit: 10000
tikv:
readpool.storage.use-unified-pool: false
readpool.coprocessor.use-unified-pool: true
raftdb.defaultcf.compression-per-level: [“no”, “no”, “lz4”, “lz4”, “lz4”, “zstd”, “zstd”]
raftdb.defaultcf.write-buffer-size: 1024MB
rocksdb.max-background-flushes: 4
rocksdb.max-background-jobs: 28
rocksdb.max-sub-compactions: 6
rocksdb.writable-file-max-buffer-size: 20MB
rocksdb.writecf.compression-per-level: [“no”, “no”, “lz4”, “lz4”, “lz4”, “zstd”, “zstd”]
rocksdb.defaultcf.compression-per-level: [“no”, “no”, “lz4”, “lz4”, “lz4”, “zstd”, “zstd”]
rocksdb.writecf.write-buffer-size: 1024MB
storage.scheduler-worker-pool-size: 8
pd:
schedule.leader-schedule-limit: 4
schedule.region-schedule-limit: 2048
schedule.replica-schedule-limit: 64
pd_servers:
- host: 172.16.86.221
- host: 172.16.86.220
- host: 172.16.86.219
tidb_servers: - host: 172.16.86.221
tikv_servers: - host: 172.16.86.217
- host: 172.16.86.216
- host: 172.16.86.218
monitoring_servers:
- host: 172.16.86.217
grafana_servers: - host: 172.16.86.216
alertmanager_servers: - host: 172.16.86.218