Different database projects may have different SQL dialects. 3.5.6 Limitations The SQL dialect translation of Apache ShardingSphere is experimental. Currently, only MySQL/PostgreSQL dialects can be automatically limits for the ZooKeeper containers {} governance.zookeeper.r es- ources.requests.memory The requested memory for the ZooKeeper containers ˋ 256Mi` governance.zookeepe r. resources.requests.cpu resources limits for the ShardingSphere‐Proxy containers {} c ompute.resources. requests.memory The requested memory for the ShardingSphere‐Proxy containers 2Gi compute.resourc es. requests.cpu The

dialects. 8.4. DB Gateway 42 Apache ShardingSphere document 8.4.6 Limitations The SQL dialect translation of Apache ShardingSphere is experimental. Currently, only MySQL/PostgreSQL dialects can be automatically above conditions are not met, the execution delay of SQL may not be significantly improved, and the memory pressure will be increased. Parameters rules: - !SHARDING tables: shardingAlgorithms: # .. variable JVM_OPTS Note: Support setting environment variable CGROUP_ MEM_ OPTS: used to set related memory parameters in the container environment. The default values in the script are: -XX:InitialRAMPercentage=80

Different database projects may have different SQL dialects. 3.5.6 Limitations The SQL dialect translation of Apache ShardingSphere is experimental. Currently, only MySQL/PostgreSQL dialects can be automatically ShardingSphere-Proxy 185 Note: Support setti ng envi ronment vari abl e CGROUP_ MEM_ OPTS: used to set rel ated memory paramet ers i n the contai ner envi ronment. The defaul t val ues i n the scri pt are: -XX:In limits for the ZooKeeper containers {} governance.zookeeper.r es- ources.requests.memory The requested memory for the ZooKeeper containers ˋ 256Mi` governance.zookeepe r. resources.requests.cpu

dialects. 8.4. DB Gateway 42 Apache ShardingSphere document 8.4.6 Limitations The SQL dialect translation of Apache ShardingSphere is experimental. Currently, only MySQL/PostgreSQL dialects can be automatically above conditions are not met, the execution delay of SQL may not be significantly improved, and the memory pressure will be increased. Parameters rules: - !SHARDING tables: shardingAlgorithms: # .. above conditions are not met, the execution delay of SQL may not be significantly improved, and the memory pressure will be increased. Parameters Class：org.apache.shardingsphere.sharding.api.config.cache

zookeep er. resources.limits ZooKeeper 容器的资源限制 {} govern ance.zookeeper. resour ces.requests. memory ZooKeeper 容器申请的内存 “ 256Mi“ gov ernance.zookeeper. res ources.requests.cpu ZooKeeper 容器申请的 cpu 拉取私有仓库的凭证 [] comp ute.resources.limits ShardingSphere‐Proxy 容器的资 源限制 {} compute.resou rces. requests.memory ShardingSphere‐Proxy 容器申请 的内存 2Gi compute.re sources. requests.cpu ShardingSphere‐Proxy 容器申请 limits for the ZooKeeper containers ## @param governance.zookeeper.resources.requests.memory The requested memory for the ZooKeeper containers ## @param governance.zookeeper.resources.requests.cpu The

zookeep er. resources.limits ZooKeeper 容器的资源限制 {} govern ance.zookeeper. resour ces.requests. memory ZooKeeper 容器申请的内存 “ 256Mi“ gov ernance.zookeeper. res ources.requests.cpu ZooKeeper 容器申请的 cpu 拉取私有仓库的凭证 [] comp ute.resources.limits ShardingSphere‐Proxy 容器的资 源限制 {} compute.resou rces. requests.memory ShardingSphere‐Proxy 容器申请 的内存 2Gi compute.re sources. requests.cpu ShardingSphere‐Proxy 容器申请 limits for the ZooKeeper containers ## @param governance.zookeeper.resources.requests.memory The requested memory for the ZooKeeper containers ## @param governance.zookeeper.resources.requests.cpu The

zookeeper .resources.limits ZooKeeper 容器的资源限制 {} governance .zookeeper. resource s.requests. memory ZooKeeper 容器申请的内存 2 56Mi governa nce.zookeeper. resou rces.requests.cpu ZooKeeper 容器申请的 cpu 核数 拉取私有仓库的凭证 [] compu te.resources.limits ShardingSphere‐Proxy 容器的资 源限制 {} compute.resour ces. requests.memory ShardingSphere‐Proxy 容器申请 的内存 2Gi compute.res ources. requests.cpu ShardingSphere‐Proxy 容器申请 limits for the ZooKeeper containers ## @param governance.zookeeper.resources.requests.memory The requested memory for the ZooKeeper containers ## @param governance.zookeeper.resources.requests.cpu The

zookeep er. resources.limits ZooKeeper 容器的资源限制 {} govern ance.zookeeper. resour ces.requests. memory ZooKeeper 容器申请的内存 “ 256Mi“ gov ernance.zookeeper. res ources.requests.cpu ZooKeeper 容器申请的 cpu 拉取私有仓库的凭证 [] comp ute.resources.limits ShardingSphere‐Proxy 容器的资 源限制 {} compute.resou rces. requests.memory ShardingSphere‐Proxy 容器申请 的内存 2Gi compute.re sources. requests.cpu ShardingSphere‐Proxy 容器申请 limits for the ZooKeeper containers ## @param governance.zookeeper.resources.requests.memory The requested memory for the ZooKeeper containers ## @param governance.zookeeper.resources.requests.cpu The

1 Background . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 3.2.2 Memory mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 3.2.3 Standalone Apache shardingsphere provides various mode such as memory, stand‐alone and cluster. 3.2. Mode 13 Apache ShardingSphere document, v5.1.2 3.2.2 Memory mode Suitable for fast integration testing, which process + merger ordering to avoid excessive memory occupation. SQL rewrite unavoidably occupies extra bandwidth, but it will not lead to sharp increase of memory occupation. Most people may assume that

1 Background . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 3.2.2 Memory mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 3.2.3 Standalone Apache shardingsphere provides various mode such as memory, stand‐alone and cluster. 3.2. Mode 13 Apache ShardingSphere document, v5.1.1 3.2.2 Memory mode Suitable for fast integration testing, which process + merger ordering to avoid excessive memory occupation. SQL rewrite unavoidably occupies extra bandwidth, but it will not lead to sharp increase of memory occupation. Most people may assume that