reduce get_snapshot_time
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
A simple insert SQL very slow, get_snapshot_time very high, what's this metric mean? why it become too high?
------------------------------------------------------------------------
{total:3.404s, region_id: 570227, store: ****:20160, tikv_wall_time: 3.4s,
scan_detail: {get_snapshot_time: 3.4s, rocksdb: {block: {cache_hit_count: 17}}}, write_detail: {store_batch_wait: 1.5ms, propose_send_wait: 0s, persist_log: {total: 1.98ms, write_leader_wait: 93ns, sync_log: 69.4µs, write_memtable: 40µs}, commit_log: 2.11ms, apply_batch_wait: 46.6µs, apply: {total:54.6µs, mutex_lock: 0s, write_leader_wait: 0s, write_wal: 6.61µs, write_memtable: 25.1µs}}} Commit_primary_rpc_detail:
{total:3.404s, region_id: 570227, store: ****:20160, tikv_wall_time: 3.4s, scan_detail: {get_snapshot_time: 3.4s, rocksdb: {block: {cache_hit_count: 17}}}, write_detail: {store_batch_wait: 1.5ms, propose_send_wait: 0s, persist_log: {total: 1.98ms, write_leader_wait: 93ns, sync_log: 69.4µs, write_memtable: 40µs}, commit_log: 2.11ms, apply_batch_wait: 46.6µs, apply: {total:54.6µs, mutex_lock: 0s, write_leader_wait: 0s, write_wal: 6.61µs, write_memtable: 25.1µs}}} Write_keys: 7 Write_size: 808 Prewrite_region: 7
Contributor guide
Assessment
This issue has not been assessed yet.