… In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings … that InnoDB performs better when a larger number of rows must be joined together (Q4.1, Q4.2… to prevent assorted security risks symbolic-links=0 innodb_stats_persistent innodb_stats_auto_update=off…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…single-node (on the left) vs. two-node (on the right) … cases Percona Server performance is even slightly ahead of MySQL 5.6.10, …0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp-simple-ranges=0…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… benchmark 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…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… I wanted to compare InnoDB performance vs TokuDB. I have a … non-decreasing ID $K=rand(0,10000) // distributed by pareto distribution…5.5.30-rel30.2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql…innodb_flush_log_at_trx_commit = 1 innodb_buffer_pool_size = 36G …
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 is a…’ + interval ‘1‘ year AND l_discount BETWEEN 0.09 – 0.01 AND 0.09 + 0.01 AND l_quantity < 24; with execution plain (in 5.1) +—-+————-+———-+——-+—————+—————+———+——+———+————-+ | id… 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 – time 1…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…MySQL 5.6 vs MySQL 5.5 & the Star Schema Benchmark[/caption] So far most of the benchmarks posted about MySQL 5…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…
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 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 changes…
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
…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…MySQL 6.0 performance will improve. Though considering a lot of talks about optimizer improvements in MySQL 6.0…
