… Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using only the…. It seems that InnoDB performs better when a larger number of rows must be joined together (Q4.1, Q4.2) but worse… almost always performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For the…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… tool used was sysbench 0.5 and the version of MySQL used was Percona Server 5.5.30-rel30.1-465. Each test was allowed…. vCache vs. vCache – MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL configuration… vCache performance results were obtained with the default vCache configuration, I think vCache can be declared the clear winner. Base MySQL & Benchmark…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… on case #1. Which is the perfect case for read-only transaction optimization in MySQL 5.6, …comparison on a single-node (on the left) vs. two-node (on the right) configuration. No surprises… the first two cases Percona Server performance is even slightly ahead of MySQL 5.6.10, but nothing unexpected…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… TokuDB, of course I wanted to compare InnoDB performance vs TokuDB. I have a particular workload I’m…-Server-5.5.30-rel30.2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql …size = 256M innodb_flush_log_at_trx_commit = 1 innodb_buffer_pool_size = 36G innodb_log_file_size…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… the PERFORMANCE_SCHEMA, and paths are unique for basedir and datadir I tested three configurations: Config 1: Default config for MySQL 5.5 and MySQL 5.6… – Scale Factor 1 – Mysql 5.5 vs 5.6 response times are in seconds (lower is better) Version Buffer Cold Run1 Run2 Run3 5.5.30 128M 361…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
…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…performance. I did not find much of a performance improvement from using Hash Join in MariaDB 5.5…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… with queries from TPC-H benchmarks, particularly comparing MySQL 6.0.4-alpha with 5.1. MySQL 6.0 is interesting here, as there… perform 5.1 and 6.0 in cold mode (I dropped OS caches by `echo 1 > /proc/sys/vm/drop_caches` and restarting mysqld) 5.1… scan will be performed in this case) then we got: 1 min 39.14 sec to execute query (compare with 1 hour 14…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
As the part of analyzing surprising MySQL 5.5 vs MySQL 5.6 performance results I’ve been looking at changes to default variable …/nfs/dist/mysql-5.5.30-linux2.6-x86_ | /mnt/nfs/dist/mysql-5.6.10-linux-glibc2. | | PERFORMANCE_SCHEMA_MAX_COND_INSTANCES | 1000 | 836 | | PERFORMANCE_SCHEMA…_cost_based=on,use_index_extensions=on 1 row in set (0.00 sec) Summary: MySQL 5.6 comes with quite a few…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking… 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: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… downloaded here So let us first take a look at MySQL 5.1.23 vs 6.0.4 results for 10GB data set which… about it in his MySQL 5.1 vs 6.0 in TPC-H Queries post As a Summary: We can see MySQL capabilities to run… and may be MySQL 6.0 performance will improve. Though considering a lot of talks about optimizer improvements in MySQL 6.0 I…
