Background

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

Parameters

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
sql-federation-type (?)StringSQL federation executor type, including: NONE, ORIGINAL, ADVANCEDNONE

Procedure

  1. Properties configuration is directly configured in the profile used by ShardingSphere-JDBC. The format is as follows:
  1. props:
  2. sql-show: true

Sample

The example of ShardingSphere warehouse contains property configurations of various scenarios. Please refer to: https://github.com/apache/shardingsphere/tree/master/examples/shardingsphere-jdbc-example