tidb 写入给给意见,见详情

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。

  • 【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

不好意思,没有太了解问题是什么,可否加一些背景、现象描述

试试batch insert呢?https://book.tidb.io/session1/chapter6/optimistic-txn.html

好的,谢谢

硬件都按照要求配置,写入性能太差

可以按照性能排查排查确认一下,可以在 AskTUG 搜索 “写慢“,按照思路排查