…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…vs 5G. However, there is one number in MariaDB 5.5 that is quite large as compared to MySQL 5…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking… Index 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
… more point to consider. Starting the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB uses “asynchronous” IO in… xfs 4 threads: 97 MiB/sec It corresponds to results I see running MySQL benchmarks (to be published later) on ext4 vs xfs…. This is to another question I was asked, namely: “If MySQL 5.5 uses async IO, is innodb_write_io_threads still important…
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… to write about is queries that execute slower in new MySQL 6.0 version. Query is pretty simple SELECT sum(l… MRR works. What else worth to mention here is that MySQL is wrong choosing index scan here. If we try to…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… schema and queries are described here Used hardware CentOS release 4.4 (Final) 2 Ñ… Dual Core Intel XEON 5130 model name… of RAM MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql-5.1-falcon… ./configure –prefix=/usr/local/mysqltest/mysql- –with-innodb For Falcon ./configure –prefix=/usr/local/mysqltest/mysql- –with-falcon mysqld startup params: Falcon…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…atomically, not just for new connections as in MySQL. This is very helpful for measurement as otherwise… the number of tmp tables created in memory vs on-disk, percentage of queries that needed full…SELECT wp_options # 8 0x4C16888631FD8EDB 0.1160 1.4% 5 0.0232 1.00 0.00 SELECT film # 9 …
Post: MySQL versions shootout
October 10, 2011 By 6 Comments
… overhead. Profiling 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… 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…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld) S 1 19018 19018 0 -1…sent 8.77G 11 55.41M 5.15k 3.88k 258.55k 1.46k # Merge passes …21 1.57M 0 1 0.94 0.99 0.24 0.99 # Rows examine 4 1.57M 0 1… of hardware provides better balance of CPU vs IO utilization as well as as …
Post: UNION vs UNION ALL Performance
October 5, 2007 By 13 Comments
…of UNION vs MySQL 5.0 index merge algorithm Sinisa …MySQL 5.0): select * from test.abc where i=5 or j=5 Such query takes 4…mysql> explain (select * from test.abc where i=5) union all (select * from test.abc where j=5 and i!=5) \G *************************** 1. row *************************** id: 1…
Comment: Quick comparison of MyISAM, Infobright, and MonetDB
October 1, 2009 By 30 Comments
Why you don’t put the version used of each software? that’s is very important!! there are differences between infobright 3.1.1 and 3.2 (ICE vs IEE), MySQL 4.1 vs 5.0 vs 5.1, for example.
