all weaved by plugins. Developers can customize their own ShardingSphere just like building lego blocks. There are lots of SPI extensions for Apache ShardingSphere now and increase continuously. ShardingSphere sets to output through unified JDBC interface. Result merger in‐ cludes methods as stream merger, memory merger and addition merger using decorator merger. Parse Engine Compared to other programming languages and ORDER BY to GROUP BY SQL, and they are used to transfer memory merger to stream merger. In the result merger part, stream merger and memory merger will be explained in detail. The overall structure

1 Background . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 3.2.2 Memory mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 3.2.3 Standalone be embedded flexibily. Developers can customize their ShardingSphere just like building with LEGO blocks. ShardingSphere became an Apache Top‐Level Project on April 16, 2020. Welcome to interact with Apache shardingsphere provides various mode such as memory, stand‐alone and cluster. 3.2. Mode 13 Apache ShardingSphere document, v5.0.0 3.2.2 Memory mode Suitable for fast integration testing, which

1 Background . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 3.2.2 Memory mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 3.2.3 Standalone be embedded flexibily. Developers can customize their ShardingSphere just like building with LEGO blocks. ShardingSphere became an Apache Top‐Level Project on April 16, 2020. Welcome to interact with 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

1 Background . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 3.2.2 Memory mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14 3.2.3 Standalone be embedded flexibily. Developers can customize their ShardingSphere just like building with LEGO blocks. ShardingSphere became an Apache Top‐Level Project on April 16, 2020. Welcome to interact with 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

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: # .. condition.DisabledInNativeImage annotation or the org.graalvm.nativeimage. imagecode System Property blocks some unit tests from running under GraalVM Native Image. ShardingSphere defines the Maven Profile 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

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 condition.DisabledInNativeImage annotation or the org.graalvm.nativeimage.imagecode System Property blocks some unit tests from running un‐ der GraalVM Native Image. ShardingSphere defines the Maven Profile

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 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

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 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

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