10.1.性能测试

redis

机器条件

操作系统：Windows 10专业版
处理器：lntel(R)Core(TM) i5-6200U CPU @2.30GHz 2.40 GHz
已安装的内存(RAM)：16.0 GB (15.9 GB可用)
系统类型：64位操作系统，基于x64的处理器

测试一：RPS测试

C:\Users\moluo>redis-benchmark -n 10000 -q
PING_INLINE: 9345.79 requests per second
PING_BULK: 9380.86 requests per second
SET: 9871.67 requests per second
GET: 8984.73 requests per second
INCR: 9425.07 requests per second
LPUSH: 6501.95 requests per second
RPUSH: 6605.02 requests per second
LPOP: 5878.90 requests per second
RPOP: 5296.61 requests per second
SADD: 6544.50 requests per second
SPOP: 6418.49 requests per second
LPUSH (needed to benchmark LRANGE): 6570.30 requests per second
LRANGE_100 (first 100 elements): 5640.16 requests per second
LRANGE_300 (first 300 elements): 3563.79 requests per second
LRANGE_500 (first 450 elements): 3020.24 requests per second
LRANGE_600 (first 600 elements): 2573.34 requests per second
MSET (10 keys): 5274.26 requests per second

结论：

支持万级RPS，随着请求数增加，RPS逐渐下降

测试二：延时测试

C:\Users\moluo>redis-benchmark -n 10000
====== PING_INLINE ======
  10000 requests completed in 1.16 seconds
  50 parallel clients
  3 bytes payload
  keep alive: 1

0.01% <= 1 milliseconds
3.36% <= 2 milliseconds
65.15% <= 3 milliseconds
88.40% <= 4 milliseconds
96.55% <= 5 milliseconds
98.22% <= 6 milliseconds
99.14% <= 7 milliseconds
99.53% <= 8 milliseconds
99.86% <= 9 milliseconds
99.94% <= 10 milliseconds
100.00% <= 11 milliseconds
8591.07 requests per second

====== PING_BULK ======
  10000 requests completed in 1.02 seconds
  50 parallel clients
  3 bytes payload
  keep alive: 1

0.03% <= 1 milliseconds
19.47% <= 2 milliseconds
71.38% <= 3 milliseconds
95.51% <= 4 milliseconds
99.36% <= 5 milliseconds
99.96% <= 6 milliseconds
99.98% <= 7 milliseconds
100.00% <= 8 milliseconds
9832.84 requests per second

====== SET ======
  10000 requests completed in 1.04 seconds
  50 parallel clients
  3 bytes payload
  keep alive: 1

0.01% <= 1 milliseconds
20.98% <= 2 milliseconds
74.51% <= 3 milliseconds
91.38% <= 4 milliseconds
96.96% <= 5 milliseconds
98.78% <= 6 milliseconds
99.49% <= 7 milliseconds
99.85% <= 8 milliseconds
99.98% <= 9 milliseconds
100.00% <= 10 milliseconds
9615.38 requests per second

====== GET ======
  10000 requests completed in 1.13 seconds
  50 parallel clients
  3 bytes payload
  keep alive: 1

0.01% <= 1 milliseconds
5.36% <= 2 milliseconds
64.18% <= 3 milliseconds
91.13% <= 4 milliseconds
97.01% <= 5 milliseconds
98.80% <= 6 milliseconds
99.33% <= 7 milliseconds
99.59% <= 8 milliseconds
99.70% <= 9 milliseconds
99.78% <= 10 milliseconds
99.84% <= 11 milliseconds
99.98% <= 12 milliseconds
100.00% <= 12 milliseconds
8818.34 requests per second

====== INCR ======
  10000 requests completed in 1.13 seconds
  50 parallel clients
  3 bytes payload
  keep alive: 1

0.26% <= 1 milliseconds
11.77% <= 2 milliseconds
68.43% <= 3 milliseconds
84.78% <= 4 milliseconds
96.75% <= 5 milliseconds
98.44% <= 6 milliseconds
99.25% <= 7 milliseconds
99.83% <= 8 milliseconds
99.95% <= 9 milliseconds
100.00% <= 10 milliseconds
8880.99 requests per second

====== LPUSH ======
  10000 requests completed in 1.52 seconds
  50 parallel clients
  3 bytes payload
  keep alive: 1

0.01% <= 1 milliseconds
0.62% <= 2 milliseconds
14.23% <= 3 milliseconds
54.90% <= 4 milliseconds
88.43% <= 5 milliseconds
97.19% <= 6 milliseconds
99.12% <= 7 milliseconds
99.62% <= 8 milliseconds
99.71% <= 9 milliseconds
99.77% <= 10 milliseconds
99.90% <= 11 milliseconds
99.95% <= 12 milliseconds
99.97% <= 13 milliseconds
99.99% <= 14 milliseconds
100.00% <= 14 milliseconds
6578.95 requests per second

