… lowest query time is for MySQL 5.6 which takes 0.16s less as compared to MySQL 5.5 While with join_buffer_size… MariaDB 5.5 Hash Join Disabled w/ join_buffer_size=4M & mrr_buffer_size=4M Created_tmp_disk_tables 0 0 0 0 0 0 Created_tmp_tables 1 1 1 1 1 1… is read from disk 2.2G vs 5G. However, there is one number in MariaDB 5.5 that is quite large as compared…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking… Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take a look briefly at what… WHERE condition defined as: l_partkey = x and l_quantity >= 1 and l_quantity = 1 and l_quantity
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
…Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB uses “… benchmarks (to be published later) on ext4 vs xfs. Actually amount of threads does not…s,id){var js,fjs=d.getElementsByTagName(s)[0];if(!d.getElementById(id)){js=d.createElement…
Post: MySQL 6.0 vs 5.1 in TPC-H queries
March 25, 2008 By 17 Comments
…’ + 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… 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…
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… 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… observed. Vadim has already Wrote about it in his MySQL 5.1 vs 6.0 in TPC-H Queries post As a Summary: We…
Post: ANALYZE: MyISAM vs Innodb
September 3, 2008 By 9 Comments
… for MyISAM vs Innodb. I used… | Index_type | Comment | +—————+————+———-+————–+————-+———–+————-+———-+——–+——+————+———+ | antest_innodb | 1 | i | 1 | i | A | 245900 | NULL | NULL …This is from MySQL 5.0.62 if there are…
Comment: Upgrading MySQL
January 7, 2010 By 23 Comments
Speaking of upgrading 5.0 vs 5.1, which Percona build do you recommend be used in production, 5.1.34-5 or 5.0.87-b20? The web application…
Post: MySQL versions shootout
October 10, 2011 By 6 Comments
… 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… MySQL 5.0 vs MySQL 4.1 couple years ago, I have seen biggest performance hit comes from query parser. In MySQL 5.0 grammar became… 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…
Comment: InnoDB benchmarks
January 3, 2007 By 15 Comments
Pete, I don’t think the reason of degradation is debug code. If you look at our peresentation 5.0 vs 4.1 http://www.mysqlperformanceblog.com/files/presentations/UC2006-MySQL-5.0-vs-4.1.pdf you will see 5.0 release has degradation comparing to 4.1.
Page: Presentations
May 3, 2006 By
… Performance 5.0 vs 4.1 MySQL Users Conference 2006, Santa Clara, CA This presentation shows in numbers performance differences in MySQL 4.1 and 5.0… application design practices. Download MySQL: New Features in versions 4.1, 5.0, 5.1 Open Source Forum 2005, Moscow, Russia Presentation speaks about new…
