Skip to content

benchmarkSQL myrocks

Jump to bottom
zhangyuan edited this page Aug 21, 2018 · 1 revision 
-rwxr-xr-x 1 root root 1215 Mar  2  2017 funcs.sh
11:34:56,094 [main] INFO   jTPCC : Term-00,
11:34:56,096 [main] INFO   jTPCC : Term-00, +-------------------------------------------------------------+
11:34:56,096 [main] INFO   jTPCC : Term-00,      BenchmarkSQL v5.0
11:34:56,097 [main] INFO   jTPCC : Term-00, +-------------------------------------------------------------+
11:34:56,097 [main] INFO   jTPCC : Term-00,  (c) 2003, Raul Barbosa
11:34:56,097 [main] INFO   jTPCC : Term-00,  (c) 2004-2016, Denis Lussier
11:34:56,099 [main] INFO   jTPCC : Term-00,  (c) 2016, Jan Wieck
11:34:56,099 [main] INFO   jTPCC : Term-00, +-------------------------------------------------------------+
11:34:56,099 [main] INFO   jTPCC : Term-00,
11:34:56,099 [main] INFO   jTPCC : Term-00, db=mysql
11:34:56,099 [main] INFO   jTPCC : Term-00, driver=com.mysql.jdbc.Driver
11:34:56,099 [main] INFO   jTPCC : Term-00, conn=jdbc:mysql://localhost:4001/benchmarksql
11:34:56,099 [main] INFO   jTPCC : Term-00, user=benchmarktest
11:34:56,100 [main] INFO   jTPCC : Term-00,
11:34:56,100 [main] INFO   jTPCC : Term-00, warehouses=10
11:34:56,100 [main] INFO   jTPCC : Term-00, terminals=100
11:34:56,101 [main] INFO   jTPCC : Term-00, runMins=2
11:34:56,102 [main] INFO   jTPCC : Term-00, limitTxnsPerMin=0
11:34:56,102 [main] INFO   jTPCC : Term-00, terminalWarehouseFixed=true
11:34:56,102 [main] INFO   jTPCC : Term-00,
11:34:56,102 [main] INFO   jTPCC : Term-00, newOrderWeight=45
11:34:56,102 [main] INFO   jTPCC : Term-00, paymentWeight=43
11:34:56,102 [main] INFO   jTPCC : Term-00, orderStatusWeight=4
11:34:56,102 [main] INFO   jTPCC : Term-00, deliveryWeight=4
11:34:56,103 [main] INFO   jTPCC : Term-00, stockLevelWeight=4
11:34:56,103 [main] INFO   jTPCC : Term-00,
11:34:56,103 [main] INFO   jTPCC : Term-00, resultDirectory=mysql_result_%tY-%tm-%td_%tH%tM%tS
11:34:56,103 [main] INFO   jTPCC : Term-00, osCollectorScript=./misc/os_collector_linux.py
11:34:56,103 [main] INFO   jTPCC : Term-00,
11:34:56,118 [main] INFO   jTPCC : Term-00, copied props.mysql to mysql_result_2018-08-21_113456/run.properties
11:34:56,119 [main] INFO   jTPCC : Term-00, created mysql_result_2018-08-21_113456/data/runInfo.csv for runID 213
11:34:56,119 [main] INFO   jTPCC : Term-00, writing per transaction results to mysql_result_2018-08-21_113456/data/result.csv
11:34:56,120 [main] INFO   jTPCC : Term-00, osCollectorScript=./misc/os_collector_linux.py
11:34:56,120 [main] INFO   jTPCC : Term-00, osCollectorInterval=1
11:34:56,120 [main] INFO   jTPCC : Term-00, osCollectorSSHAddr=null
11:34:56,120 [main] INFO   jTPCC : Term-00, osCollectorDevices=net_eth0 blk_sda
11:34:56,180 [main] INFO   jTPCC : Term-00,
11:34:56,444 [main] INFO   jTPCC : Term-00, C value for C_LAST during load: 47
11:34:56,444 [main] INFO   jTPCC : Term-00, C value for C_LAST this run:    137
11:34:56,444 [main] INFO   jTPCC : Term-00,
11:35:41,120 [Thread-13] ERROR  jTPCCTData : Unexpected SQLException in DELIVERY_BG Usage: 279MB / 1740MB
11:35:41,121 [Thread-13] ERROR  jTPCCTData : Lock wait timeout exceeded; try restarting transaction
com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

.....

11:36:56,707 [Thread-68] ERROR  jTPCCTData : Lock wait timeout exceeded; try restarting transaction
com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
	at sun.reflect.GeneratedConstructorAccessor9.newInstance(Unknown Source)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.Util.getInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:951)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2501)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
	at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2079)
	at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2013)
	at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5104)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1998)
	at jTPCCTData.executeDeliveryBG(jTPCCTData.java:1632)
	at jTPCCTData.execute(jTPCCTData.java:116)
	at jTPCCTerminal.executeTransactions(jTPCCTerminal.java:237)
	at jTPCCTerminal.run(jTPCCTerminal.java:88)
	at java.lang.Thread.run(Thread.java:745)

11:36:57,125 [Thread-31] INFO   jTPCC : Term-00,
11:36:57,125 [Thread-31] INFO   jTPCC : Term-00,
11:36:57,126 [Thread-31] INFO   jTPCC : Term-00, Measured tpmC (NewOrders) = 141163.48
11:36:57,126 [Thread-31] INFO   jTPCC : Term-00, Measured tpmTOTAL = 313949.92
11:36:57,126 [Thread-31] INFO   jTPCC : Term-00, Session Start     = 2018-08-21 11:34:56
11:36:57,126 [Thread-31] INFO   jTPCC : Term-00, Session End       = 2018-08-21 11:36:57
11:36:57,126 [Thread-31] INFO   jTPCC : Term-00, Transaction Count = 630243
Clone this wiki locally