MYSQL基准测试

安装mysql(密码输入root)

apt update && apt install mysql-server -y

安装基准工具

apt install sysbench -y

创建测试数据库(有个警告，让你不要在命令行输入密码，无视它就行)

mysql -proot -e "create database test;"

创建500万测试数据

sysbench --test=oltp --oltp-table-size=5000000 --oltp-table-name=t_test --mysql-table-engine=innodb --mysql-host=localhost --mysql-db=test --mysql-user=root --mysql-password=root prepare

运行测试

sysbench --test=oltp --oltp-table-size=5000000 --oltp-table-name=t_test --mysql-table-engine=innodb --mysql-host=localhost --mysql-db=test --mysql-user=root --mysql-password=root run

清除测试数据

sysbench --test=oltp --oltp-table-size=5000000 --oltp-table-name=t_test --mysql-table-engine=innodb --mysql-host=localhost --mysql-db=test --mysql-user=root --mysql-password=root cleanup

一般我们比较关心：

transactions:                        10000  (514.48 per sec.)

read/write requests:                 190000 (9775.14 per sec.)

这代表每秒能处理的事务数，以及每秒的读写次数。

附上我的测试结果：

1G内存VPS：
OLTP test statistics:
    queries performed:
        read:                            140000
        write:                           50000
        other:                           20000
        total:                           210000
    transactions:                        10000  (88.77 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 190000 (1686.65 per sec.)
    other operations:                    20000  (177.54 per sec.)

1G内存VPS：

OLTP test statistics:
    queries performed:
        read:                            140000
        write:                           50000
        other:                           20000
        total:                           210000
    transactions:                        10000  (115.97 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 190000 (2203.47 per sec.)
    other operations:                    20000  (231.94 per sec.)

512M内存VPS：

OLTP test statistics:
    queries performed:
        read:                            140000
        write:                           50000
        other:                           20000
        total:                           210000
    transactions:                        10000  (81.30 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 190000 (1544.72 per sec.)
    other operations:                    20000  (162.60 per sec.)

阿里云1G内存VPS：

OLTP test statistics:
    queries performed:
        read:                            140000
        write:                           50000
        other:                           20000
        total:                           210000
    transactions:                        10000  (158.12 per sec.)
    deadlocks:                           0      (0.00 per sec.)
    read/write requests:                 190000 (3004.20 per sec.)
    other operations:                    20000  (316.23 per sec.)