…Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both with default settings using … SSB Flight #2 Flight #2 is similar to Flight #1. MyISAM is faster than InnoDB when the database …faster than InnoDB both cold and hot. SSB Flight #4 There is one query in this flight, Q4.3…
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…_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysql_sandbox18676-relay-bin.000001 Relay_Log_Pos: 4 [...] As stated in the documentation…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…. Enter MySQL 5.6 with the memcached plugin… As part of the standard MySQL 5.6 GA…4 Single core VM 528M RAM Host-Only network 1 Box with http/php, 1 box with memcache or mysql… benchmark: // Identical config/code for memcached vs InnoDB $frontendOpts = array( ‘caching’ => true, ‘lifetime’ => 3600, ‘…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…device. EXT4 is the filesystem, and CentOS 6.4 the operating system, although the pre-release modules… was sysbench 0.5 and the version of MySQL used was Percona Server 5.5.30-rel30.1-465. Each test… let’s look at some numbers. vCache vs. vCache – MySQL parameter testing The first test was designed to…
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 … ). Also please note the transaction produces 4 INSERTs and workload is very write…that is why I also show 5-minute moving averages to TokuDB. …10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock user=root …
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
… 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…). 12GB memory 4 disk 7200RPM RAID 10 array with 512MB write-back cache Star Schema Benchmark – 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…1 1 1 1 1 1 Sort_scan 1 1 1 1 1 1…vs 5G. However, there is one number in MariaDB 5.5 that is quite large as compared to MySQL 5…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… MySQL 5.1.23 vs 6.0.4 results for 10GB data set which “fits in memory”. The cut-off time for this test was 1… 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 6… 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…
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… 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…
Comment: Announcing Percona XtraDB Cluster 5.5.29-23.7.1
February 3, 2013 By 8 Comments
… x86_64 1:5.5.29-23.7.1.387.rhel5 /Percona-XtraDB-Cluster-shared-5.5.29-23.7.1.387.rhel5.x86_64 3.4 M… rpm_check_debug vs depsolve: mysql conflicts with Percona-XtraDB-Cluster-client-5.5.29-23.7.1.387.rhel5.x86_64 mysql-devel conflicts with…-Cluster-shared-5.5.29-23.7.1.387.rhel5.x86_64 mysql-server conflicts with Percona-XtraDB-Cluster-server-5.5.29-23.7.1.387…
