性能测试上出错

我参考:
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

如果删除这个参数可以使用吗?

由于./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

的确超鸡慢,过了好久才有下面的日志…,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

在导入数据吗? 建议导出 csv 使用 lightning 导入,可以参考以下文档,会比较快。

https://docs.pingcap.com/zh/tidb/v3.0/benchmark-tidb-using-tpcc

jTPCC : Term-00, DB Load configuration parameter ‘warehouses’ not found
报错需要检查表bmsql_config的内容,正常应该有4条数据,其中一条是warehouses,10,这里的10是你的仓数,报错是没有读到仓数