[
https://issues.apache.org/jira/browse/IGNITE-21080?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yury Gerzhedovich updated IGNITE-21080:
---------------------------------------
Description:
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.
was:
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.
-
-
> Improve of calculation cache sizes for SQL engine
> -------------------------------------------------
>
> Key: IGNITE-21080
> URL: https://issues.apache.org/jira/browse/IGNITE-21080
> Project: Ignite
> Issue Type: Improvement
> Components: sql
> Reporter: Yury Gerzhedovich
> Priority: Major
> Labels: ignite-3
>
> 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)
