… let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests…_file_per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You can see …configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I …
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
… of raw IO performance of this card. The benchmark methodology I described in previous posts, so let…MySQL 5.5 uses async IO for writes. Maybe 8 threads in the first graph is too much and we should go with 1…d,s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement(s…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… the benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read_rnd_bufer_size=4M MariaDB 5.5 MariaDB 5.5 w/ mrr_buffer_size=4M Created_tmp_disk_tables 1 1 1 1 1 Created_tmp_tables 1 1 1 1 1 Handler_mrr_init N/A 0 0 1 1 Handler…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…benchmarks, to see the difference in numbers. Benchmark results For the purpose of this benchmark…MySQL 5.6 becomes approximately equal to that of MySQL 5.5. MariaDB 5.5 is quite slow as compared to both MySQL 5.5 and MySQL 5.6. For MariaDB 5.5…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one… Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take a look briefly at what… WHERE condition defined as: l_partkey = x and l_quantity >= 1 and l_quantity = 1 and l_quantity
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
… most benchmarks are focusing on throughput. We all get used to that, and in fact in our benchmarks, sysbench and tpcc-mysql, the… existing benchmarks? Well, all benchmarks are lie, and focusing on throughput does not get any closer to reality. Benchmarks, like sysbench or tpcc-mysql…, 0.09, 1.26, … Or if we represent graphically (point means even arrival): As you see interval is far from being strict 0.5…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
…consider. Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB uses “… It corresponds to results I see running MySQL benchmarks (to be published later) on ext4 vs …,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d….
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 54 Comments
…do benchmarks, but that would not be interesting — we already know that benchmarks …0.0 0.0 0.0 0.0 0.0 2.5 0% 0 23.2 sdi2 0.0 0.0 0.0 0.0 0.0 2.0 0% 0 23.2 sdj5 0.0 0.0 0.0 0.0 0.0 1.0 0% 0 23.2 sdi4 0.0 0.0 0.0 0.1 0.0 2.2 1% 0 23.2 sdi3 0.0 0.0 0.0 0.1 0.0 2.5 1% 0 23.2 sdj3 0.0 0.0 0.0 0.1 0.0…
Post: MySQL QA Team Benchmarks for MySQL 5.1.30
December 13, 2008 By 12 Comments
As you might have seen MySQL QA Team has published their benchmarks for MySQL 5.0.72 and 5.1.30. It is interesting to compare with… benchmarks and see what value is best for MySQL 5.1 and for MySQL 5.0 respectively ? Both versions do their best with innodb_thread_concurrency=0 and 5.0…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… MySQL 6.0 time divided by MySQL 5.1 time so if it is less than 1 MySQL 6.0 is faster if more than 1 slower: Query MySQL 5.0.23 MySQL 6.0… presented in TPC-H benchmark are still subpar even with changes which are currently seen in MySQL 6.0 tree. There is a…