====== RPUSH ======
  10000 requests completed in 1.52 seconds
  50 parallel clients
  3 bytes payload
  keep alive: 1

0.01% <= 1 milliseconds
0.37% <= 2 milliseconds
10.34% <= 3 milliseconds
62.55% <= 4 milliseconds
91.16% <= 5 milliseconds
97.97% <= 6 milliseconds
99.65% <= 7 milliseconds
99.85% <= 8 milliseconds
99.92% <= 9 milliseconds
99.98% <= 10 milliseconds
100.00% <= 11 milliseconds
6591.96 requests per second

====== LPOP ======
  10000 requests completed in 1.50 seconds
  50 parallel clients
  3 bytes payload
  keep alive: 1

0.01% <= 1 milliseconds
1.08% <= 2 milliseconds
12.15% <= 3 milliseconds
58.53% <= 4 milliseconds
91.33% <= 5 milliseconds
98.33% <= 6 milliseconds
99.58% <= 7 milliseconds
99.85% <= 8 milliseconds
99.91% <= 9 milliseconds
99.97% <= 10 milliseconds
99.99% <= 11 milliseconds
100.00% <= 11 milliseconds
6657.79 requests per second

====== RPOP ======
  10000 requests completed in 1.52 seconds
  50 parallel clients
  3 bytes payload
  keep alive: 1

0.01% <= 1 milliseconds
0.14% <= 2 milliseconds
11.63% <= 3 milliseconds
54.73% <= 4 milliseconds
89.90% <= 5 milliseconds
97.85% <= 6 milliseconds
99.14% <= 7 milliseconds
99.37% <= 8 milliseconds
99.60% <= 9 milliseconds
99.64% <= 10 milliseconds
99.68% <= 11 milliseconds
99.85% <= 12 milliseconds
99.87% <= 14 milliseconds
99.91% <= 15 milliseconds
99.96% <= 16 milliseconds
100.00% <= 17 milliseconds
6565.99 requests per second

====== SADD ======
  10000 requests completed in 1.56 seconds
  50 parallel clients
  3 bytes payload
  keep alive: 1

0.01% <= 1 milliseconds
1.00% <= 2 milliseconds
14.17% <= 3 milliseconds
51.89% <= 4 milliseconds
86.57% <= 5 milliseconds
94.91% <= 6 milliseconds
97.13% <= 7 milliseconds
98.32% <= 8 milliseconds
99.29% <= 9 milliseconds
99.72% <= 10 milliseconds
99.91% <= 11 milliseconds
99.94% <= 12 milliseconds
100.00% <= 13 milliseconds
6410.26 requests per second

====== SPOP ======
  10000 requests completed in 1.73 seconds
  50 parallel clients
  3 bytes payload
  keep alive: 1

0.01% <= 1 milliseconds
0.77% <= 2 milliseconds
11.05% <= 3 milliseconds
41.86% <= 4 milliseconds
70.21% <= 5 milliseconds
88.55% <= 6 milliseconds
95.72% <= 7 milliseconds
97.97% <= 8 milliseconds
99.03% <= 9 milliseconds
99.41% <= 10 milliseconds
99.72% <= 11 milliseconds
99.87% <= 12 milliseconds
99.94% <= 13 milliseconds
99.99% <= 14 milliseconds
100.00% <= 14 milliseconds
5783.69 requests per second

====== LPUSH (needed to benchmark LRANGE) ======
  10000 requests completed in 1.50 seconds
  50 parallel clients
  3 bytes payload
  keep alive: 1

0.01% <= 1 milliseconds
0.92% <= 2 milliseconds
12.20% <= 3 milliseconds
61.53% <= 4 milliseconds
93.55% <= 5 milliseconds
98.17% <= 6 milliseconds
99.61% <= 7 milliseconds
99.87% <= 8 milliseconds
99.94% <= 9 milliseconds
99.98% <= 10 milliseconds
100.00% <= 12 milliseconds
6671.11 requests per second

====== LRANGE_100 (first 100 elements) ======
  10000 requests completed in 1.72 seconds
  50 parallel clients
  3 bytes payload
  keep alive: 1

0.01% <= 2 milliseconds
2.14% <= 3 milliseconds
30.21% <= 4 milliseconds
76.74% <= 5 milliseconds
95.51% <= 6 milliseconds
98.73% <= 7 milliseconds
99.38% <= 8 milliseconds
99.57% <= 9 milliseconds
99.89% <= 10 milliseconds
99.96% <= 11 milliseconds
99.99% <= 12 milliseconds
100.00% <= 12 milliseconds
5800.46 requests per second

====== LRANGE_300 (first 300 elements) ======
  10000 requests completed in 2.25 seconds
  50 parallel clients
  3 bytes payload
  keep alive: 1

