The latest from the MySQL community

Last week Giuseppe Maxia announced the Call for Papers for the 2009 MySQL Users Conference and Expo, and also announced that there would be an unconference, MySQL Camp, organized by me.

It’s true! Currently MySQL Camp is set to happen, though I am still working out details with Colin Charles and Giuseppe Maxia. We had originally talked about having MySQL Camp on Tuesday and Wednesday, but I would like to add Monday so that folks attending the conference who are not attending a tutorial have a choice on Monday. I am also looking into lunch options, since the conference venue does not have many options within walking distance.

There will be plenty of …

While Colin beat me in blogging about Project Kenai, I think I can still provide some additional background information about this new project hosting service from Sun.

If you are a maintainer of an Open Source project, you currently have plenty of choice when it comes to getting your project hosted for free. One criterion could be your software configuration management system (SCM) of choice.

Some of the hosting services that I am currently aware of and the choice of SCM they offer include:

• BitBucket ( …

First of all, I know this is a known problem, but it struck me so hard, I just had to write about it!

As Peter Zaitev points out calling SHOW STATUS might have a huge performance impact.

We recently replaced one of our servers with a DELL R900 with 96GB RAM. Having a disk-bound workload and > 1TB worth of data in InnoDB we expected a noticeable performance gain compared to the former server with 32GB. The new server even has better RAID and HDD.

But that was not the case. Things got even worse! A lot of queries “hang”, server load peaked at almost 7 and we saw a lot of cpu activity. Just before I started a deep analysis of what is going on inside I spotted a SHOW GLOBAL …

The Netways Nagios Conference 2008 in Nürnberg (DE) was opened today by Ethan Galstad, creator of Nagios. He gave an overview of how Nagios evolved and the steady growth of the monthly downloads, now reaching 16k!
The Nagios 3.0 overview was quite nice. Apparently lots of effort was put in optimizing it for bigger setups, like doing host checks in parallel and changing internal structures not using linked lists.Great was also to hear that the web interface is being revamped, as well as the Embedded Perl becoming some kind of plugin, called Event Broker Modules. This is however for the next experimental versions (v3.).NRPE/NSCA are probably doomed to go into maintenance. Ethan said they would likely be replaced by more standard protocols and web services.
MySQL was mentioned when the NDOUtils were …

I have been talking about the UDFs for MySQL during lunch, and Knut Anders bragged about being able to do that in Java DB as well..

So what could I do? I just had to challenge him ;-)

As always, Knut Anders delivers! Just check out the blog entry he wrote!

Knut Anders, I'm impressed! This looks like a clean solution! keep up the good work! (By the way, you should use SMF to control the memcached server. Check out my blog post for the details).

Sun is a huge company. So it comes as no surprise that I’m finding out about Project Kenai via Tim Bray, instead of some internal mailing list (believe me, there must be thousands).

Tim’s got a Q&A with Nick Sieger, who’s one of the chieftains behind Kenai. I find it amusing that the comparison is made against Google Code and GitHub - has SourceForge hit irrelevancy? I’m surprised Launchpad isn’t mentioned.

Very Cover Flow like UI, with slider, etc. That’s Elliot Murphy, ex-Dolphin, current Ubuntero in the pic above

Nick goes on to say “We need a place to nurture and grow our open source communities that we …

Do you have a full time System Administrator? Do you have only a part-time SA, or none at all? Packet General’s Data Security and PCI Compliance solutions run on a dedicated appliance, based on a “Just Enough Operating System” (JeOS) to minimize exposure.

Good news fellow DBAs; adding to the already packed list of RSS/Atom aggregation sites out there on the internet, there is a new site catering to DBAs called Relationalnews. Feel free to add your feed(s) for aggregation, because what else do bloggers want but more visibility to search engines, right? This was basically a coding project to get familiar with CodeIgnitor as well as RSS and Atom xml feed processing in PHP. Pretty simple looking back on it, and it was generally a fun project.I’ll probably add more features to the site at a later time, with free time being what it is…So read the news! http://relationalnews.com 

When Brian began the work on refactoring the MySQL 6.0 Server source code into what has now become the Drizzle Project, a number of code pieces were removed, including some major MySQL functionality such as stored procedures, server-side prepared statements, SQL Mode, some legacy code, and a variety of data types. The goal, of course, was to reduce the server code base down to a more streamlined and eventually modular kernel.

Of course, that vision is great, but it's got some side effects! One of those side effects is a dramatic reduction in the number of test cases that pass the test suite in their current form, and an increase in the number of tests that have been disabled. I re-enabled and fixed a few tests yesterday, but as of this writing, there are only 54 of 408 tests currently passing in the test suite.

…

Within minutes after Finland was just about to win 3:2 over Germany in the football world championship qualifications (but it ended 3:3), I got a bit of consolation for myself, my dual-citizenship son cheering for Finland, and my fellow countrymen using MySQL:

We have the next MySQL 5.1 Use Case article live, and it’s about FC Inter Milan. No Finns playing there (but stars such as Ibrahimovic, Materazzi, Luis Figo, and Adriano). And, from a MySQL perspective, the interesting point is that FC Inter Milan is using both MySQL 5.1 Partitioning and the Event Scheduler in an innovative way.

Thanks Corrado Pandiani for the story — let’s hope your good Use Case inspires others! …