bglmmz
(Bglmmz)
2020 年8 月 12 日 08:49
1
我参考:
https://docs.pingcap.com/zh/tidb/dev/v4.0-performance-benchmarking-with-tpcc,
做性能测试,在运行:
./runBenchmark.sh ./props.mysql后,提示:
ERROR jTPCC : Term-00, DB Load configuration parameter ‘warehouses’ not found
但是我的./props.mysql文件里,有warehouses变量,如下:
db=mysql
driver=com.mysql.jdbc.Driver
conn=jdbc:mysql://localhost:4000/tpcc?useSSL=false&useServerPrepStmts=true&useConfigs=maxPerformance&rewriteBatchedStatements=true
user=root
password=
warehouses=1000
loadWorkers=100
terminals=1000
//To run specified transactions per terminal- runMins must equal zero
runTxnsPerTerminal=0
//To run for specified minutes- runTxnsPerTerminal must equal zero
runMins=20
//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
bglmmz
(Bglmmz)
2020 年8 月 12 日 10:05
3
由于./runBenchmark.sh ./props.mysql出错,于是我执行了另一个命令:
./runLoader.sh props.mysql
由于我的配置是
warehouses=1000
结果执行时,输出下面的日志都很快。
Starting BenchmarkSQL LoadData
driver=com.mysql.jdbc.Driver
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
conn=jdbc:mysql://localhost:4000/tpcc?useSSL=false&useServerPrepStmts=true&useConfigs=maxPerformance&rewriteBatchedStatements=true
user=root
password=***********
warehouses=1000
loadWorkers=100
fileLocation (not defined)
csvNullValue (not defined - using default 'NULL')
Worker 000: Loading ITEM
Worker 001: Loading Warehouse 1
Worker 002: Loading Warehouse 2
Worker 003: Loading Warehouse 3
Worker 004: Loading Warehouse 4
Worker 005: Loading Warehouse 5
Worker 006: Loading Warehouse 6
Worker 007: Loading Warehouse 7
Worker 008: Loading Warehouse 8
Worker 009: Loading Warehouse 9
Worker 010: Loading Warehouse 10
Worker 011: Loading Warehouse 11
Worker 012: Loading Warehouse 12
Worker 013: Loading Warehouse 13
Worker 014: Loading Warehouse 14
Worker 015: Loading Warehouse 15
Worker 016: Loading Warehouse 16
Worker 017: Loading Warehouse 17
Worker 018: Loading Warehouse 18
Worker 019: Loading Warehouse 19
Worker 020: Loading Warehouse 20
Worker 021: Loading Warehouse 21
Worker 022: Loading Warehouse 22
Worker 023: Loading Warehouse 23
Worker 024: Loading Warehouse 24
Worker 025: Loading Warehouse 25
Worker 026: Loading Warehouse 26
Worker 027: Loading Warehouse 27
Worker 028: Loading Warehouse 28
Worker 029: Loading Warehouse 29
Worker 030: Loading Warehouse 30
Worker 031: Loading Warehouse 31
Worker 032: Loading Warehouse 32
Worker 033: Loading Warehouse 33
Worker 034: Loading Warehouse 34
Worker 035: Loading Warehouse 35
Worker 036: Loading Warehouse 36
Worker 037: Loading Warehouse 37
Worker 038: Loading Warehouse 38
Worker 039: Loading Warehouse 39
Worker 040: Loading Warehouse 40
Worker 041: Loading Warehouse 41
Worker 042: Loading Warehouse 42
Worker 043: Loading Warehouse 43
Worker 044: Loading Warehouse 44
Worker 045: Loading Warehouse 45
Worker 046: Loading Warehouse 46
Worker 047: Loading Warehouse 47
Worker 048: Loading Warehouse 48
Worker 049: Loading Warehouse 49
Worker 050: Loading Warehouse 50
Worker 051: Loading Warehouse 51
Worker 052: Loading Warehouse 52
Worker 053: Loading Warehouse 53
Worker 054: Loading Warehouse 54
Worker 055: Loading Warehouse 55
Worker 056: Loading Warehouse 56
Worker 057: Loading Warehouse 57
Worker 058: Loading Warehouse 58
Worker 059: Loading Warehouse 59
Worker 060: Loading Warehouse 60
Worker 061: Loading Warehouse 61
Worker 062: Loading Warehouse 62
Worker 063: Loading Warehouse 63
Worker 064: Loading Warehouse 64
Worker 065: Loading Warehouse 65
Worker 066: Loading Warehouse 66
Worker 067: Loading Warehouse 67
Worker 068: Loading Warehouse 68
Worker 069: Loading Warehouse 69
Worker 070: Loading Warehouse 70
Worker 071: Loading Warehouse 71
Worker 072: Loading Warehouse 72
Worker 073: Loading Warehouse 73
Worker 074: Loading Warehouse 74
Worker 075: Loading Warehouse 75
Worker 076: Loading Warehouse 76
Worker 077: Loading Warehouse 77
Worker 078: Loading Warehouse 78
Worker 079: Loading Warehouse 79
Worker 080: Loading Warehouse 80
Worker 081: Loading Warehouse 81
Worker 082: Loading Warehouse 82
Worker 083: Loading Warehouse 83
Worker 084: Loading Warehouse 84
Worker 085: Loading Warehouse 85
Worker 086: Loading Warehouse 86
Worker 087: Loading Warehouse 87
Worker 088: Loading Warehouse 88
Worker 089: Loading Warehouse 89
Worker 090: Loading Warehouse 90
Worker 091: Loading Warehouse 91
Worker 092: Loading Warehouse 92
Worker 093: Loading Warehouse 93
Worker 094: Loading Warehouse 94
Worker 095: Loading Warehouse 95
Worker 096: Loading Warehouse 96
Worker 097: Loading Warehouse 97
Worker 098: Loading Warehouse 98
Worker 099: Loading Warehouse 99
然后就停顿了,等了好几分钟,才输出下面的日志,然后就是一动不动漫长等待,到现在还没反应。。。。
Worker 000: Loading ITEM done
Worker 000: Loading Warehouse 100
bglmmz
(Bglmmz)
2020 年8 月 12 日 10:20
4
的确超鸡慢,过了好久才有下面的日志…,1000个Warehouses,要等到天亮了…
Worker 025: Loading Warehouse 25 done
Worker 025: Loading Warehouse 101
Worker 022: Loading Warehouse 22 done
Worker 022: Loading Warehouse 102
Worker 020: Loading Warehouse 20 done
Worker 020: Loading Warehouse 103
Worker 024: Loading Warehouse 24 done
Worker 024: Loading Warehouse 104
Worker 021: Loading Warehouse 21 done
Worker 021: Loading Warehouse 105
Worker 023: Loading Warehouse 23 done
Worker 023: Loading Warehouse 106
Worker 014: Loading Warehouse 14 done
Worker 014: Loading Warehouse 107
Worker 018: Loading Warehouse 18 done
Worker 018: Loading Warehouse 108
Worker 007: Loading Warehouse 7 done
Worker 007: Loading Warehouse 109
Worker 013: Loading Warehouse 13 done
Worker 013: Loading Warehouse 110
Worker 028: Loading Warehouse 28 done
Worker 028: Loading Warehouse 111
Worker 008: Loading Warehouse 8 done
Worker 008: Loading Warehouse 112
Worker 011: Loading Warehouse 11 done
Worker 011: Loading Warehouse 113
Worker 026: Loading Warehouse 26 done
Worker 026: Loading Warehouse 114
Worker 005: Loading Warehouse 5 done
Worker 005: Loading Warehouse 115
Worker 001: Loading Warehouse 1 done
Worker 001: Loading Warehouse 116
yilong
(yi888long)
2020 年8 月 13 日 07:41
5
lc17
2022 年9 月 22 日 07:09
6
jTPCC : Term-00, DB Load configuration parameter ‘warehouses’ not found
报错需要检查表bmsql_config的内容,正常应该有4条数据,其中一条是warehouses,10,这里的10是你的仓数,报错是没有读到仓数