Mac mini (M4) vs Win11(i7-8700K) MySQL 9.3.0 vs 阿里云 RDS 压测结果

MAC 安装 sysbench

brew install sysbench

下载MYSQL

https://dev.mysql.com/downloads/mysql/

mac: mysql-9.3.0-macos15-arm64.dmg

win:  mysql-9.3.0-winx64.msi

查看版本

mysql --version

mac:   mysql  Ver 14.14 Distrib 5.7.24, for osx11.1 (x86_64) using  EditLine wrapper

win:  mysql  Ver 14.14 Distrib 5.7.40, for Win64 (x86_64)

 

初始化测试数据库

mysql -u root -p -e "CREATE DATABASE sbtest;"

mac:

sysbench /opt/homebrew/Cellar/sysbench/1.0.20_7/share/sysbench/oltp_read_write.lua --db-driver=mysql --mysql-host=127.0.0.1 --mysql-user=root --mysql-password=xxxxxxxx  --mysql-db=sbtest prepare

win:

sysbench /usr/share/sysbench/oltp_read_write.lua --db-driver=mysql --mysql-host=192.168.56.1 --mysql-user=root --mysql-password=root --mysql-db=sbtest prepare

读取测试

mac:

sysbench /opt/homebrew/Cellar/sysbench/1.0.20_7/share/sysbench/oltp_read_only.lua --db-driver=mysql --mysql-host=127.0.0.1 --mysql-user=root --mysql-password=xxxxxxxx --mysql-db=sbtest --threads=4 --time=60 run

 win:

sysbench /usr/share/sysbench/oltp_read_only.lua --db-driver=mysql --mysql-host=192.168.56.1 --mysql-user=root --mysql-password=root --mysql-db=sbtest --threads=4 --time=60 run

 

mac / win

SQL statistics:
queries performed:
读数 read: 5254732 / 1219176
write: 0
other: 750676 / 174168
总数total: 6005408 / 1393344
总事务数transactions: 375338 / 87084 (6255.48 / 1451.31 per sec.)
总操作数queries: 6005408 / 1393344 (100087.76 / 23221.00 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)

General statistics:
total time: 60.0013s
总执行数量total number of events: 375338 / 87084

Latency (ms):
最小耗时min: 0.50 /  2.05
平均耗时avg: 0.64 /  2.05
最大耗时max: 3.22 / 45.60
95th percentile: 0.00 / 4.10
sum: 239935.96 / 239814.57

Threads fairness:
平均每个线程执行 event 的数量events (avg/stddev): 93834.5000/53.69     -      21771.0000/1331.59
平均每个线程的执行时间 execution time (avg/stddev): 59.9840/0.00   -   59.9536/0.02

 

 写入测试

sysbench /opt/homebrew/Cellar/sysbench/1.0.20_7/share/sysbench/oltp_write_only.lua --db-driver=mysql --mysql-host=127.0.0.1 --mysql-user=root --mysql-password=xxxxxxxxx  --mysql-db=sbtest --threads=4 --time=60 run

 

SQL statistics:
queries performed:
read: 0
write: 3807755
other: 1903939
total: 5711694
transactions: 951842 (15863.78 per sec.)
queries: 5711694 (95193.37 per sec.)
ignored errors: 255 (4.25 per sec.)
reconnects: 0 (0.00 per sec.)

General statistics:
total time: 60.0008s
total number of events: 951842

Latency (ms):
min: 0.17
avg: 0.25
max: 10.87
95th percentile: 0.00
sum: 239845.47

Threads fairness:
events (avg/stddev): 237960.5000/52.08
execution time (avg/stddev): 59.9614/0.00

 

混合读写测试

sysbench /opt/homebrew/Cellar/sysbench/1.0.20_7/share/sysbench/oltp_read_write.lua --db-driver=mysql --mysql-host=127.0.0.1 --mysql-user=root --mysql-password=xxxxxxxx --mysql-db=sbtest --threads=4 --time=60 run

 

SQL statistics:
queries performed:
read: 4164034
write: 1189670
other: 594839
total: 5948543
transactions: 297408 (4956.68 per sec.)
queries: 5948543 (99140.00 per sec.)
ignored errors: 23 (0.38 per sec.)
reconnects: 0 (0.00 per sec.)

General statistics:
total time: 60.0013s
total number of events: 297408

Latency (ms):
min: 0.63
avg: 0.81
max: 5.48
95th percentile: 0.00
sum: 239943.08

Threads fairness:
events (avg/stddev): 74352.0000/40.17
execution time (avg/stddev): 59.9858/0.00

 

阿里云 RDS

2c/4G iops4300 
通用型倚天版

MySQL8.0

SQL statistics:
queries performed:
read: 19894
write: 2912
other: 5614
total: 28420
transactions: 1421 (23.55 per sec.)
queries: 28420 (471.09 per sec.)
ignored errors: 0 (0.00 per sec.)
reconnects: 0 (0.00 per sec.)

General statistics:
total time: 60.3257s
total number of events: 1421

Latency (ms):
min: 296.48
avg: 338.76
max: 610.25
95th percentile: 442.73
sum: 481371.17

Threads fairness:
events (avg/stddev): 177.6250/5.00
execution time (avg/stddev): 60.1714/0.10