Apache ShardingSphere provides the way of property configuration to configure system level configuration.

Configuration Item Explanation

Name Data Type Description Default Value
sql-show (?) boolean Whether show SQL or not in log.
Print SQL details can help developers debug easier. The log details include: logic SQL, actual SQL and SQL parse result.
Enable this property will log into log topic ShardingSphere-SQL, log level is INFO
false
sql-simple (?) boolean Whether show SQL details in simple style false
kernel-executor-size (?) int The max thread size of worker group to execute SQL. One ShardingSphereDataSource will use a independent thread pool, it does not share thread pool even different data source in same JVM infinite
max-connections-size-per-query (?) int Max opened connection size for each query 1
check-table-metadata-enabled (?) boolean Whether validate table meta data consistency when application startup or updated false
check-duplicate-table-enabled (?) boolean Whether validate duplicate table when application startup or updated false
sql-comment-parse-enabled (?) boolean Whether parse the comment of SQL false
sql-federation-enabled (?) boolean Whether enable SQL federation false
sql-cache-initial-capacity(?) int SQL statement local cache initial capacity 2000
sql-cache-maximum-size(?) long SQL statement local cache maximum size 65535
sql-cache-concurrency-level(?) int SQL statement local cache concurrency level, the maximum number of concurrent updates allowed by threads 4