Throughput test for MySQL 5.5 and MySQL 5.6

Percona mysql 5.5.33 and mysql 5.6.14 performance test comparison:

System: rhel 5.5,
Test Tool: sysbench
2-core CPU, hyper-threading, 4 logical CPUs
Innodb_buffer_pool_size is set to 1 GB, and the number of connections is set to 1000.
Test Time for each type of data: 30 minutes

Due to my limited io processing, I do not need to refresh the log at the time of submission. querycache is set to disabled.
Mysql> show global variables like '% innodb_flush_log_at_trx_commit % ';
+ -------------------------------- + ------- +
| Variable_name | Value |
+ -------------------------------- + ------- +
| Innodb_flush_log_at_trx_commit | 0 |
+ -------------------------------- + ------- +
1 row in set (0.00 sec)

Mysql> show global variables like '% query_cache % ';
+ ------------------------------ + --------- +
| Variable_name | Value |
+ ------------------------------ + --------- +
| Have_query_cache | YES |
| Query_cache_limit | 1048576 |
| Query_cache_min_res_unit | 4096 |
| Query_cache_size | 0 |
| Query_cache_strip_comments | OFF |
| Query_cache_type | OFF |
| Query_cache_wlock_invalidate | OFF |
+ ------------------------------ + --------- +
7 rows in set (0.00 sec)

Data Preparation

[Root @ localhost ~] # Sysbench -- test = oltp -- oltp-table-size = 1000000 -- mysql-host = 127.0.0.1 -- mysql-db = frank
-- Mysql-user = root -- mysql-password = root prepare

5.5.33 test results

Number of threads transactions per second (TPS)
1 666.94

8 2732.59

16 2708.15

32 2617.72

64 2605.82

128 2506.13

 

5.6.14 test results

Number of threads transactions per second (TPS)
1 690.29

8 2534.15

16 2544.34

32 2500.91

64 2479.60

128 2394.28

Conclusion: The throughput of 5.6.14 is not improved. on a multi-threaded server, when the number of threads reaches two to three times of the cpu, the maximum throughput is swallowed. As a result, the number of threads continues to increase and the throughput decreases. as the number of threads increases, cpug context switching is very powerful, affecting performance.

Install and build the LAMP environment Apache + MySQL + PHP under Fedora 20

MySQL authoritative guide (original book version 2nd) Clear Chinese scan PDF

Compile and install the MySQL 5.6 script in the source code package

This article permanently updates the link address: