Using TiDB has brought us a number of wins. Firstly, it is very stable at its core, which is very important to us. Another thing we like is the performanceLianghong Xu/ Senior Engineering Manager, PinterestWatch the Video We decided that TiDB architecture layering a SQL layer over a key-...
(Milliseconds) tidb_slow_log_threshold = 300 # tidb_record_plan_in_slow_log is used to enable record query plan in slow log. # 0 is disable. 1 is enable. tidb_record_plan_in_slow_log = 1 # The maximum permitted number of simultaneous client connections. When the value is 0, the ...
max-snapshot-count (https://docs.pingcap.com/tidb/stable/pd-configuration-file#max-snapshot-count) : when the number of snapshots that a single store receives or sends meet the limit, it will never be choosed as a source or target store max-pending-peer-count (https://docs.pingcap.com...
max-snapshot-count ( https://docs.pingcap.com/tidb/stable/pd-configuration-file#max-snapshot-count ) : when the number of snapshots that a single store receives or sends meet the limit, it will never be choosed as a source or target store max-pending-peer-count ( https://docs.pingcap...
Step2/Step3: use joint consensus to switch role // Step2: use joint consensus [2024/07/09 16:25:24.248 +08:00] [INFO] [operator_controller.go:732] ["send schedule command"] [region-id=142725] [step="use joint consensus, promote learner peer 166543143 on store 166543141 to voter, demot...
Migrate to MySQL 5.7 🌟mini_sql minisql 是一个轻量级的 sql wraper,方便做一些ORM不擅长的查询,并且可以防止 SQL 注入。之前只支持 PG 和 sqlite。Discourse 的代码依赖 minisql 的地方非常多,重写的话工作量巨大,patch mini_sql 来支持 MySQL 是能够迁移完成的一个重要步骤:https://github.com/discourse/...
Step2/Step3: use joint consensus to switch role // Step2: use joint consensus [2024/07/09 16:25:24.248 +08:00] [INFO] [operator_controller.go:732] ["send schedule command"] [region-id=142725] [step="use joint consensus, promote learner peer 166543143 on store 166543141 to voter, demot...
To specify the TiDB version and the number of instances of each component, run a command like this: tiup playground v8.5.1 --db 2 --pd 3 --kv 3 To view all available versions, runtiup list tidb. Start a new session to access the TiDB cluster endpoints: ...
最大内存使用量 ≈max-open-engines×write-buffer-size×max-write-buffer-number 降低table-concurrency+index-concurrency,使之低于max-open-engines。 重启tikv-importer来强制移除所有引擎文件 (默认值为./data.import/)。这样也会丢弃导入了一半的表,所以启动 TiDB Lightning 前必须清除过期的断点记录:tidb-lightni...
performance-tuning-practices: fix wrong number (pingcap#19125) Oct 15, 2024 pessimistic-transaction.md tikv config: add in memory pessismitic lock size limit config (pingca… Oct 18, 2024 pipelined-dml.md doc: batch processing overview and pipelined dml (pingcap#19818) Jan 8, 2025 placement-...