…, but still the tool serves well for benchmark purposes. OK, let’s start off with … configuration. MySQL Configuration I used Percona Server 5.5.22-55 for the tests. Following is … innodb_buffer_pool_instances = 4 innodb_adaptive_flushing = 1 innodb_adaptive_flushing_method = estimate innodb_flush_…
Post: New distribution of random generator for sysbench - Zipf
May 9, 2012 By 3 Comments
… reflect my needs when I run benchmarks. Uniform is stupidly simple: for a table with 1 mln rows, each row gets equal… many times each row selected for different θ: 0.5, 0.9, 1.1: The curve is very skewed, so I zoomed graphs… it sounds interesting. I am going to run couple incoming benchmarks with this distribution. Follow @VadimTk !function(d,s,id){var…
Post: Testing Intel SSD 520
May 1, 2012 By 7 Comments
Following my previous benchmarks of SATA SSD cards I got Intel SSD 520 240GB … the results of raw IO performance of this card. The benchmark methodology I described in previous posts, so let me jump… 5.5 uses async IO for writes. Maybe 8 threads in the first graph is too much and we should go with 1…
Comment: TPC-H Run on MySQL 5.1 and 6.0
May 14, 2012 By 16 Comments
Hi Peter, Re utilising multi cores, MySQL does claim to be capable of utilising multiple CPU cores. (http://dev.mysql.com/doc/refman/5.5/en/faqs-general.html#qandaitem-B-1-1-8). Is that a different kind of assessment or different benchmarking? Cheers.
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… of MySQL 5.5 and ~5 hours in case of MySQL 5.6 and MariaDB 5.5. Note that query cache is disabled during these benchmark runs… 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…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one… 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: 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… that query cache is disabled during these benchmark runs and that the disks are 4 5.4K disks in Software RAID5. Also…_read 4127318 6718351 6611675 6707882 5479445 5527245 Select_scan 1 1 1 1 1 1 Sort_scan 1 1 1 1 1 1 The first obvious improvement is shown by the high…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
… to consider. Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB uses “asynchronous” IO in… MiB/sec It corresponds to results I see running MySQL benchmarks (to be published later) on ext4 vs xfs. Actually amount… 20% better throughput. I am still going to run more benchmark to get better picture. The script for tests: for size…
Post: Introducing new type of benchmark
February 25, 2012 By 16 Comments
… wrong with existing benchmarks? Well, all benchmarks are lie, and focusing on throughput does not get any closer to reality. Benchmarks, like sysbench…. How we should change the benchmark to base on this model ? There are my working ideas: Benchmark starts N working threads, but…, 1.26, … Or if we represent graphically (point means even arrival): As you see interval is far from being strict 0.5…
Post: Some fun with R visualization
February 23, 2012 By 5 Comments
… you can build with R + ggplot2. The conditions of the benchmark are the same as in the previous post, with difference… 16 tables cases running MySQL 5.5.20. Let me remind how I do measurements. I run benchmark for 1 hours, with measurements every…
