Comments (2)
[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
from shardingsphere.
@wsm12138 Hi,By the exception Caused by: java.lang.NoClassDefFoundError: org/apache/shardingsphere/globalclock/core/yaml/config/YamlGlobalClockRuleConfiguration
.
The classpath is now org.apache.shardingsphere.globalclock.yaml.config.YamlGlobalClockRuleConfiguration
, not core/yaml/config/YamlGlobalClockRuleConfiguration
. Please use the latest jar package.
from shardingsphere.
Related Issues (20)
- Add like support for DistSQL `show storage units`
- slow sql HOT 3
- 5.3.1 select sql when order by throw NPE HOT 6
- 请问我用shardingsphere-jdbc-core-spring-boot-starter-5.1.2遇见一个奇怪的问题,有些mysql select 语句在mybatis 的xml传入的入参偶尔会莫名奇妙自动多出一个入参,导致比实际参数值多,导致参数越界的报错,下图这个10对应limit后面的?,5这个值是多出的,请问这个问题怎么解决 HOT 2
- May I ask if I encountered a strange problem when using shardingsphere jdbc core spring boot starter 5.1.2? Some MySQL select statements occasionally inexplicably add an extra parameter to the input parameters passed in MyBatis' XML, resulting in more parameter values than the actual ones and causing an error message when the parameters exceed the limit. The 10 corresponding to the limit in the following figure?, The value of 5 is excessive, and the error query exception is Error querying database Cause: java.sql.SQLException: Parameter index out of bounds. 11 is not between valid values of 1 and 9, May I ask how to solve this problem HOT 2
- In the newly added tables in the source database, zk does not synchronize the information. HOT 5
- The collected system metadata is not cleared when database is droped
- Error occurs after using shardingsphere jdbc 5.5.0 Error querying database. Cause: com.github.pagehelper.PageException: When you use the PageHelper pagination plugin, you must set the helper property HOT 2
- The SQL query for a single projection column with a result being null cannot be executed.
- shardingsphere-jdbc-core integration druid error HOT 2
- This issue does not occur frequently in the testing environment, but occasionally occurs: java.io.EOFException: Can not read response from server. Expected to read 4 bytes, read 0 bytes before connection was unexpectedly lost. HOT 2
- Table name pattern can not be NULL or empty HOT 1
- Loosen the database type validation logic supported by DatabaseTypeChecker. HOT 1
- Loosen the database type validation logic supported by DatabaseTypeChecker.
- Why are methods not replayed on the PreparedStatement object in batch executor scenarios? HOT 3
- select count(distinct column) + limit has bug HOT 2
- After creating a shadow rule, an exception occurs when loading single table
- The database is specified in SQL, but a `No database selected` exception occurs
- Is there any way to get whether the executed statement is insert or select in a custom algorithm? HOT 6
- Incorrect results for querying information_schema.SCHEMATA
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from shardingsphere.