…let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests… = 4 innodb_file_per_table = 1 ## Disabling query cache query_cache_size = 0 query_cache_type = 0 You … 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
… performance of this card. The benchmark methodology I described in previous posts…MySQL 5.5 uses async IO for writes. Maybe 8 threads in the first graph is too much and we should go with 1…var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=…’;fsb=’13′;bw=’100′;ff=’4‘;pc=’4889F0′;b=’…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…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… 4 dbt3.orders.o_orderkey 1 …
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
…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…=’13′;bw=’100′;ff=’4‘;pc=’4889F0…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… move on to the benchmarks, to see the difference in numbers. Benchmark results For the purpose of this benchmark, I have used TPC… benchmark runs and that the disks are 4 5.4K disks in Software RAID5. Also note that the following changes were made on MySQL 5…=4M Created_tmp_disk_tables 0 0 0 0 0 0 Created_tmp_tables 1 1 1 1 1 1 Handler_mrr_init N/A 112 3 1133 1 1 Handler_mrr_key_refills…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
…. Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB uses …4 threads: 120 MiB/sec xfs 4 threads: 97 MiB/sec It corresponds to results I see running MySQL benchmarks…id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d….
Post: Performance improvements in Percona 5.0.83 and XtraDB
July 14, 2009 By 27 Comments
…-memory benchmark, results during run: And averaged final result: As you see XtraDB, 5.0.83-percona and MySQL 5.4 are almost equal, leaving 5.0.83… topic for another benchmark. And now IO-bound results Again you can see that XtraDB, 5.0.83-percona and 5.4 are almost equal… can choose XtraDB if 5.4 has the same performance, let me refresh: – XtraDB is based on InnoDB plugin 1.0.3, with all…
Post: Watch out for Marketing benchmarks
August 23, 2006 By 7 Comments
… 5.0 vs 4.1 presentation to have some fun. What can we see ? Out of all MySQL 4.1 vs 5.0 benchmarks which were done only benchmarks which show MySQL 5.0 is faster were selected and bunch of other benchmarks which show 5.0 is…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…benchmarked) system performance to provide our estimates. If we’re running Innodb with MySQL…1.57M 0 1 0.94 0.99 0.24 0.99 # Rows examine 4 1.57M 0 1 0.94 0.99 0.24 0.99 # Rows affecte 0 0 0 0 0 0 0 0 # Rows read 32 1.70M 0 3 1.02 1…
