MySQL 5.6 VS 5.7 Pressure test report

MySQL 5.6 VS 5.7 pressure test report

Version	Name	Time
V1.0	Liu Jianbin	2016.3.2

1. Test conditions

2. 1. Software

Os:centos Release 6.7 (Final)

file format:XFS

MySQL:percona5.6.24 VS 5.7.10

Key Parameter Configuration (Yum install after initialization default, unmodified) :

Bufferpool size 16G

Sync_binlog=0

Innodb_flush_log_at_trx_commit= 2

Pressure measuring tool:sysbench-0.5

1. 2. Hardware information

L-db28.dba.cn2

Ssd:fio MEM:128GB cpu:e5-2650 v3

1. Test scenarios

each test data size:228GB, divided into Five test tables, each table 1.5kw rows of data.

Concurrent threads per test:2, 256,

time per test:6h= 21600s

Number of requests: unlimited

Read /write ratio:7:3; pure reading;

Test Description: The combination of each operating system and file system tests 4 concurrent threads including read-write mixed, read-only, write-only, such as complete one-time test (including read-write mixed, read-only, write-only), each machine takes time to 3*4*6 ( hours ) =3 ( days ).

3. Test Purpose

first, the test percona5.7.10 relative 5.6.24 in the performance of the increase in how much.

4. test Results (QPS)

read-write =7:3(each transaction contains a read operation,6 write operations)

number of threads	CENTOS6.7 && XFS mysql 5.6.24	centos6.7&&xfs  MySQL 5.7.10
2	6798.01	7668.14	0.13
	61831.76	70508.00	0.14
	57440.54	69010.98	0.20
256	55911.33	67604.37	0.21

read-only (contains 5 read operations per transaction)

number of threads	CENTOS6.7 && XFS mysql 5.6.24	centos6.7&&xfs  MySQL 5.7.10
2	4125.52	3563.29	-0.14
+	45931.19	44173.89	-0.04
	44365.23	56987.14	0.28
256	43795.13	56321.46	0.29

write-only (each transaction contains 4 write operations)

"

number of threads	CENTOS6.7 && XFS mysql 5.6.24	centos6.7&&xfs  MySQL 5.7.10
2	9952.04	8867.26	-0.11
+	40917.11	54590.28	0.33
	40018.07	49306.31	0.23
256	40258.40	40416.74	0.00

5. Test Conclusion

first, read and write 7:3 ,MySQL5.7 version of the relative 5.6 version of the system can enhance the 21%.

second, when read-only, MySQL5.7 version thread concurrency is low (2, threads), the performance and 5.6 version, but in large concurrency is higher, in the case of the concurrency of the three threads, performance improvement 29%.

three, only when writing, the MySQL5.7 version has the highest performance gains over 33% when thread concurrency is exceeded .

This article is from the "Floating Phoenix Year" blog, please be sure to keep this source http://liuzhanbin.blog.51cto.com/10060150/1760333

MySQL 5.6 VS 5.7 Pressure test report