…5.5 MariaDB 5.5 w/ mrr_buffer_size=4M Created_tmp_disk_tables 1 1 1 1 1 Created_tmp_tables 1 1 1 1 1 Handler_mrr_init N/A 0 0 1 1…,i_l_orderkey_quantity PRIMARY 4 dbt3.orders.o_orderkey 1 100.00 Using where b. … the queries are just a bit slower as compared to MySQL 5.5 MRR clearly changes the access …
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 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…5.5 is close, yet slower…0 0 0 0 0 0 Created_tmp_tables 1 1 1 1 1 1 Handler_mrr_init N/A 112 3 1133 1 1…
Post: Watch out for Marketing benchmarks
August 23, 2006 By 7 Comments
… it to my MySQL Performance 5.0 vs 4.1 presentation to have some fun. What can we see ? Out of all MySQL 4.1 vs 5.0 benchmarks which… benchmarks which show MySQL 5.0 is faster were selected and bunch of other benchmarks which show 5.0 is actually slower than 4.1 were hidden under… was similar with MySQL 4.1 – number of great performance fixes but good number of cases when it become few percent slower (especially due…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… if you skip over one. MySQL 5.0 to 5.1 upgrade is a lot safer upgrade path than 4.1 to 5.1 just because so much more… in MySQL 4.1 or changing JOIN evaluation in 5.0 (which could both cause different result set or make query not runnable in MySQL 5.0) In… ? In this case you may need to take it much slower checking your progress along the way. There is no limit…
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… MySQL 6.0 time divided 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.0… however close and MySQL 6.0 is even significantly slower than 5.1 for number of queries. Honestly I expected more from MySQL 6.0 optimizer improvements…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 54 Comments
… half full. (That actually matters — the fuller they get, the slower they are.) So let’s call this a $2500 disk…% 0 11.1 sdj1 0.5 0.1 4.5 0.1 0.0 4.6 4% 0 12.1 sdj1 0.5 0.1 4.4 0.0 0.0 1.8 3% 0 13.1 sdj1 0.7 5.1 235.2 0.0 0.0 1.7 28% 0 14.1 sdj1 0.5 0.1 5.8 0.0 0.0 1.0 4% 2 15.1 sdj1 0.0 0.0 0.0 1…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… testing. MySQL 5.1 is 4% slower than MySQL 5.0 with two cores and just 2% slower with 8 cores, thus showing a bit better scalability. MySQL 5.1 plugin (compiled… error. This tells us there are some workloads when MySQL 5.1 is slower than 5.0, and same applies to the new Innodb code. Well…
Post: MySQL versions shootout
October 10, 2011 By 6 Comments
… workload. Versions in question: MySQL 4.1 MySQL 5.0 MySQL 5.1 (with built-in InnoDB) MySQL 5.1 with InnoDB-plugin MySQL 5.5 MySQL 5.6 All versions are vanilla MySQL, not Percona Server. The… thread results: You can see that each new version is slower in single thread than previous. It is actually easily explainable… raw results, in tps (more is better) threads MySQL 4.1 MySQL 5.0 MySQL 5.1 MySQL 5.1+InnoDB-plugin MySQL 5.5 MySQL 5.6.2 1 685.52 639.73 596.01 593.51…
Comment: MySQL and PostgreSQL SpecJAppServer benchmark results
July 26, 2007 By 13 Comments
…… but not get away from it fully. With MySQL MySQL version 4.1 and 5.0 became slower than MySQL 4.0 for many simple operations at large extent because… the start. Also if you compare MySQL and PostgreSQL MySQL is just flexible in different way – MySQL has large number of storage engines…
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 lot… I want to write about is queries that execute slower in new MySQL 6.0 version. Query is pretty simple SELECT sum(l… to find is Baron’s bug with no mention in MySQL 6.0 manual. No mentions about Using MRR also, but I…
