dm icon indicating copy to clipboard operation
dm copied to clipboard

Filter delete DML will increase QPS?

Open lance6716 opened this issue 4 years ago • 1 comments

at an user's scenario, some range deletion mixed with INSERT and UPDATE happened on upstream. When we filter out delete DML, downtream QPS increased. Don't know why deleting one row is slower than insert/update one row.

lance6716 avatar Jun 02 '21 09:06 lance6716

maybe the DELETE and other SQL access totally different TiKV regions, after filtering these're less region involved.

lance6716 avatar Jun 02 '21 09:06 lance6716