Maybe it's a sense of shared adversity, but recent MySQL meetings have had this "we're all in it together" feeling. Today Monty Widenius announced the Open Database Alliance: the community feeling is starting to look like a real business entity.

The Open Database Alliance is appealing at multiple levels. First, it's good for the companies that join--a steadier flow of business and ability to offer bigger solutions by combining with partners. Second, it's good for users: first rate software, services, and support without vendor lock-in. Third, the parties are going to be excellent.

Sometimes you have to think hard before signing up for partnerships. But this one looks like a no-brainer. Count us in!

…

Sun Microsystems today announced that the University of Duisburg-Essen (UDE) in Germany has purchased a MySQL Enterprise Unlimited database subscription to provide extra support for the E-learning system that the university's IT staff has developed and deployed for the entire University Alliance Metropolis Ruhr (UAMR). With Sun's MySQL Enterprise Unlimited offering, the UDE receives access to the advanced MySQL Enterprise Monitor software as well as around-the-clock technical support for any number of database applications – all for one affordable, fixed price.

The big news coming from the MySQL Community today is that Monty Widenius and Percona have founded the Open Database Alliance, a group focused on “unifing all MySQL-related development and services, providing a solution to the fragmentation and uncertainty facing the communities, businesses and technical experts involved with MySQL”.

I, for one, am 100% behind this. I’ve always been a big fan of community foundations being a focus point for development efforts, they work well to bring everyone together, and to provide a sensible foundation to help avoid much of the uncertainty that seems to spring up around MySQL. I certainly hope that the ODA is able to do the same.

Though I do have one question, how does the ODA plan on handling competing members? If you have two companies offering the same service in the same market, which one will the ODA recommend? …

If you’ve looked at your WordPress.com blog stats today, you might have noticed the charts look a little different. We’ve replaced the old proprietary chart object with Open Flash Chart, an open source alternative.  Charts now look like this:

(Though I can’t guarantee you’ll see numbers like that).

All the old charts are still available in more or less the same form.  And we’re hoping to explore some of the new possibilities Open Flash Chart has to offer – so keep an eye on your stats.  Like we had to ask.

And in case you missed it: yes, blog stats now work in your time zone.

…

I do not know if you noticed it, but Google (Mark Callaghan, Justin Tolmer and their internal mysql-team) made a great contribution to MySQL. Patches global transaction IDs, binlog event checksums and crash-safe replication state are separated and published on Launchpad (https://code.launchpad.net/~jtolmer/mysql-server/global-trx-ids).

For me it was a big wall in using these patches that they were part of one big patch, which you can apply only to 5.0.37, and now there is no barrier to include patches into our builds or MySQL releases.

If you do not know what is Global Transactional ID is - it is worth to look …

I've been looking at the cost recently of fetches for libmemcached, and seeing if there was anything I could do to increase performance.

What did I find? Half the cost currently is in the snprintf() sitting at the protocol sender.

Half!

Good news about this?

If you are using the new binary protocol with Memcached this goes away completely :)

snprintf() sucks.

Back in 2007 I, and then several others, pointed out the Innodb Concurrency should be set to zero (or any large number) if you are planning on scaling.

http://krow.livejournal.com/542306.html

I don't get why anyone is congratulating themselves on this self discovery, since we have all known about this for over two years. It is great to see that the default setting for 5.4 is finally being fixed but this shouldn't be a revelation to anyone who has been working with the server for years (and the Innodb team fixed this in their own plugin a while ago, which should be no surprise since they author the code). This was one of the first, and frankly simple, changes made to Drizzle.

Here are some more obvious ones:
Kill the query cache (and disable Stored procedures and their cache if you can).
Remove the locks around show process …

Someone pointed this out to me the other day. Look at the comment on the revision:

Merge community up to enterprise, thus ending the community-server adventure.

As many of you already know, MySQL Workbench offers powerful scripting support and a plugin interface that allows anybody to extend the application or add new functionality.

The latest addition to the WB plugin family has been written by Thomas Henlich. It features SQLite compatible SQL export of your Workbench models.

Download it from his blog and please provide feedback on the forums.

• Thomas Henlich’s Blog
• Forum discussion

We are working on improving the scripting support in WB 5.2 and finally adding proper documentation so even more people can contribute.

As you know Sun/MySQL and MeetUp.com could not agree on terms of the sponsorship and so now all MySQL meetup organizers have to pay for their Meetups or move them to the different location. Facebook is suggested as one of alternatives.

I'm not to take any sides in this story and judge who is wrong and who is right but I think it is quite a bad situation to be forced to move off meetup with just a 7 days notice. It may be good idea to host communities in the space which does not make organizers dependent on the sponsor but I think Meetup organizers deserve more time to arrange the move.

We spoke with Jeremy Cole and agreed it will be a good idea to offer the sponsorship MySQL Meetup organizers looking to stick with Meetup.com a little longer. You can read Jeremy's posts on the same matter …