… 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… InnoDB. SSB Flight #2 Flight #2 is similar to Flight #1. MyISAM is faster than InnoDB when the database is cold… always performs better, at least for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove performance_schema For…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… short For MySQL 5.0 and 5.1, run STOP SLAVE, CHANGE MASTER TO MASTER_HOST=” and then RESET SLAVE. For MySQL 5.5 and 5.6, run… supported from MySQL 5.5). If you want to know more details, please read on! MySQL 5.0/5.1 First let’s consider MySQL 5.0 and 5.1. RESET… never set master-xxx variables in my.cnf! From MySQL 5.5 Starting with MySQL 5.5, the situation has slightly changed. First the master-xxx…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… MySQL 5.6 with the memcached plugin… As part of the standard MySQL 5…. // Identical config/code for memcached vs InnoDB $frontendOpts = array( ‘caching’ => true, ‘lifetime’ => 3600,…’ => ’192.168.57.51′, ‘port’ => 11211, ‘weight’ => 1, ) ), ‘client’ => array( ‘compression’ => true, ), ); $cache = …
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… the way, let’s look at some numbers. vCache vs. vCache – MySQL parameter testing The first test was designed to look solely…-interval=1 –rand-type=pareto \ –forced-shutdown=1 –max-time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… and focused only on case #1. Which is the perfect case for read-only transaction optimization in MySQL 5.6, because all SELECT…’s tests Percona Server scalability is somewhere in between of MySQL 5.5 and MySQL 5.6. In order to understand more about differences between… a results comparison on a single-node (on the left) vs. two-node (on the right) configuration. No surprises here, the…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…, 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
…=”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… tested three configurations: Config 1: Default config for MySQL 5.5 and MySQL 5.6, no tuning at all Config 2: MySQL 5.6 with all default settings… – 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… Select_scan 1 1 1 1 1 1 Sort_scan 1 1 1 1 1 1 The first …vs 5G. However, there is one number in MariaDB 5.5 that is quite large as compared to MySQL 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… 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 hour 14 min 36.90 sec 6.0 – time 1 hour…
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 … loaded the values from MySQL 5.5.30 and MySQL 5.6.10 to the different tables and ran the query: mysql [localhost] {msandbox} (test) > select…_cost_based=on,use_index_extensions=on 1 row in set (0.00 sec) Summary: MySQL 5.6 comes with quite a few…
