The MySQL Development team is happy to announce our 5.7.3 development milestone release, now available for download at dev.mysql.com.  You can find the full list of changes and bug fixes in the 5.7.3 Release Notes.  Here are the highlights. Enjoy!

Over 1 million QPS with InnoDB Memcached Plugin

After reaching 500 thousand QPS in Read-Only on SQL queries in 5.7.2 we now follow up with over 1 million QPS with InnoDB Memcached Plugin. Read more on this at Dimitri’s blog.  Thanks to Yoshinori (Facebook) for  inspiration!

Over 50 thousand connects/disconnects per second

Fast processing of new connections is important for …

Percona is glad to announce the release of Percona XtraDB Cluster 5.5.34-25.9 on December 4, 2013. Binaries are available from the downloads area or from our software repositories.

Based on Percona Server 5.5.34-32.0 including all the bug fixes in it, Galera Replicator and on Codership wsrep API 5.5.34-25.9, Percona XtraDB Cluster …

INFORMATION_SCHEMA is usually the place to go when you want to get facts about a system (how many tables do we have? what are the 10 largest tables? What is data size and index size for table t?, etc). However it is also quite common that such queries are very slow and create lots of I/O load. Here is a tip to avoid theses hassles: set innodb_stats_on_metadata to OFF.

This is a topic we already talked about, but given the number of systems suffering from INFORMATION_SCHEMA slowness, I think it is good to bring innodb_stats_on_metadata back on the table.

The problem

Let’s look at a system I’ve seen recently: MySQL 5.5, working set fitting in memory but not the whole dataset, around 4000 InnoDB tables.

The I/O load is very light as …

Congratulations to the MySQL All team

The MySQL community came together last month for two days of outstanding technical tutorials and sessions at Percona Live London. And now many of those MySQL presentations are available for free download.

This year’s London conference saw a 20 percent spike in attendance compared with last year, with MySQL professionals from 31 countries gathering in the U.K. capital for compelling keynotes (including Oracle’s Tomas Ulin and Percona’s Peter Zaitsev) along with in-depth tutorials and insightful breakout sessions.

And as a “thank you” for your continuing support of the Percona Live series of conferences, we’re also offering an additional $25 off registration for April’s Percona Live MySQL Conference and Expo 2014 (April 1-4 at the Hyatt Regency Santa …

Oracle’s MySQL Tech Tour – Portland
December 11, 2013, Portland

Please join us in Portland for our tech event hosted by Oracle’s MySQL experts and learn more about Oracle’s strategy and continued investment for MySQL.

More details and registration »

Oracle’s MySQL Tech Tour – Seattle
December 12, 2013, Seattle

Please join us in Seattle for our tech event hosted by Oracle’s MySQL experts and learn more about Oracle’s strategy and continued investment for MySQL.

More details and registration »

"It is better to keep silence and be thought a fool, than to say 'tuple' and remove all doubt."

But recently people have been using the word "tuple" more frequently. Doubtless all those people know that in relational databases a tuple (or a tuple value) is a formal term for a row of a table. It's possible to know a bit more than that.

Pronounced Tyoople, Toople, or Tuhple?

The Oxford Dictionaries site says Tyoople. Other dictionaries are neutral about the terms from which Tuple was derived (sextuple, octuple, etc.), for example Merriam-Webster says they usually end in Toople but Tuhple is an accepted alternate, and the Oxford Canadian Dictionary says …

Heads up that Friday (6th December) is your last chance to submit a 30 minute session proposal for next year’s MySQL & Friends Devroom at FOSDEM. I presented last year and I was really impressed by the number of attendees, the organisation and the positive reception (I’ll be there again next year – hopefully presenting). If you’ve got a MySQL-related topic that you’d like to present to an enthusiastic open-source community then this is a agreat opportunity.

Submit your proposal(s) for a 30 minute session here.

FOSDEM 2014 is free event running in Brussels over the weekend of 1st & 2nd February, with the MySQL content aimed for the Saturday. This is a huge event (5,000+) and has a great, …

I get a lot of questions about Percona XtraDB Cluster 5.6 (PXC 5.6), specifically about whether such and such MySQL 5.6 Community Edition feature is in PXC 5.6.  The short answer is: yes, all features in community MySQL 5.6 are in Percona Server 5.6 and, in turn, are in PXC 5.6.  Whether or not the new feature is useful in 5.6 really depends on how useful it is in general with Galera.

I thought it would be useful to highlight a few features and try to show them working:

Innodb Fulltext Indexes

Yes, FTS works in Innodb in 5.6, so why wouldn’t it work in PXC 5.6?  To test this I used the Sakila database , which contains a single table with FULLTEXT.  In the sakila-schema.sql file, it is still designated a MyISAM table:

In recent time, MariaDB 10 has been getting many new storage engines. We’ve seen TokuDB, CONNECT, SEQUENCE, SPIDER, CassandraSE for various use cases. For a long time, MariaDB shipped OQGRAPH, but it was disabled in MariaDB 5.5. It will make a come back as OQGRAPH v3 has been worked on actively by Andrew McDonnell. Keep track of this via MDEV-5319.

Another engine being worked on by Kentoku Shiba & team is the mroonga engine, which allows you to do full text search. It is optimised for CJK languages, and is supposedly very fast. To track this, follow …