ON DUPLICATE KEY UPDATE 插入慢

我直接在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