我直接在tibd-server本机执行sql,发现了一个规律,在业务并发插入的时候,大部分还是比较快的,0.02秒左右就能执行完成。但是偶尔出现插入慢
执行过程:
id task estRows operator info actRows execution info memory disk
Insert_1 root 0 N/A 0 time:329.9ms, loops:1, prepare: 313.4ms, check_insert: {total_time: 16.5ms, mem_insert_time: 175.2µs, prefetch: 16.3ms, rpc:{BatchGet:{num_rpc:3, total_time:18.3ms}, total_process_time: 1ms, total_wait_time: 17ms, scan_detail: {total_process_keys: 4, total_process_keys_size: 845, total_keys: 6, rocksdb: {delete_skipped_count: 0, key_skipped_count: 0, block: {cache_hit_count: 61, read_count: 1, read_byte: 15.9 KB}}}}}, commit_txn: {prewrite:4.49ms, region_num:2, write_keys:6, write_byte:846} 6.59 KB N/A