… In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using… Flight #2 Flight #2 is similar to Flight #1. MyISAM is faster than InnoDB when the …recommended to prevent assorted security risks symbolic-links=0 innodb_stats_persistent innodb_stats_auto_update=off …
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…? In 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… longer 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 SLAVE… 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
…invaluable. Enter MySQL 5.6 with the memcached plugin… As part of the standard MySQL 5.6 GA… benchmark: // Identical config/code for memcached vs InnoDB $frontendOpts = array( ‘caching’ => true, ‘lifetime’ => 3600, ‘automatic… Fetching [1,000,000] items: 288257 ms total 0.288257 ms per/cmd 0.2843 …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…only on case #1. Which is the perfect case for read-only transaction optimization in MySQL 5.6, because…comparison on a single-node (on the left) vs. two-node (on the right) configuration. No surprises …: [mysqld] user=root port=3306 innodb_status_file=0 innodb_data_file_path=ibdata1:100M:autoextend …
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… 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-engine…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… wanted to compare InnoDB performance vs TokuDB. I have a particular… 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…
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… 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… – 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…vs 5G. However, there is one number in MariaDB 5.5 that is quite large as compared to MySQL 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 … of 1MB while in MySQL 5.5 and before it was “ON” by default with query cache size of 0 which makes it disabled…_cost_based=on,use_index_extensions=on 1 row in set (0.00 sec) Summary: MySQL 5.6 comes with quite a few changes…
