dataroaring opened a new issue, #16930: URL: https://github.com/apache/doris/issues/16930
### Search before asking - [X] I had searched in the [issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no similar issues. ### Description pagecache is very important for doris to support high concurrent queries, now it uses a simple LRU algorithm. There are some drawbacks. - For Olap, the simple LRU algorithm does not work very well, e.g. a query which scan a lot data can eliminate hot data. - The memory which can be used by page cache is configured at a be level, however users does not know how many is good enough. Doris can provide some metrics related to table and cache, then users can set the value according to metrics. ### Solution - 2-queue lru may be a good candidate. - providing some metrics users can understand easily. ### Are you willing to submit PR? - [ ] Yes I am willing to submit a PR! ### Code of Conduct - [X] I agree to follow this project's [Code of Conduct](https://www.apache.org/foundation/policies/conduct) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
