… and improvements. List of changes: Fixes merged from upstream (Codership-mysql) Support for MyISAM, now changes to MyISAM tables are replicated… and RPM binaries for RedHat (CentOS, Oracle Linux) 5 and 6, and Debian packages. Downloads: http://www.percona.com/downloads/Percona…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for… was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned, I… rate can be classified as large, because it varies between ~6.5k to ~12.5k INSERTs per second, with noticeable spikes…
Post: Testing Fusion-io ioDrive
May 3, 2012 By 1 Comment
… PCIe cards. It really makes sense to test it under MySQL workload, but before getting to that, let me review the… than for Intel 520. For 8 threads it is 0.6 ms ( for Intel 520 – 0.69 ms). To better understand…
Post: Announcing Percona XtraBackup 1.6.6
April 4, 2012 By 3 Comments
… announce the latest minor release in the Percona XtraBackup 1.6 series. We recognise that not everybody will want or be….0 and so we’re also releasing Percona XtraBackup 1.6.6. This is a minor release and source code and binaries… XtraBackup 2.0.0, so you won’t see 1.6.6 there. We’re also keeping the documentation for the 1…
Post: Percona Live MySQL Conference & Expo Was A Great Event
April 17, 2012 By 2 Comments
… in years.” Darren Cassar called it “one of the best MySQL conferences since I started attending four years ago,” while Marco… Oracle for their new development milestone release for MySQL 5.6, released on Monday. MySQL 5.6 just keeps looking better and better. The… also recorded some of the breakout sessions, so watch Planet MySQL for an announcement when she posts those online. Presentation slides…
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 6 Comments
… further I found the following explanation from Timour Katchaounov in MySQL mailing list archives I have some recollection that there were… makes Timour explanation somewhat conflicting though as if we assume MySQL users do not join lots of tables (less than 7… computation would be more important than backward compatibility. In MySQL 5.6 things are likely to get even better handling joins of…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… about the MRR optimization available in MySQL 5.6 here: http://dev.mysql.com/doc/refman/5.6/en/mrr-optimization.html and as… 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… not in MySQL 5.6, is that because of a bug in MySQL 5.6 code? As MRR was used in both MySQL 5.6 and…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
… is available in both MySQL 5.6 and MariaDB 5.5. You can read more about BKA in MySQL 5.6 here and BKA… the graph above the labels mean as follows: MySQL 5.6 (2) is for MySQL 5.6 w/ buffer size 6M MariaDB 5.5… a look at the status counters. Counter Name MySQL 5.5 MySQL 5.6 MySQL 5.6 w/ join_buffer_size=6M & read_rnd_buffer…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
… in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look… enhancement Index Condition Pushdown (ICP). Its available in both MySQL 5.6 and MariaDB 5.5 Now let’s take a look…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
… a lot of benchmarking of specific MariaDB 5.3 and MySQL 5.6 optimizer improvements, and both of them look very good… also available either in Percona Server or in the upcoming MySQL 5.6 in the same or slightly different forms, so there…, Percona Server has the same group commit fix, and MySQL 5.6 offers microsecond timestamp support, as well as a lot of…
