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 …

Percona and Monty Programming AB announced formation of Open Database Alliance. Read on press release for details.

Entry posted by peter | 2 comments

Add to: | | …

Just over a year ago we registered the domain name mysqlfoundation.org in the hopes that Sun/MySQL will actually create such an entity.

My idea was to move the development of the MySQL Community server to the Foundation and make the development fully community orientated. The Foundation would have its own development goals and release schedule. Sun could then pull patches from the Foundation's Community server into the Enterprise server once they had stabilized.

I pitched the idea to several people at Sun back then and over the last year, however, for some reason, the foundation concept just proved impossible to push through.

I believe this would have been a great opportunity for Sun to take the leadership in the community, as the foundation idea dates back to before things really started …