我的书签
添加书签
移除书签Introduction
Apache ShardingSphere provides the way of property configuration to configure system level configuration.
Configuration Item Explanation
| Name | Data Type | Description | Default Value | Dynamic Update |
|---|---|---|---|---|
| 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 | true |
| sql-simple (?) | boolean | Whether show SQL details in simple style. | false | true |
| 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 | false |
| max-connections-size-per-query (?) | int | Max opened connection size for each query. | 1 | true |
| check-table-metadata-enabled (?) | boolean | Whether validate table meta data consistency when application startup or updated. | false | false |
| proxy-frontend-flush-threshold (?) | int | Flush threshold for every records from databases for ShardingSphere-Proxy. | 128 | true |
| proxy-opentracing-enabled (?) | boolean | Whether enable opentracing for ShardingSphere-Proxy. | false | true |
| proxy-hint-enabled (?) | boolean | Whether enable hint for ShardingSphere-Proxy. Using Hint will switch proxy thread mode from IO multiplexing to per connection per thread, which will reduce system throughput. | false | true |
| proxy-backend-query-fetch-size (?) | int | Proxy backend query fetch size. A larger value may increase the memory usage of ShardingSphere Proxy. The default value is -1, which means set the minimum value for different JDBC drivers. | -1 | false |
| check-duplicate-table-enabled (?) | boolean | Whether validate duplicate table when application startup or updated. | false | false |
| proxy-frontend-executor-size (?) | int | Proxy frontend Netty executor size. The default value is 0, which means let Netty decide. | 0 | false |
| proxy-backend-executor-suitable (?) | String | Available options of proxy backend executor suitable: OLAP(default), OLTP. The OLTP option may reduce time cost of writing packets to client, but it may increase the latency of SQL execution if client connections are more than proxy-frontend-netty-executor-size, especially executing slow SQL. | OLAP | false |
| proxy-frontend-max-connections (?) | int | The maximum permitted number of client connections to Proxy. The default value is 0 and less than or equal to 0 means no limitation. | 0 | true |
| sql-federation-enabled (?) | boolean | Whether enable sql federation. | false | true |
Properties can be updated by DistSQL. Dynamic update can take effect immediately, static update can take effect after restarted.
当前内容版权归 ShardingSphere 或其关联方所有，如需对内容或内容相关联开源项目进行关注与资助，请访问 ShardingSphere .
