autoid cache 1 impact the row id allocation performance

[tiancaiamao]

Enhancement

When I'm testing the performance of #38442

autoid.txt

I use this table schema:

create table test (id int unsigned key nonclustered auto_increment) shard_row_id_bits=4 auto_id_cache 1;

It avoids the sequent rowid caused tikv hotspot issue.
But I find the flamegraph abnormal:

Row ID allocating takes too much resource!
I figure out that cause by the side effect of the auto_id_cache = 1 setting.