…. 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 is … 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
… 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… 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…_Log_File: mysql_sandbox18676-relay-bin.000001 Relay_Log_Pos: 4 [...] As stated in the documentation, the connection parameters are still…
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… of MySQL used was Percona Server 5.5.30-rel30.1-465. Each test was allowed to run for…bounds. This is, however, only a hypothesis. vCache vs. FlashCache – dirty page threshold Finally, we examine the…
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…-interleave malloc-lib=/usr/local/Percona-Server-5.5.30-rel30.2-500.Linux….file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…Centos 6.4 Single core VM 528M RAM Host-Only network 1 Box with http/php, 1 box… this benchmark: // Identical config/code for memcached vs InnoDB $frontendOpts = array( ‘caching’ => true, ‘lifetime’ => 3600, ‘automatic_… ms max per/cmd 5.875 ms range per/cmd Fetching [1,000,000] items: 347181 …
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… execution time, the number of tmp tables created in memory vs on-disk, percentage of queries that needed full scan, InnoDB… 0.1381 1.7% 909 0.0002 1.00 0.00 SELECT wp_options # 8 0x4C16888631FD8EDB 0.1160 1.4% 5 0.0232 1.00 0.00 SELECT film # 9 0xCFC0642B5BBD9AC7 0.0987 1.2% 50 0.0020 1.00 0…
Post: MySQL 5.6 vs MySQL 5.5 and the Star Schema Benchmark
March 11, 2013 By 7 Comments
…caption id=”attachment_13599″ align=”alignright” width=”210″] MySQL 5.6 vs MySQL 5.5 & the Star Schema Benchmark[/caption] So far most of…). 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…
Post: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… 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… 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… observed. Vadim has already Wrote about it in his MySQL 5.1 vs 6.0 in TPC-H Queries post As a Summary…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
…these benchmark runs and that the disks are 4 5.4K disks in Software RAID5. Also note …6718351 6611675 6707882 5479445 5527245 Select_scan 1 1 1 1 1 1 Sort_scan 1 1 1 1 1 1 The first obvious improvement is shown by…from disk 2.2G vs 5G. However, there is one number in MariaDB 5.5 that is quite large…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… of performance with 5.0.X. I’m hopeful that 5.1.X will be better, but still not sure. HT: 5.0.xx, where xx >= 30 should be better than 4.1.xx. PZ: I should note MySQL 5.0 vs 4.1 has a…
