Continuing with my wishlist, I’ll add windowing functions. They’re enormously powerful. They allow you to extend relational logic beyond the strict boundaries of tuples. In MySQL at present, one must use ugly hacks to preserve state from one row to the next, such as user variables — which are not guaranteed to work if the optimizer changes the query plan.
class="alignright size-medium wp-image-17881" alt="How InnoDB promotes UNIQUE constraints" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/09/chain-300x225.jpg" width="300" height="225" />The other day I was running
The pace of MySQL engineering has been pretty brisk for the last few years. I think that most of the credit is due to Oracle, but one should not ignore Percona, Monty Program, Facebook, Google, Twitter, and others. Not only are these organizations (and the individuals I haven’t mentioned) innovating a lot, they’re providing pressure on Oracle to keep up the improvements, too.
A very special MySQL DBA Class will be held October 14th at Oracle Headquarters. The MySQL DBA Training On Demand Class (5.5 version) is currently the 8th best delivering TOD at Oracle in terms of student numbers and the MySQL DBA 5.6 course has been consistently been in the top 40 out of 1000s of titles at Oracle since the beginning of this financial year.
class="alignleft wp-image-17871" alt="September 2013 MySQL events" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/09/september2013-262x300.jpg" width="79" height="91" />Now with summer winding down and school back in session, we get into a very busy time with many great opportunities to discover more about MySQL with several excellent MySQL events.
Last may I wrote about Reestablishing a MySQL Tradition where we used to have shirts just for those who contributed code to MySQL. Unfortunately that tradition was not kept during various transitions. But Antony Curtis
class="alignleft" alt="Percona XtraBackup" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/01/Percona_XtraBackup.jpg" width="229" height="87" />Percona XtraBackup 2.1 has been in GA now for a little over four months and has some impressive new features to improve backup performance, security, and storage requirements. When used with
href="http://www.percona.com/software/percona-server" target="_blank">Percona Server, additional features are enabled that can provide even more dramatic performance improvements.
class="alignright" style="margin-left: 9px; margin-right: 9px;" alt="Percona Live London" src="http://www.mysqlperformanceblog.com/wp-content/uploads/2013/06/Percona-Live-London-2013.jpg" width="293" height="82" />The Sept. 8 deadline is looming to
href="https://www.percona.com/live/london-2013/user" target="_blank">submit your speaker proposals for Percona Live London 2013′s conference breakout sessions and tutorial sessions.