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

Configuration Item Explanation

NameData TypeDescriptionDefault Value
sql-show (?)booleanWhether 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 (?)booleanWhether show SQL details in simple stylefalse
kernel-executor-size (?)intThe 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 JVMinfinite
max-connections-size-per-query (?)intMax opened connection size for each query1
check-table-metadata-enabled (?)booleanWhether validate table meta data consistency when application startup or updatedfalse
check-duplicate-table-enabled (?)booleanWhether validate duplicate table when application startup or updatedfalse
sql-federation-enabled (?)booleanWhether enable SQL federationfalse