xuxinstyle commented on issue #7847:
URL: https://github.com/apache/shardingsphere/issues/7847#issuecomment-712031019
> > @xuxinstyle Can you set `sql.show=ture`,and then show the actual sql?
> > Logic SQL: update `profile` set name="艾丹克莱尔UtWn" where id = 40586220;
> > [INFO ] 18:41:34.715 [ShardingSphere-Command-13] ShardingSphere-SQL -
SQLStatement:
UpdateStatementContext(super=CommonSQLStatementContext(sqlStatement=org.apache.shardingsphere.sql.parser.sql.statement.dml.UpdateStatement@64132658,
tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@3030dae6),
tablesContext=org.apache.shardingsphere.sql.parser.binder.segment.table.TablesContext@3030dae6)
> > [INFO ] 18:41:34.715 [ShardingSphere-Command-13] ShardingSphere-SQL -
Actual SQL: ds_1 ::: update `profile` set name="艾丹克莱尔UtWn" where id = 40586220;
> > [INFO ] 18:41:34.727 [ShardingSphere-Command-6] ShardingSphere-SQL -
Logic SQL: SHOW STATUS
server.yaml config:
authentication:
users:
root:
password: 123456
authorizedSchemas: sharding_db
sharding:
password: 123456
authorizedSchemas: sharding_db
props:
max.connections.size.per.query: 1
acceptor.size: 16 # The default value is available processors count * 2.
executor.size: 16 # Infinite by default.
proxy.frontend.flush.threshold: 128 # The default value is 128.
# LOCAL: Proxy will run with LOCAL transaction.
# XA: Proxy will run with XA transaction.
# BASE: Proxy will run with B.A.S.E transaction.
proxy.transaction.type: LOCAL
proxy.opentracing.enabled: false
proxy.hint.enabled: false
query.with.cipher.column: true
sql.show: true
allow.range.query.with.inline.sharding: false
orchestration:
orchestration_ds:
orchestrationType: registry_center,config_center,distributed_lock_manager
instanceType: zookeeper
serverLists: localhost:2181
namespace: orchestration
props:
overwrite: true
retryIntervalMilliseconds: 500
timeToLiveSeconds: 60
maxRetries: 3
operationTimeoutMilliseconds: 500
config-sharding.yaml:
schemaName: sharding_db
dataSources:
ds_0:
url:
jdbc:mysql://10.72.12.62:3306/aow_cian_02?serverTimezone=UTC&useSSL=false
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
ds_1:
url:
jdbc:mysql://10.72.12.62:3306/aow_cian_01?serverTimezone=UTC&useSSL=false
username: root
password: 123456
connectionTimeoutMilliseconds: 30000
idleTimeoutMilliseconds: 60000
maxLifetimeMilliseconds: 1800000
maxPoolSize: 50
shardingRule:
tables:
profile:
actualDataNodes: ds_${0..1}.profile
databaseStrategy:
standard:
shardingColumn: id
preciseAlgorithmClassName:
com.idreamsky.shardingalgorithm.IdreamSkyShardingAlgorithm
rangeAlgorithmClassName:
com.idreamsky.shardingalgorithm.IdreamSkyShardingAlgorithm
bindingTables:profile
defaultDataSourceName: ds_0
defaultDatabaseStrategy:
none:
defaultTableStrategy:
none:
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
