wsm12138 commented on issue #31134:
URL:
https://github.com/apache/shardingsphere/issues/31134#issuecomment-2095540594
```
[root@localhost run]# ./runBenchmark.sh.source props.jdbc.1pcs^C
[root@localhost run]# cat props.jdbc.1pcs
db=postgres
driver=com.mysql.jdbc.Driver
//conn=jdbc:mysql://192.168.10.25:3333/sharding_db?useSSL=false&useServerPrepStmts=true&cachePrepStmts=true&prepStmtCacheSize=8192&prepStmtCacheSqlLimit=8000
conn=sharding:opengauss://localhost:5432/test?loggerLevel=OFF
config=/opt/jenkins/benchmarksql/run/config-tpcc.yaml
user=root
password=root
warehouses=200
loadWorkers=100
terminals=200
//To run specified transactions per terminal- runMins must equal zero
runTxnsPerTerminal=0
//To run for specified minutes- runTxnsPerTerminal must equal zero
runMins=3
//Number of total transactions per minute
limitTxnsPerMin=0
//Set to true to run in 4.x compatible mode. Set to false to use the
//entire configured database evenly.
terminalWarehouseFixed=true
//The following five values must add up to 100
//The default percentages of 45, 43, 4, 4 & 4 match the TPC-C spec
newOrderWeight=45
paymentWeight=43
orderStatusWeight=4
deliveryWeight=4
stockLevelWeight=4
// Directory name to create for collecting detailed result data.
// Comment this out to suppress.
resultDirectory=my_result_%tY-%tm-%td_%tH%tM%tS
//osCollectorScript=./misc/os_collector_linux.py
//osCollectorInterval=1
//osCollectorSSHAddr=user@dbhost
//osCollectorDevices=net_eth0 blk_sda
shardingNumber=1
[root@localhost run]# cat /opt/jenkins/benchmarksql/run/config-tpcc.yaml
databaseName: sharding_db
dataSources:
ds_0:
dataSourceClassName: com.zaxxer.hikari.HikariDataSource
driverClassName: com.mysql.jdbc.Driver
jdbcUrl:
jdbc:mysql://192.168.10.20:13306/test?useSSL=false&useServerPrepStmts=true&cachePrepStmts=true&prepStmtCacheSize=8192&prepStmtCacheSqlLimit=8000
username: test
password: sphereEx@2021
connectionTimeout: 3600000
idleTimeoutMilliseconds: 60000
maxLifetime: 70000
maximumPoolSize: 500
minimumIdle: 500
rules:
- !SINGLE
tables:
- "*.*"
- !SHARDING
bindingTables:
- bmsql_warehouse, bmsql_customer
- bmsql_stock, bmsql_district, bmsql_order_line
defaultDatabaseStrategy:
none:
defaultTableStrategy:
none:
keyGenerators:
snowflake:
type: SNOWFLAKE
autoTables:
bmsql_warehouse:
actualDataSources: ds_${0..0}
shardingStrategy:
standard:
shardingColumn: w_id
shardingAlgorithmName: mod_1
bmsql_district:
actualDataSources: ds_${0..0}
shardingStrategy:
standard:
shardingColumn: d_w_id
shardingAlgorithmName: mod_1
bmsql_customer:
actualDataSources: ds_${0..0}
shardingStrategy:
standard:
shardingColumn: c_w_id
shardingAlgorithmName: mod_1
bmsql_item:
actualDataSources: ds_${0..0}
shardingStrategy:
standard:
shardingColumn: i_id
shardingAlgorithmName: mod_1
bmsql_history:
actualDataSources: ds_${0..0}
shardingStrategy:
standard:
shardingColumn: h_w_id
shardingAlgorithmName: mod_1
bmsql_oorder:
actualDataSources: ds_${0..0}
shardingStrategy:
standard:
shardingColumn: o_w_id
shardingAlgorithmName: mod_1
bmsql_stock:
actualDataSources: ds_${0..0}
shardingStrategy:
standard:
shardingColumn: s_w_id
shardingAlgorithmName: mod_1
bmsql_new_order:
actualDataSources: ds_${0..0}
shardingStrategy:
standard:
shardingColumn: no_w_id
shardingAlgorithmName: mod_1
bmsql_order_line:
actualDataSources: ds_${0..0}
shardingStrategy:
standard:
shardingColumn: ol_w_id
shardingAlgorithmName: mod_1
shardingAlgorithms:
mod_1:
type: MOD
props:
sharding-count: 1
mode:
type: Cluster
repository:
type: ZooKeeper
props:
namespace: 20240506_BenchmarkSQL_tt
server-lists: 192.168.10.23:2181
retryIntervalMilliseconds: 500
timeToLiveSeconds: 60
maxRetries: 3
operationTimeoutMilliseconds: 500
```
--
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.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
