作者： 18515065291 原文来源：https://tidb.net/blog/640ab73f

1、汇总

1.1、概述

为了查看 4.0.0-rc 版本的性能情况，进行压测

1.2、测试结果

【并发及 QPS、Latency 图】

2、具体

2.1、TiDB 情况

2.2.2、20 并发

sysbench ./tests/include/oltp_legacy/oltp.lua –mysql-host=tiflashtest –mysql-port=900 –mysql-user=test –mysql-password=xxx –oltp-test-mode=complex –oltp-tables-count=10 –oltp-table-size=10000000 –threads=20 –time=120 –report-interval=10 run

2.2.3、40 并发

sysbench ./tests/include/oltp_legacy/oltp.lua –mysql-host=tiflashtest –mysql-port=900 –mysql-user=test –mysql-password=xxx –oltp-test-mode=complex –oltp-tables-count=10 –oltp-table-size=10000000 –threads=40 –time=120 –report-interval=10 run

2.2.4、80 并发

sysbench ./tests/include/oltp_legacy/oltp.lua –mysql-host=tiflashtest –mysql-port=900 –mysql-user=test –mysql-password=xxx –oltp-test-mode=complex –oltp-tables-count=10 –oltp-table-size=10000000 –threads=80 –time=120 –report-interval=10 run

2.2.5、120 并发

sysbench ./tests/include/oltp_legacy/oltp.lua –mysql-host=tiflashtest –mysql-port=900 –mysql-user=test –mysql-password=xxx –oltp-test-mode=complex –oltp-tables-count=10 –oltp-table-size=10000000 –threads=120 –time=120 –report-interval=10 run

2.2.6、180 并发

sysbench ./tests/include/oltp_legacy/oltp.lua –mysql-host=tiflashtest –mysql-port=900 –mysql-user=test –mysql-password=xxx –oltp-test-mode=complex –oltp-tables-count=10 –oltp-table-size=10000000 –threads=180 –time=120 –report-interval=10 run

2.2.7、256 并发

sysbench ./tests/include/oltp_legacy/oltp.lua –mysql-host=tiflashtest –mysql-port=900 –mysql-user=test –mysql-password=xxx –oltp-test-mode=complex –oltp-tables-count=10 –oltp-table-size=10000000 –threads=256 –time=120 –report-interval=10 run

2.2.8、512 并发

sysbench ./tests/include/oltp_legacy/oltp.lua –mysql-host=tiflashtest.tdb –mysql-port=900 –mysql-user=test –mysql-password=xxx –oltp-test-mode=complex –oltp-tables-count=10 –oltp-table-size=10000000 –threads=512 –time=120 –report-interval=10 run

3、监控情况

​ 3.1、grafana 监控

​

​

​

​

​