cherry-pick #38012 to release-6.3
You can switch your code base to this Pull Request by using git-extras:

# In tidb repo:
git pr https://github.com/pingcap/tidb/pull/38077

After apply modifications, you can push your change to this PR via:

git push git@github.com:ti-srebot/tidb.git pr/38077:release-6.3-16693f8cd2f6

What problem does this PR solve?

Issue Number: close #37768 #37974

Problem Summary:

What is changed and how it works?

I figure out that for Q17, the root cause of the issue is copr-cache #37768 (comment)

When paging is disabled, the copr cache admission check would check the copr request data size < 10M
When paging is enable, this check become useless because the data is much smaller.

I add a pagingTaskIdx and check if pagingTaskIdx is large, don't cache the data.

Check List

Tests

• Unit test
• Integration test

I'll run the TPCH bench bot to verify the change work.

• Manual test (add detailed scripts or steps below)
• No code

Side effects

• Performance regression: Consumes more CPU
• Performance regression: Consumes more Memory
• Breaking backward compatibility

Documentation

• Affects user behaviors
• Contains syntax changes
• Contains variable changes
• Contains experimental features
• Changes MySQL compatibility

Release note

Please refer to Release Notes Language Style Guide to write a quality release note.

None