0.01% <= 3 milliseconds
1.07% <= 4 milliseconds
23.53% <= 5 milliseconds
68.94% <= 6 milliseconds
91.43% <= 7 milliseconds
96.05% <= 8 milliseconds
98.51% <= 9 milliseconds
99.62% <= 10 milliseconds
99.85% <= 11 milliseconds
99.92% <= 12 milliseconds
99.97% <= 13 milliseconds
99.99% <= 15 milliseconds
100.00% <= 17 milliseconds
4450.38 requests per second

====== LRANGE_500 (first 450 elements) ======
  10000 requests completed in 2.65 seconds
  50 parallel clients
  3 bytes payload
  keep alive: 1

0.01% <= 3 milliseconds
0.08% <= 4 milliseconds
3.80% <= 5 milliseconds
29.58% <= 6 milliseconds
74.03% <= 7 milliseconds
91.38% <= 8 milliseconds
95.63% <= 9 milliseconds
97.73% <= 10 milliseconds
98.77% <= 11 milliseconds
99.21% <= 12 milliseconds
99.28% <= 13 milliseconds
99.39% <= 14 milliseconds
99.53% <= 15 milliseconds
99.56% <= 16 milliseconds
99.58% <= 17 milliseconds
99.61% <= 18 milliseconds
99.64% <= 19 milliseconds
99.68% <= 20 milliseconds
99.71% <= 21 milliseconds
99.72% <= 22 milliseconds
99.75% <= 23 milliseconds
99.77% <= 24 milliseconds
99.79% <= 25 milliseconds
99.80% <= 26 milliseconds
99.83% <= 27 milliseconds
99.86% <= 28 milliseconds
99.89% <= 29 milliseconds
99.91% <= 31 milliseconds
99.92% <= 32 milliseconds
99.94% <= 33 milliseconds
99.95% <= 35 milliseconds
99.96% <= 37 milliseconds
99.97% <= 39 milliseconds
100.00% <= 40 milliseconds
3775.01 requests per second

====== LRANGE_600 (first 600 elements) ======
  10000 requests completed in 3.00 seconds
  50 parallel clients
  3 bytes payload
  keep alive: 1

0.01% <= 3 milliseconds
0.02% <= 4 milliseconds
0.70% <= 5 milliseconds
7.52% <= 6 milliseconds
33.14% <= 7 milliseconds
74.28% <= 8 milliseconds
91.33% <= 9 milliseconds
95.73% <= 10 milliseconds
97.55% <= 11 milliseconds
99.10% <= 12 milliseconds
99.67% <= 13 milliseconds
99.76% <= 14 milliseconds
99.77% <= 15 milliseconds
99.80% <= 16 milliseconds
99.81% <= 17 milliseconds
99.90% <= 18 milliseconds
99.99% <= 19 milliseconds
100.00% <= 19 milliseconds
3334.44 requests per second

====== MSET (10 keys) ======
  10000 requests completed in 1.70 seconds
  50 parallel clients
  3 bytes payload
  keep alive: 1

0.01% <= 2 milliseconds
3.03% <= 3 milliseconds
47.54% <= 4 milliseconds
80.16% <= 5 milliseconds
91.78% <= 6 milliseconds
96.45% <= 7 milliseconds
97.88% <= 8 milliseconds
98.85% <= 9 milliseconds
99.36% <= 10 milliseconds
99.77% <= 11 milliseconds
99.90% <= 12 milliseconds
99.98% <= 13 milliseconds
100.00% <= 13 milliseconds
5885.81 requests per second

结论

10ms级别

Mysql

机器条件

操作系统：Windows 10专业版
处理器：lntel(R)Core(TM) i5-6200U CPU @2.30GHz 2.40 GHz
已安装的内存(RAM)：16.0 GB (15.9 GB可用)
系统类型：64位操作系统，基于x64的处理器

测试：RPS测试

C:\Users\moluo>mysqlslap -a --number-of-queries=10000 -uroot -p123456aB
mysqlslap: [Warning] Using a password on the command line interface can be insecure.
Benchmark
        Average number of seconds to run all queries: 530.109 seconds
        Minimum number of seconds to run all queries: 530.109 seconds
        Maximum number of seconds to run all queries: 530.109 seconds
        Number of clients running queries: 1
        Average number of queries per client: 10000

结果中各项含义:
Average number of ：运行所有语句的平均秒数
Minimum number of ：运行所有语句的最小秒数
Maximum number of：运行所有语句的最大秒数
Number of clients：客户端数量
Average number of queries per client：每个客户端运行查询的平均数

结论

18 requests per second

参考文档

Redis 性能测试

Mysql 压力测试工具 mysqlslap

MySQL自带的性能压力测试工具mysqlslap详解

Previous1.1单元测试 Next2.1单元测试入门

Last updated 3 years ago

Was this helpful?