If you are terrified by the stability of the results in MySQL in my previous post, I am going to show what we can get with Percona Server. This is also to address the results presented there Benchmarking MariaDB-5.3.4
The initial benchmark is described in Benchmarks of Intel 320 SSD 600GB, and the result for MySQL 5.5.20 in case with 4 (46GB of data) and 16 tables (184GB of data) you can see in my experiments with R graphics.
How do we solve it in Percona Server ? There is whole set of improvement we made, like:
and the configuration to provide better experience on SSD is :
|
1 2 3 4 |
innodb_flush_neighbor_pages = 0 innodb_adaptive_flushing_method = keep_average innodb_log_block_size = 4096 innodb_log_file_size = 4G |
Versions: MySQL 5.5.20, Percona Server 5.5.19
With these settings we have following results:
As you see with Percona Server we have stable and predictable lines.
Now, how to compare these results ?
If we draw next boxplot:
and compare the average (middle line inside box) for whole 1h run, we may get impression that average throughput for Percona Server is worse, because averages for 16 tables are:
and now if you draw a column plot with these results, you will get something like:
One, looking on this graph, may come to the conclusion: wow, there is a regression in Percona Server.
But if we cut of first 1800 sec, to exclude warmup period, the average will be different:
And for comparison, average throughput for 4 tables:
The Percona Server is still slower, but you say me, would you rather prefer a stable throughput or sporadic jumps ? Furthermore, there is a way to improve throughput in Percona Server: increase innodb_log_file_size.
There are stability timeline for Percona Server with innodb_log_file_size=8GB
And to aggregate results and provide final numbers, jitter (after initial warmup 1800 sec)
So, in the conclusion, you can see that with a proper tuning, Percona Server/XtraDB outperforms MySQL, and provides a more stable throughput. Of course if a tuning is too hard to figure it out, you always can fall back to the vanilla InnoDB-plugin, like MariaDB suggests in Benchmarking MariaDB-5.3.4.
Raw results and scripts are on Benchmarks Launchpad
