Yury Gerzhedovich created IGNITE-21080:
------------------------------------------
Summary: Improve of calculation cache sizes for SQL engine
Key: IGNITE-21080
URL: https://issues.apache.org/jira/browse/IGNITE-21080
Project: Ignite
Issue Type: Bug
Components: sql
Reporter: Yury Gerzhedovich
As of now we use hardcoded constants for our internal caches, it looks wrong.
These constants for first glance shouldn't be configured by user, but we could
use calculated estimated size.
Let't make the improvement:
||Constant||Proposed calculation||
|SqlQueryProcessor#PARSED_RESULT_CACHE_SIZE |SqlQueryProcessor#PLAN_CACHE_SIZE
*3|
|ExecutionServiceImpl#CACHE_SIZE|SqlQueryProcessor#PLAN_CACHE_SIZE * 3|
|SqlQueryProcessor#TABLE_CACHE_SIZE|number of tables * 2|
|SqlQueryProcessor#SCHEMA_CACHE_SIZE|as of now used for two caches, need to use
TABLE_CACHE_SIZE for table cache, and keep as is for catalog versions.|
| | |
We could introduce recreate caches for significant change amount of tables in a
cluster.
-
-
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
