… MySQL 5.6 which takes 0.16s less as compared to MySQL 5.5…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.6…
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 optimizer… enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take a look briefly at what…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
… is not available on my CentOS 6.2, so I could not test… the MySQL 5.1 + InnoDB-plugin and later MySQL 5.5 (or equally Percona Server 5.1 and 5.5), InnoDB…I see running MySQL benchmarks (to be published later) on ext4 vs xfs. …file-extra-flags=direct –file-fsync-freq=0 –file-io-mode=sync –file-block…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
…0 552967 4096 26345 18446744073709551615 0 0 17 0 0 0 0 0 0 The #14 and #15 here is kernel and user CPU usage of MySQL…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…6.84 9.83 2.20 7.70 # queue wait 0 0 0 0 0 0 0 0 # rec lock wai 0 0 0 0 0 0 0 0… CPU vs IO…
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… to write about is queries that execute slower in new MySQL 6.0 version. Query is pretty simple SELECT sum(l_extendedprice * l… to find is Baron’s bug with no mention in MySQL 6.0 manual. No mentions about Using MRR also, but I guess…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… new connections as in MySQL. This is very …0 816.04 0 # IO r ops 6 0 2 0.00 0 0.05 0 # IO r wait 64ms 0 26ms 13us 0 530us 0 # pages distin 28.96k 0 48 6… tables created in memory vs on-disk, percentage of…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: TPC-H Run on MySQL 5.1 and 6.0
April 10, 2008 By 16 Comments
… here So let us first take a look at MySQL 5.1.23 vs 6.0.4 results for 10GB data set which “fits in… 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.4Ratio…
Post: UNION vs UNION ALL Performance
October 5, 2007 By 13 Comments
When I was comparing performance of UNION vs MySQL 5.0 index merge algorithm Sinisa pointed out I should be using … test.abc where j=5 and i!=5 The query time dropped to about 6 seconds which is 3.5 times faster – quite considerable… (which uses index merge method in MySQL 5.0): select * from test.abc where i=5 or j=5 Such query takes 4 seconds so…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
…0.00 sec) Session1: mysql> begin; Query OK, 0 rows affected (0.00 sec) Session2: mysql> begin; Query OK, 0 rows affected (0.00 sec) mysql…5: UPDATE / SELECT FOR UPDATE in OPTIMISTIC mode Solid optimistic: Session1: mysql> begin; Query OK, 0 rows affected (0.00 sec) Session2: mysql…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… a Percona Server 5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql socket=/var/…, the difference was still 15% — 909 iops unaligned -vs- 1049 aligned. Random write. This is an important… {540} dm-0 447.1 34.0 7.4 0% 2.4 5.4 23.4 49.6 0.6 0% 0.0 0.6 85% 0 Misaligned: #ts …
