tpcc-mysql 壓測報告
一 機器配置
dell r730,SAS raid10 3.3T,Intel(R) Xeon(R) CPU E5-2640 v4 @ 2.40GHz 40核 ，記憶體188G DDR4
磁碟配置RAID10,8塊盤SEAGATE 12 Gbps SAS 900G 15000轉
二 mysql配置
mysql單節點，innodb_buffer_pool_size = 90602M innodb_buffer_pool_instances=30 ，binlog_format=row
#gtid
server_id= 3401
gtid_mode=on
enforce_gtid_consistency=on
#master_info_repository=table
#relay_log_info_repository=table
#innodb
innodb_data_file_path = ibdata1:128M:autoextend
innodb_temp_data_file_path = ibtmp1:12M:autoextend:max:5G
innodb_buffer_pool_size = 90602M
innodb_buffer_pool_instances=30
#innodb log
innodb_log_file_size = 256M
innodb_log_files_in_group=6
innodb_log_group_home_dir = ./
#innodb zero data lost variables
innodb_flush_log_at_trx_commit = 1
innodb_doublewrite=on
sync_binlog=1
#innodb_support_xa=on
#tx commit action is heavy action
autocommit=on
transaction_isolation=READ-COMMITTED
lower_case_table_names=1
#character
#init_connect = 'SET NAMES utf8mb4'
character_set_server=utf8mb4
#connect
max_connections = 9999
max_connect_errors=9999999
sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION'
三 壓測10個倉庫
[mysql@pro-pnh-310-db-tidb-mp-45 tpcc-mysql]$ ./tpcc_start -h10.34.255.45 -P3400 -dtpcc10 -u test1 -p 123456 -w 10 -c5 -r10 -l108 *************************************** *** ###easy### TPC-C Load Generator *** *************************************** option h with value '10.34.255.45' option P with value '3400' option d with value 'tpcc10' option u with value 'test1' option p with value '123456' option w with value '10' option c with value '5' option r with value '10' option l with value '108' <Parameters> [server]: 10.34.255.45 [port]: 3400 [DBname]: tpcc10 [user]: test1 [pass]: 123456 [warehouse]: 10 [connection]: 5 [rampup]: 10 (sec.) [measure]: 108 (sec.) RAMP-UP TIME.(10 sec.) MEASURING START. 10, trx: 4064, 95%: 10.783, 99%: 14.498, max_rt: 23.412, 4067|15.980, 407|3.869, 405|36.685, 407|38.208 20, trx: 3973, 95%: 10.282, 99%: 13.663, max_rt: 20.586, 3967|17.012, 397|1.851, 398|37.341, 396|32.670 30, trx: 4033, 95%: 9.745, 99%: 13.623, max_rt: 18.151, 4038|11.334, 403|1.713, 404|34.037, 404|31.110 40, trx: 4063, 95%: 9.572, 99%: 11.838, max_rt: 16.801, 4062|12.809, 406|1.492, 405|33.194, 407|31.109 50, trx: 4007, 95%: 9.874, 99%: 12.569, max_rt: 17.606, 4007|13.652, 400|1.694, 401|36.461, 400|33.027 60, trx: 4107, 95%: 9.520, 99%: 11.920, max_rt: 16.926, 4108|11.205, 412|1.555, 411|32.701, 411|32.372 70, trx: 3981, 95%: 9.928, 99%: 12.962, max_rt: 26.076, 3982|13.217, 398|1.574, 398|37.224, 398|35.085 80, trx: 3991, 95%: 9.993, 99%: 13.320, max_rt: 18.051, 3990|15.959, 399|1.669, 399|40.956, 400|32.412 90, trx: 3983, 95%: 10.181, 99%: 13.659, max_rt: 17.453, 3982|16.408, 398|1.836, 398|33.736, 398|35.317 100, trx: 3910, 95%: 10.616, 99%: 13.878, max_rt: 22.968, 3910|14.187, 391|1.471, 391|32.737, 391|33.103 STOPPING THREADS..... <Raw Results> [0] sc:9317 lt:30795 rt:0 fl:0 avg_rt: 7.4 (5) [1] sc:39659 lt:454 rt:0 fl:0 avg_rt: 2.0 (5) [2] sc:4011 lt:0 rt:0 fl:0 avg_rt: 0.8 (5) [3] sc:4010 lt:0 rt:0 fl:0 avg_rt: 21.2 (80) [4] sc:3062 lt:950 rt:0 fl:0 avg_rt: 20.8 (20) in 100 sec. <Raw Results2(sum ver.)> [0] sc:9317 lt:30795 rt:0 fl:0 [1] sc:39659 lt:454 rt:0 fl:0 [2] sc:4011 lt:0 rt:0 fl:0 [3] sc:4010 lt:0 rt:0 fl:0 [4] sc:3062 lt:950 rt:0 fl:0 <Constraint Check> (all must be [OK]) [transaction percentage] Payment: 43.48% (>=43.0%) [OK] Order-Status: 4.35% (>= 4.0%) [OK] Delivery: 4.35% (>= 4.0%) [OK] Stock-Level: 4.35% (>= 4.0%) [OK] [response time (at least 90% passed)] New-Order: 23.23% [NG] * Payment: 98.87% [OK] Order-Status: 100.00% [OK] Delivery: 100.00% [OK] Stock-Level: 76.32% [NG] * <TpmC> 24067.199 TpmC
四 壓測200個倉庫100個會話
測試指令碼 mysql -utest1 -p123456 -S /data/mp_mysql/p3400.sock -Dtpcc10 < create_table.sql ./tpcc_load -h10.34.255.45 -P3400 -dtpcc10 -u test1 -p 123456 -w 200 mysql -utest1 -p123456 -S /data/mp_mysql/p3400.sock -Dtpcc10 < add_fkey_idx.sql ./tpcc_start -h10.34.255.45 -P3400 -dtpcc10 -u test1 -p 123456 -w 200 -c100 -r10 -l108 [mysql@pro-pnh-310-db-tidb-mp-45 tpcc-mysql]$ ./tpcc_start -h10.34.255.45 -P3400 -dtpcc10 -u test1 -p 123456 -w 200 -c100 -r10 -l108 *************************************** *** ###easy### TPC-C Load Generator *** *************************************** option h with value '10.34.255.45' option P with value '3400' option d with value 'tpcc10' option u with value 'test1' option p with value '123456' option w with value '200' option c with value '100' option r with value '10' option l with value '108' <Parameters> [server]: 10.34.255.45 [port]: 3400 [DBname]: tpcc10 [user]: test1 [pass]: 123456 [warehouse]: 200 [connection]: 100 [rampup]: 10 (sec.) [measure]: 108 (sec.) RAMP-UP TIME.(10 sec.) MEASURING START. 10, trx: 15339, 95%: 174.113, 99%: 342.788, max_rt: 927.287, 15337|592.166, 1534|29.176, 1523|537.166, 1541|251.587 20, trx: 7527, 95%: 295.934, 99%: 1707.978, max_rt: 2195.444, 7498|2133.271, 751|34.094, 747|1682.577, 744|74.926 30, trx: 10556, 95%: 94.204, 99%: 403.047, max_rt: 597.630, 10571|524.800, 1057|32.198, 1054|741.236, 1058|73.188 40, trx: 11082, 95%: 113.517, 99%: 352.359, max_rt: 472.489, 11054|433.272, 1107|141.683, 1102|681.298, 1108|65.585 50, trx: 10433, 95%: 51.676, 99%: 750.082, max_rt: 2442.874, 10438|2167.140, 1042|20.160, 1046|1849.807, 1041|82.508 60, trx: 11368, 95%: 46.801, 99%: 256.711, max_rt: 2374.197, 11346|2258.782, 1139|219.055, 1141|3125.147, 1139|292.105 70, trx: 10519, 95%: 54.684, 99%: 473.050, max_rt: 664.828, 10496|638.403, 1051|23.154, 1051|904.034, 1057|74.950 80, trx: 7075, 95%: 452.821, 99%: 628.460, max_rt: 674.919, 7102|633.787, 710|25.796, 707|842.346, 705|67.658 90, trx: 6521, 95%: 536.102, 99%: 731.457, max_rt: 772.960, 6487|743.943, 649|27.393, 651|1323.053, 655|72.516 100, trx: 6536, 95%: 539.644, 99%: 735.409, max_rt: 773.734, 6546|741.426, 655|27.811, 655|935.751, 653|68.155 STOPPING THREADS.................................................................................................... <Raw Results> [0] sc:7 lt:96949 rt:0 fl:0 avg_rt: 57.9 (5) [1] sc:5614 lt:91261 rt:0 fl:0 avg_rt: 22.2 (5) [2] sc:8412 lt:1283 rt:0 fl:0 avg_rt: 3.1 (5) [3] sc:107 lt:9570 rt:0 fl:0 avg_rt: 287.9 (80) [4] sc:45 lt:9656 rt:0 fl:0 avg_rt: 40.8 (20) in 100 sec. <Raw Results2(sum ver.)> [0] sc:7 lt:96952 rt:0 fl:0 [1] sc:5616 lt:91339 rt:0 fl:0 [2] sc:8412 lt:1283 rt:0 fl:0 [3] sc:107 lt:9573 rt:0 fl:0 [4] sc:45 lt:9656 rt:0 fl:0 <Constraint Check> (all must be [OK]) [transaction percentage] Payment: 43.46% (>=43.0%) [OK] Order-Status: 4.35% (>= 4.0%) [OK] Delivery: 4.34% (>= 4.0%) [OK] Stock-Level: 4.35% (>= 4.0%) [OK] [response time (at least 90% passed)] New-Order: 0.01% [NG] * Payment: 5.80% [NG] * Order-Status: 86.77% [NG] * Delivery: 1.11% [NG] * Stock-Level: 0.46% [NG] * <TpmC> 58173.602 TpmC 響應時間全都沒有達標 [mysql@pro-pnh-310-db-tidb-mp-45 tpcc-mysql]$ ./tpcc_start -h10.34.255.45 -P3400 -dtpcc10 -u test1 -p 123456 -w 200 -c50 -r20 -l208 *************************************** *** ###easy### TPC-C Load Generator *** *************************************** option h with value '10.34.255.45' option P with value '3400' option d with value 'tpcc10' option u with value 'test1' option p with value '123456' option w with value '200' option c with value '50' option r with value '20' option l with value '208' <Parameters> [server]: 10.34.255.45 [port]: 3400 [DBname]: tpcc10 [user]: test1 [pass]: 123456 [warehouse]: 200 [connection]: 50 [rampup]: 20 (sec.) [measure]: 208 (sec.) RAMP-UP TIME.(20 sec.) MEASURING START. 10, trx: 9263, 95%: 26.973, 99%: 144.838, max_rt: 410.861, 9250|315.315, 928|12.621, 938|107.277, 932|65.954 20, trx: 7934, 95%: 181.131, 99%: 322.771, max_rt: 446.643, 7915|367.040, 793|8.294, 795|76.614, 794|60.340 30, trx: 5361, 95%: 242.155, 99%: 337.797, max_rt: 473.042, 5330|369.023, 536|10.537, 534|90.223, 534|71.595 40, trx: 5221, 95%: 273.202, 99%: 388.478, max_rt: 598.932, 5199|290.829, 523|9.532, 521|122.560, 522|94.026 50, trx: 5673, 95%: 238.059, 99%: 345.466, max_rt: 552.519, 5655|456.236, 567|8.636, 568|99.298, 566|69.604 60, trx: 5282, 95%: 276.742, 99%: 383.969, max_rt: 644.765, 5247|390.521, 528|6.834, 529|99.629, 531|70.340 70, trx: 5683, 95%: 217.027, 99%: 333.576, max_rt: 596.013, 5663|280.808, 569|9.131, 568|122.913, 567|78.860 80, trx: 6109, 95%: 208.869, 99%: 286.691, max_rt: 456.596, 6089|353.057, 610|15.060, 612|97.958, 613|68.597 90, trx: 6134, 95%: 212.272, 99%: 297.622, max_rt: 444.973, 6120|291.372, 615|11.032, 614|111.847, 614|77.352 100, trx: 6398, 95%: 194.099, 99%: 292.850, max_rt: 459.207, 6383|321.490, 639|11.582, 637|149.817, 637|73.901 110, trx: 5779, 95%: 240.134, 99%: 387.664, max_rt: 575.255, 5749|554.402, 578|14.653, 578|173.642, 578|67.337 120, trx: 6510, 95%: 199.877, 99%: 349.314, max_rt: 504.284, 6491|422.438, 651|9.822, 651|128.985, 651|66.313 130, trx: 5970, 95%: 207.063, 99%: 385.581, max_rt: 695.253, 5934|644.161, 596|10.965, 592|86.854, 592|65.733 140, trx: 8507, 95%: 155.906, 99%: 275.337, max_rt: 514.386, 8496|310.635, 852|17.959, 858|274.492, 856|70.488 150, trx: 8831, 95%: 162.529, 99%: 381.563, max_rt: 637.602, 8815|420.607, 883|13.819, 881|130.644, 883|72.577 160, trx: 9798, 95%: 131.686, 99%: 271.328, max_rt: 471.466, 9770|353.452, 979|9.282, 970|161.580, 973|72.944 170, trx: 9755, 95%: 140.651, 99%: 280.495, max_rt: 595.614, 9736|302.171, 976|12.042, 977|168.678, 975|82.372 180, trx: 9404, 95%: 144.621, 99%: 259.647, max_rt: 580.586, 9386|381.516, 940|14.577, 942|145.959, 940|66.833 190, trx: 10478, 95%: 120.593, 99%: 206.939, max_rt: 426.735, 10447|257.267, 1048|8.470, 1042|167.855, 1051|82.607 200, trx: 9598, 95%: 141.877, 99%: 258.484, max_rt: 451.149, 9592|253.454, 961|8.619, 974|114.493, 966|76.047 STOPPING THREADS.................................................. <Raw Results> [0] sc:1492 lt:146196 rt:0 fl:0 avg_rt: 47.5 (5) [1] sc:89235 lt:58033 rt:0 fl:0 avg_rt: 16.4 (5) [2] sc:14560 lt:212 rt:0 fl:0 avg_rt: 2.0 (5) [3] sc:14393 lt:388 rt:0 fl:0 avg_rt: 56.5 (80) [4] sc:243 lt:14532 rt:0 fl:0 avg_rt: 41.9 (20) in 200 sec. <Raw Results2(sum ver.)> [0] sc:1492 lt:146212 rt:0 fl:0 [1] sc:89393 lt:58332 rt:0 fl:0 [2] sc:14560 lt:212 rt:0 fl:0 [3] sc:14394 lt:388 rt:0 fl:0 [4] sc:243 lt:14533 rt:0 fl:0 <Constraint Check> (all must be [OK]) [transaction percentage] Payment: 43.41% (>=43.0%) [OK] Order-Status: 4.35% (>= 4.0%) [OK] Delivery: 4.36% (>= 4.0%) [OK] Stock-Level: 4.35% (>= 4.0%) [OK] [response time (at least 90% passed)] New-Order: 1.01% [NG] * Payment: 60.59% [NG] * Order-Status: 98.56% [OK] Delivery: 97.38% [OK] Stock-Level: 1.64% [NG] * <TpmC> 44306.398 TpmC
五 tidb單機部署在這臺機器，tidb配置如下：
server_configs:
tidb:
log.slow-threshold: 300
tikv:
readpool.storage.use-unified-pool: false
readpool.coprocessor.use-unified-pool: true
pd:
replication.enable-placement-rules: true
replication.location-labels: ["host"]
tiflash:
logger.level: "info"
pd_servers:
- host: 10.34.255.45
tidb_servers:
- host: 10.34.255.45
tikv_servers:
- host: 10.34.255.45
port: 20160
status_port: 20180
config:
server.labels: { host: "logic-host-1" }
- host: 10.34.255.45
port: 20161
status_port: 20181
config:
server.labels: { host: "logic-host-2" }
- host: 10.34.255.45
port: 20162
status_port: 20182
config:
server.labels: { host: "logic-host-3" }
tiflash_servers:
- host: 10.34.255.45
monitoring_servers:
- host: 10.34.255.45
六 tidb壓測50會話200個warehouse結果如下
[tidb@pro-pnh-310-db-tidb-mp-45 tpcc-mysql]$ ./tpcc_start -h10.34.255.45 -P4000 -dtpcc22 -u test1 -p 123456 -w 200 -c50 -r20 -l208 *************************************** *** ###easy### TPC-C Load Generator *** *************************************** option h with value '10.34.255.45' option P with value '4000' option d with value 'tpcc22' option u with value 'test1' option p with value '123456' option w with value '200' option c with value '50' option r with value '20' option l with value '208' <Parameters> [server]: 10.34.255.45 [port]: 4000 [DBname]: tpcc22 [user]: test1 [pass]: 123456 [warehouse]: 200 [connection]: 50 [rampup]: 20 (sec.) [measure]: 208 (sec.) RAMP-UP TIME.(20 sec.) MEASURING START. 10, trx: 1894, 95%: 184.911, 99%: 228.425, max_rt: 419.815, 1904|225.239, 190|234.463, 191|688.781, 191|1058.326 20, trx: 1919, 95%: 181.511, 99%: 225.774, max_rt: 406.138, 1913|199.709, 191|117.078, 190|801.522, 191|1020.029 30, trx: 1931, 95%: 181.620, 99%: 203.438, max_rt: 501.335, 1934|185.152, 193|136.995, 193|691.629, 193|669.603 40, trx: 1924, 95%: 181.511, 99%: 209.683, max_rt: 313.783, 1924|195.546, 194|188.967, 193|507.702, 192|784.193 50, trx: 1922, 95%: 189.449, 99%: 211.321, max_rt: 285.126, 1917|200.075, 192|153.466, 192|575.980, 192|683.009 60, trx: 1797, 95%: 195.674, 99%: 230.141, max_rt: 375.590, 1801|234.971, 180|180.542, 181|588.481, 180|706.620 70, trx: 1770, 95%: 202.285, 99%: 234.592, max_rt: 333.669, 1766|182.932, 176|97.157, 176|583.384, 177|1022.607 80, trx: 1775, 95%: 195.323, 99%: 221.821, max_rt: 284.581, 1771|189.087, 177|192.068, 177|541.823, 178|734.427 90, trx: 1815, 95%: 190.245, 99%: 217.808, max_rt: 311.964, 1819|239.425, 183|75.470, 182|523.667, 182|712.793 100, trx: 1850, 95%: 186.523, 99%: 211.765, max_rt: 316.976, 1847|230.168, 184|67.657, 184|587.424, 184|735.382 110, trx: 1782, 95%: 195.323, 99%: 224.359, max_rt: 337.561, 1778|243.081, 178|103.894, 177|534.066, 177|749.434 120, trx: 1729, 95%: 207.311, 99%: 241.938, max_rt: 351.779, 1728|190.743, 173|103.619, 174|581.997, 174|721.485 130, trx: 1761, 95%: 202.466, 99%: 228.015, max_rt: 325.208, 1763|234.207, 176|98.340, 176|556.022, 178|728.752 140, trx: 1739, 95%: 198.982, 99%: 226.586, max_rt: 295.700, 1735|188.269, 174|320.388, 174|565.611, 171|743.583 150, trx: 1767, 95%: 197.026, 99%: 218.199, max_rt: 328.001, 1770|230.835, 177|85.891, 177|543.139, 178|753.661 160, trx: 1775, 95%: 193.809, 99%: 219.838, max_rt: 298.824, 1782|234.375, 178|93.494, 178|548.749, 179|736.862 170, trx: 1857, 95%: 185.799, 99%: 208.244, max_rt: 308.096, 1850|172.462, 185|111.779, 185|536.006, 184|708.815 180, trx: 1866, 95%: 185.632, 99%: 206.939, max_rt: 306.884, 1866|200.492, 187|133.564, 187|531.415, 186|698.243 190, trx: 1858, 95%: 187.587, 99%: 206.630, max_rt: 290.377, 1860|174.144, 185|120.448, 186|563.456, 187|717.468 200, trx: 1831, 95%: 188.826, 99%: 218.657, max_rt: 330.544, 1829|205.959, 183|103.308, 183|597.568, 182|806.336 STOPPING THREADS.................................................. <Raw Results> [0] sc:0 lt:36562 rt:0 fl:0 avg_rt: 145.1 (5) [1] sc:0 lt:36557 rt:0 fl:0 avg_rt: 39.7 (5) [2] sc:0 lt:3656 rt:0 fl:0 avg_rt: 32.0 (5) [3] sc:0 lt:3656 rt:0 fl:0 avg_rt: 497.5 (80) [4] sc:0 lt:3656 rt:0 fl:0 avg_rt: 630.1 (20) in 200 sec. <Raw Results2(sum ver.)> [0] sc:0 lt:36562 rt:0 fl:0 [1] sc:0 lt:36568 rt:0 fl:0 [2] sc:0 lt:3656 rt:0 fl:0 [3] sc:0 lt:3656 rt:0 fl:0 [4] sc:0 lt:3656 rt:0 fl:0 <Constraint Check> (all must be [OK]) [transaction percentage] Payment: 43.48% (>=43.0%) [OK] Order-Status: 4.35% (>= 4.0%) [OK] Delivery: 4.35% (>= 4.0%) [OK] Stock-Level: 4.35% (>= 4.0%) [OK] [response time (at least 90% passed)] New-Order: 0.00% [NG] * Payment: 0.00% [NG] * Order-Status: 0.00% [NG] * Delivery: 0.00% [NG] * Stock-Level: 0.00% [NG] * <TpmC> 10968.600 TpmC 對這個結果我有疑惑地方是：95%: 184.911，意思是new-order需要184秒嗎？我透過tidb的慢SQL監控到，沒有慢SQL，所有的SQL 執行都是1秒一下，非常優秀，大部分都是幾毫秒。對比mysql單機壓測結果，
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/30393770/viewspace-2923605/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 【Tpcc-mysql】Tpcc-mysql測試MySql
- 軟體壓力測試怎麼做?出具壓力測試報告軟體測評中心測試報告
- 讓測試事半功倍軟體壓力測試工具分享，壓力測試報告怎麼收費?測試報告
- 軟體產品為什麼要做壓力測試?壓力測試報告如何獲取?測試報告
- 軟體壓力測試流程和測試工具分享，讓你寫壓力測試報告再也不愁測試報告
- 阿里雲原生資料庫POLARDB壓力測試報告阿里資料庫測試報告
- Redis5 壓力測試結果反饋報告Redis
- 為 java 開發者設計的效能測試框架，用於壓測+測試報告生成Java框架測試報告
- 軟體壓力測試有哪些測試流程?軟體測試報告收費情況測試報告
- python報名系統抗壓測試Python
- 告別傳統壓測：全鏈路壓測在中通的實踐分享
- 通過錄制指令碼進行壓測，生成的測試報告真的有價值嗎？指令碼測試報告
- Jmeter系列（43）- 詳解 Jmeter 圖形化 HTML 壓測報告之 Charts 模組JMeterHTML
- Allure測試報告測試報告
- Jumper 測試報告測試報告
- 雲測試報告測試報告
- 軟體壓力測試常見流程有哪些?專業出具軟體測試報告公司分享測試報告
- 測試總結報告
- 滲透測試報告測試報告
- 測試計劃和測試報告測試報告
- locust壓測
- ClickHouse壓測
- 壓測流程
- Taurus.MVC 效能壓力測試（ap 壓測 和 linux 下wrk 壓測）：.NET 版本MVCLinux
- Dentsu：2022年全球廣告預測報告
- pytest-testreport測試報告測試報告
- CNAS軟體測試報告測試報告
- 雲服務測試報告測試報告
- 軟體測試--缺陷報告
- 運維攻堅之jmeter壓力測試報錯運維JMeter
- Taurus.MVC 效能壓力測試（ap 壓測 和 linux 下wrk 壓測）：.NET Core 版本MVCLinux
- 全鏈路壓測演進之迭代式壓測
- apache ab壓力測試工具-批次壓測指令碼Apache指令碼
- 壓力測試
- kafka壓測工具Kafka
- 談談壓測
- 壓測工具 wrk
- mysqlslap效能壓測MySql