新老ECS数据库速度对比

mysqlslap -a --concurrency=100 --number-of-queries 5000 --iterations=10 -e innodb -uroot -p
mysqlslap: [Warning] Using a password on the command line interface can be insecure.
Benchmark
Running for engine innodb
Average number of seconds to run all queries: 3.748 seconds
Minimum number of seconds to run all queries: 3.703 seconds
Maximum number of seconds to run all queries: 3.831 seconds
Number of clients running queries: 100
Average number of queries per client: 50

mysqlslap -a --concurrency=100 --number-of-queries 10000 --iterations=10 -e innodb -uroot -p
mysqlslap: [Warning] Using a password on the command line interface can be insecure.
Benchmark
        Running for engine innodb
        Average number of seconds to run all queries: 12.683 seconds
        Minimum number of seconds to run all queries: 12.300 seconds
        Maximum number of seconds to run all queries: 12.944 seconds
        Number of clients running queries: 100
        Average number of queries per client: 100

 老机器配置

数据盘： /dev/xvdb20GBSSD 云盘

实例： 1 核 4GB系列 II通用型 n2

I/O 优化实例： I/O 优化实例

系统盘： /dev/xvdaSSD 云盘20GB

带宽： 1Mbps按固定带宽

CPU： 1核

可用区： 杭州可用区B

操作系统： CentOS 7.0 64位

内存： 4GB

地域： 杭州

网络类型： 经典网络

mysqlslap -a --concurrency=100 --number-of-queries 5000 --iterations=10 -e innodb -uroot -p
        Running for engine innodb
        Average number of seconds to run all queries: 1.484 seconds
        Minimum number of seconds to run all queries: 1.446 seconds
        Maximum number of seconds to run all queries: 1.541 seconds
        Number of clients running queries: 100
        Average number of queries per client: 50

mysqlslap -a --concurrency=100 --number-of-queries 10000 --iterations=10 -e innodb -uroot -p
Benchmark
        Running for engine innodb
        Average number of seconds to run all queries: 5.208 seconds
        Minimum number of seconds to run all queries: 5.157 seconds
        Maximum number of seconds to run all queries: 5.329 seconds
        Number of clients running queries: 100
        Average number of queries per client: 100

新机器配置

实例： 2核 4GB系列 III共享计算型 n4
I/O 优化实例： I/O 优化实例
系统盘： /dev/xvda高效云盘40GB
带宽： 1Mbps按固定带宽
CPU： 2核
可用区： 随机分配
操作系统： CentOS 7.4 64位
内存： 4GB
地域： 华东 2
网络类型： 专有网络
云盾： 是

新版的高效云盘与老版的SSD在读写速度上已经超越了