…on the Star Schema Benchmark. In my previous blog post I compared MySQL 5.5.30 to MySQL 5.6.10, both…than InnoDB both cold and hot. SSB Flight #4 There is one query in this flight, Q4….recommended to prevent assorted security risks symbolic-links=0 innodb_stats_persistent innodb_stats_auto_update=off …
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…benchmark, I ran some batches of fetch and store against both a standard memcached instance and a minimally tuned MySQL 5…4 Single core VM 528M RAM Host-Only network 1 Box with http/php, 1 box with memcache or mysql…, $memcacheOpts); $timer->start(); for ($i = 0; $i < 100000; $i++) { $cache->save(new …
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
… variable. Accepted values are in the range [0, 255] (inclusive). Quorum is computed using weighted …download from our repositories. Benchmark showing the impact of memory allocators on MySQL performance can be found …on Codership wsrep API 5.5.30-23.7.4, Percona XtraDB Cluster 5.5.30-23.7.4 is now …
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… ). Also please note the transaction produces 4 INSERTs and workload is very …that is why I also show 5-minute moving averages to TokuDB…. if you want to repeat this benchmark, the sysbench code is on …mysql_table_engine=tokudb –oltp_auto_inc=on –max-time=18000 –report-interval=10 –max-requests=0…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… cache storage device. EXT4 is the filesystem, and CentOS 6.4 the operating system, although the pre-release modules I received… of the benchmarks on both systems. The benchmark tool used was sysbench 0.5 and the version of MySQL used was Percona Server 5.5.30-rel30… think vCache can be declared the clear winner. Base MySQL & Benchmark Configuration All benchmarks were conducted with the following: sysbench –num-threads=32…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 55 Comments
… it out. I could do benchmarks, but that would not be interesting — we already know that benchmarks are unrealistic, and we know….4 90.8 0.0 0.0 4.0 25% 0 3.0 sdj1 0.6 0.2 12.3 0.3 0.1 4.8 9% 0 4.0 sdj1 0.2 0.1 8.7 0.0 0.0 1.4 2% 0 5.0 sdj1 0.7 4…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… benchmark runs and that the disks are 4 5.4K disks in Software RAID5. Also note that the following changes were made on MySQL 5… the lowest query time is for MySQL 5.6 which takes 0.16s less as compared to MySQL 5.5 While with join_buffer_size set… for 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…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
… I played 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… to write about is queries that execute slower in new MySQL 6.0 version. Query is pretty simple SELECT sum(l_extendedprice… to find is Baron’s bug with no mention in MySQL 6.0 manual. No mentions about Using MRR also, but I…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… (or benchmarked) system performance to provide our estimates. If we’re running Innodb with MySQL we …5.15k 3.88k 258.55k 1.46k # Merge passes 0 0 0 0 0 0 0 # Tmp tables 21.36k 0 2 0.01 0 0.11 0…0 1 0.94 0.99 0.24 0.99 # Rows examine 4 1.57M 0 1 0.94 0.99 0.24 0.99 # Rows affecte 0 0 0 0 0 0 0 0…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…MySQL 5.6, increase of 0.02s. But the query times for MariaDB 5.5 are greater than both MySQL 5.5 and MySQL 5…benchmark on IO bound workload, mentioned above. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ read_rnd_bufer_size=4M MariaDB 5.5 MariaDB 5.5…
