Record the time consuming of memory operation of Insert Executor in Runtime Information

[SunRunAway]

Description

Development Task

INSERT IGNORE from a table of 300,000 rows,

INSERT IGNORE INTO t SELECT * FROM t1

And we got the following slow query log.

Unfortunately, with this log, we have no clue where the time is consumed.

Then we must investigate this problem by using go profile or trace.

With the above go profile graph, I propose to add two extra time-consuming sections in runtime information and trace span,

1. Check Duplicate, including getKeysNeedCheck and txn.Get from memory buffer, but except the RPC time.
2. Add Records, for the memory operation of memtable.

SIG slack channel

#sig-exec

Score

• 300

Mentor

• @qw4990

[time-and-fate]

/label sig/execution

[crazycs520]

@jyz0309 PTAL

[jyz0309]

/pick-up

[ti-challenge-bot]

Pick up success.