操作系统:MAC电脑上虚拟出两个Linux(centos 7)
配置:2c2g
数据库版本:MySQL 5.7
vm1:安装 MySQL 5.7 数据库
vm2:安装 sysbench
https://help.aliyun.com/document_detail/53632.html
参考阿里云的帮忙文档,安装并优化操作系统参数,但虚拟机配置较低,
【sudo sh -c 'for x in /sys/class/net/eth0/queues/rx-*; do echo f>$x/rps_cpus; done'】这行参数我做了修改,只写了一个‘f’
sysbench --db-driver=mysql --mysql-host=172.16.1.10 --mysql-port=3306 --mysql-user=root --mysql-password=123456 --mysql-db=sbtest --table_size=25000 --tables=250 --events=0 --time=600 oltp_read_write prepare
8线程压测120秒
sysbench --db-driver=mysql --mysql-host=172.16.1.10 --mysql-port=3306 --mysql-user=root --mysql-password=123456 --mysql-db=sbtest --table_size=25000 --tables=250 --events=0 --time=120 --threads=8 --percentile=95 --report-interval=1 oltp_read_write run
SQL statistics: queries performed: read: 480130 write: 137180 other: 68590 total: 685900 transactions: 34295 (285.56 per sec.) queries: 685900 (5711.24 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.0947s total number of events: 34295 Latency (ms): min: 11.05 avg: 27.99 max: 152.91 95th percentile: 52.89 sum: 959995.88 Threads fairness: events (avg/stddev): 4286.8750/34.98 execution time (avg/stddev): 119.9995/0.02
SQL statistics: queries performed: read: 613130 write: 175180 other: 87590 total: 875900 transactions: 43795 (364.79 per sec.) queries: 875900 (7295.80 per sec.) ignored errors: 0 (0.00 per sec.) reconnects: 0 (0.00 per sec.) General statistics: total time: 120.0540s total number of events: 43795 Latency (ms): min: 6.73 avg: 21.92 max: 134.68 95th percentile: 44.17 sum: 959923.22 Threads fairness: events (avg/stddev): 5474.3750/25.90 execution time (avg/stddev): 119.9904/0.02
结论:
TPS | QPS | |
---|---|---|
开启SSL | 285.56 | 5711.24 |
关闭SSL | 364.79 | 7295.80 |
差值 | 79.23 | 1584.56 |
性能下降(%) | 21.7% | 21.7% |
性能下降算法: 差值/关闭SSL