tidb icon indicating copy to clipboard operation
tidb copied to clipboard

Some statements may be too long and consume too much memory when using the Plan Cache

Open Reminiscent opened this issue 2 years ago • 1 comments

Enhancement

Some queries may be too long and consume too much memory when using the Plan Cache. For example, in with large lists. For a single query that consumes too much memory, we need to skip caching such queries

Reminiscent avatar May 23 '22 06:05 Reminiscent

Insert statements with many placeholders will also consume too much memory! Screen Shot 2022-09-21 at 11 16 15 TiDB turns plan cache enabled by default in 6.1, many customers met this issue. I think we should limit the condition of the number of placeholders for each SQL in plan cache.

jackysp avatar Sep 21 '22 03:09 jackysp