… continuing series on the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default… presents some unique challenge to the database optimizer. The SSB benchmark consists of four sets of queries. Each set is known…-links is recommended to prevent assorted security risks symbolic-links=0 innodb_stats_persistent innodb_stats_auto_update=off [mysqld_safe…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…benchmark, I ran some batches of fetch and store against both a standard memcached instance and a minimally tuned MySQL 5…this benchmark: // Identical config/code for memcached vs InnoDB $frontendOpts = array( ‘caching… $memcacheOpts); $timer->start(); for ($i = 0; $i < 100000; $i++) { $cache->save(…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… of the benchmarks on both systems. The benchmark tool used was sysbench 0.5 and the version of MySQL used was Percona Server 5.5.30-rel30… the way, let’s look at some numbers. vCache vs. vCache – MySQL parameter testing The first test was designed to look solely… think vCache can be declared the clear winner. Base MySQL & Benchmark Configuration All benchmarks were conducted with the following: sysbench –num-threads=32…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…I wanted to compare InnoDB performance vs TokuDB. I have a particular… non-decreasing ID $K=rand(0,10000) // distributed by pareto distribution … if you want to repeat this benchmark, the sysbench code is on…5.5.30-rel30.2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…5.5.30-30.2 and a followup by Dimitri Kravchuk, we have received a large number of questions on why the benchmark…is somewhere in between of MySQL 5.5 and MySQL 5.6. In order to…single-node (on the left) vs. two-node (on the right) … sbtest$i WHERE k like ‘%0%’ SysBench-0.5/lua: POINT_SELECT QPS test…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… played with queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here, as there is… to write about is queries that execute slower in new MySQL 6.0 version. Query is pretty simple SELECT sum(l_extendedprice… to find is Baron’s bug with no mention in MySQL 6.0 manual. No mentions about Using MRR also, but I…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… align=”alignright” width=”210″] MySQL 5.6 vs MySQL 5.5 & the Star Schema Benchmark[/caption] So far most of the benchmarks posted about MySQL 5.6 use the …MySQL 5.5 and MySQL 5.6, no tuning at all Config 2: MySQL 5.6 with all default settings except innodb_old_blocks_time=0 Config 3: MySQL 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…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 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: MySQL 5.6.7-RC in tpcc-mysql benchmark
October 8, 2012 By 22 Comments
…so I do my part. Benchmark date: Oct-2012 Benchmark goal: Test how MySQL 5.6.7 performs Hardware specification Server: Dell PowerEdge R710 CPU: 2x Intel(R) Xeon(R) CPU E5-2660 0… results. So there it is with 2x4GB vs 2x8GB innodb logfiles. Obviously the result is…
