…in MySQL development. At the same time, a thriving ecosystem of potential alternatives and complementary products has emerged to provide MySQL…MySQL 5.6 and how MySQL must evolve if it is to remain competitive in the new world order…
Post: Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
April 15, 2013 By 1 Comment
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…XtraDB Cluster (PXC) for MySQL. I actually had more material than I covered (by design), but one thing…transactions are copied to all nodes and global ordering is established, but apply and commit is …50% of the fc_limit before replication was resumed. A large fc_limit in this case might mean a…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…in our tests. In Dimitri’s tests Percona Server scalability is somewhere in between of MySQL 5.5 and MySQL 5.6. In order…in MySQL 5.6 virtually eliminates contention on the mutex protecting the list of transactions, its applicability is quite limited…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
…orders of magnitudes faster than a list scan. You may be curious if MySQL 5.6 brings any notable improvements in…in MySQL 5.6 to achieve even better scalability while removing the read-only limitations…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
…MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL…in the cluster. But why every node and not just a quorum? Well, it turns out transaction ordering really, really matters (really!). By…
Post: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 100 Comments
…of MySQL Performance problems. Here is what you need to know about ORDER BY … LIMIT optimization to avoid these problems ORDER BY with LIMIT is most common use of ORDER BY in interactive applications …
Post: Possible optimization for sort_merge and UNION ORDER BY LIMIT
September 18, 2007 By 10 Comments
… rows in sorted order. Once this is implemented similar approach could be used for optimizing ORDER BY with IN. This original query (in memory … mysql> explain (select * from utest where c1=5 order by ord desc limit 10) union (select * from utest where c2=5 order by ord desc limit 10) order by…
Post: MySQL Indexing Best Practices: Webinar Questions Followup
August 16, 2012 By 4 Comments
…to consider is string comparison in MySQL is case insensitive by default while hash …in recent MySQL versions. However it is often too many. Instead of thinking about hard limit…in index order. Note however it is not really requirement for ORDER BY DESC optimization – you can still traverse BTREE in…
Post: Implementing Parallel Replication in MySQL
November 8, 2010 By 3 Comments
… severe limitations in the MySQL server. We have a brief outline of the ideas at this wiki blueprint. So far, the “binlog order” idea… most negatively affected by the limitations, and whose problems can be improved the most with a (relatively) simple implementation. In particular, that means…
Post: Wow. My 6 year old MySQL Bug is finally fixed in MySQL 5.6
August 30, 2012 By 2 Comments
…being fixed in MySQL 5.6.6…. which I reported in Early 2006 (while still being with MySQL) and running MySQL 4…. ENGINE=MyISAM DEFAULT CHARSET=utf8 mysql> select i,count(*) cnt from trunc group by i order by cnt desc limit 10; +————+——-+ | i | cnt | +————+——-+ | 2147483647 |…
