tidb
tidb copied to clipboard
Some statements may be too long and consume too much memory when using the Plan Cache
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
Insert statements with many placeholders will also consume too much memory!
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.