集群出现很多简单sql执行慢,示例为insert语句的慢日志明细,事务模式:悲观模式
官方文档各种线程都有调整,scheduler-worker-pool-size、apply-pool-size、store-pool-size涉及的参数都调整了!
大部分慢的都是prewrite阶段耗时高!
示例慢日志:
# Time: 2025-04-15T13:58:57.316742172+08:00
# Txn_start_ts: 457361781380088517
# User@Host:
# Conn_ID: 1843966761733305671
# Query_time: 0.422498159
# Parse_time: 0.000006488
# Compile_time: 0.000026679
# Rewrite_time: 0.000000759
# Optimize_time: 0.000014226
# Wait_TS: 0
# Prewrite_time: 0.420900196 Wait_prewrite_binlog_time: 0.000000295 Commit_time: 0.001249499 Get_commit_ts_time: 0.000231026 Slowest_prewrite_rpc_detail: {total:0.421s, region_
id: 731367814, store: 10.132.6.13:20171, tikv_wall_time: 420.3ms, scan_detail: {get_snapshot_time: 14.5µs, rocksdb: {block: {}}}, write_detail: {store_batch_wait: 55.5µs, propo
se_send_wait: 0s, persist_log: {total: 49.3µs, write_leader_wait: 53ns, sync_log: 29.1µs, write_memtable: 1.11µs}, commit_log: 388.4µs, apply_batch_wait: 386.4ms, apply: {total
:1.91ms, mutex_lock: 0s, write_leader_wait: 281.1µs, write_wal: 0s, write_memtable: 572.9µs}}} Commit_primary_rpc_detail: {total:0.421s, region_id: 731367814, store: 10.132.6.1
3:20171, tikv_wall_time: 420.3ms, scan_detail: {get_snapshot_time: 14.5µs, rocksdb: {block: {}}}, write_detail: {store_batch_wait: 55.5µs, propose_send_wait: 0s, persist_log: {
total: 49.3µs, write_leader_wait: 53ns, sync_log: 29.1µs, write_memtable: 1.11µs}, commit_log: 388.4µs, apply_batch_wait: 386.4ms, apply: {total:1.91ms, mutex_lock: 0s, write_l
eader_wait: 281.1µs, write_wal: 0s, write_memtable: 572.9µs}}} Write_keys: 46 Write_size: 3860 Prewrite_region: 45
帮忙分析下从什么维度入手,我再补充监控!