The other day I was running pt-duplicate-key-checker on behalf of a customer and noticed some peculiar recommendations on an InnoDB table with an odd structure (no PRIMARY key, but multiple UNIQUE constraints). This got me thinking about how InnoDB promotes UNIQUE constraints to the role of PRIMARY KEYs. The documentation is pretty clear:

[DOCS]
When you define a PRIMARY KEY on your table, InnoDB uses it as the clustered index. Define a primary key for each table that you create. If there is no logical unique and non-null column or set of columns, add a new auto-increment column, whose values are filled in automatically.

If you do not define a PRIMARY KEY for your table, MySQL locates the first UNIQUE index where all the key …

The folks at Ubuntu are running a contest to see who can write the best juju charm!

Juju is Ubuntu’s cloud deployment/service orchestration tool. Charms are
the scripts used by juju to do software deployment and management.

Currently MySQL has ~8800 downloads from the Charm Store, making it the most popular service deployed with Juju.

The contest runs until October 22, and has over $60K in prizes to be won. For more information see: https://github.com/juju/charm-championship.

I am about to give a talk at MySQL Connect about what you need to know before upgrading to MySQL 5.6.

The PDF slides are online at http://bit.ly/upgrade56. I will be posting a video in the next few weeks!

I am about to give a talk at MySQL Connect about what you need to know before upgrading to MySQL 5.6.

The PDF slides are online at http://bit.ly/upgrade56. I will be posting a video in the next few weeks!

The 3rd season of MySQL Marinate begins October 1st, information pills or if you prefer, price MariaDB or Percona.

If you do …

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.

But if you look back over the last few years, MySQL is still functionally a lot like it used to be. OK, we’ve got row-based binary logging — but we had binary logging and replication before, this is just a variation on a theme. Partitioning — that’s a variation on a theme (partitioned tables are a variation on non-partitioned tables). Performance — same thing, only faster. And so on.

I’m painting things with too broad a brush. There’s actually a lot of stuff that’s NOT just a variation.

But if you look around at what’s out there …

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. But this class will on version 5.6 and seats are available!

What is TOD? It is where you follow video delivery of event at your own pace, and schedule access to course environment lab exercises at your own convenience. An instructor is available to answer any questions you have online. This class will be where the TOD materials are recorded. TODs are important for the MySQL area because this flexible, no travel …

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.

At first I wanted to cover all autumn events here but if I did that this post would be far too long. So instead I’m focusing on a few wonderful MySQL events that I’m going to be involved with in September.

In a few short days we’re running Percona University at Washington, D.C. This free event on September 12 provides a great opportunity to learn about latest developments in the MySQL ecosystem as we at Percona see it. I personally will be speaking about …

I open this blog to announce that I will be speaking at MySQL Connect in 2 weeks.

 I will present a conference session :

• 50 Tips for Boosting MySQL Performance [CON2655], Saturday 21 Sept, 1PM

and a tutorial session :

• Enhancing Productivity with MySQL 5.6 New Features [TUT8131], Monday, Sep 23, 1:15 PM  

I am very happy to be part of this great event and to be able to meet the MySQL Community, our customers and my colleagues there. Looking forward to seeing you !

It is not too late to register !!

…

Cool project. I’m really excited to see the results. 🙂 keep going

The MySQL engineering team constantly works to bring you huge performance improvements with each new release of MySQL. Here are four ways to help you get the most from these improvements

Tap into Sveta Smirnova's MySQL performance expertise on October 1st 2013 at 10am Central European Time, by attending the 1-day virtual seminar, Troubleshooting MySQL Performance with Sveta Smirnova. Sveta starts with basics, working towards more advanced cases that DBAs usually need years of experience to identify or solve. Click here to learn more about this seminar and to register for the event.

The …

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. But if you look back over the last few years, MySQL is still functionally a lot like it used to be.