benchmarksql issues

automatic reconnect with retry after connection closed

1

benchmarkSQL throw an exception after any connection close, which will cause quit. Add automatic reconnect with retry to benchmarkSQL, which will automatically reconnect after connection close or tidb-server crash.

7yyo

oracle should change `FOR UPDATE` clause like following

```java stmtDeliveryBGSelectOldestNewOrder = dbConn.prepareStatement( "SELECT no_o_id FROM bmsql_new_order WHERE no_o_id in " + "( " + " SELECT no_o_id FROM bmsql_new_order " + " WHERE no_w_id = ? AND no_d_id...

TimHe95

oracle does not support `LIMIT`

`LIMIT 1` should be replaced by `FETCH FIRST 1 ROWS ONLY` ``` 15:43:21,203 [Thread-3] ERROR jTPCCTData : ORA-00933: SQL 命令未正确结束 java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束 at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)...

TimHe95

add create clustered tables file

clustered table can get better performance for tidb , but load data time would slow than nonclustered table. Create the clustered tables (except bmsql_order_line table) ./runSQL.sh props.mysql sql.mysql/clusteredtableCreates.sql

haiying-gao

add tidb driver

1. driver repo : https://github.com/pingcap/tidb-loadbalance it will be load balance by driver , by it is dependent on mysql-driver use load balance can go to the repo; and tomcat has...

knull-cn

benchmarksql 配置jdbc:mysql:loadbalance测试出现大量异常

1

**测试版本** tidb v4.0.1 benchmarksql v5.0-mysql-support-opt-2.1 **测试配置** ``` db=mysql driver=com.mysql.cj.jdbc.Driver conn=jdbc:mysql:loadbalance://10.5.74.51:4000,10.5.74.52:4000,10.5.74.53:4000/tpcc?useSSL=false&useServerPrepStmts=true&useConfigs=maxPerformance&rewriteBatchedStatements=true warehouses=200 terminals=500 ``` **测试异常** ``` 10:32:33,872 [Thread-353] ERROR jTPCCTData : Unexpected SQLException in NEW_ORDER 10:32:33,873 [Thread-353] ERROR jTPCCTData : Duplicate...

salahgao