MySQL Toolkit's Show Grants tool can now separate grants into individual statements, convert them into REVOKE statements, and help you remove users from a server, even if your server doesn't support DROP USER.

I've already wrote we do not generally do a lot of on-site onsite consulting, but as I'm anyway going to be speaking at MySQL Users Conference anyway it may be good time for some onsite jobs. In fact I have already scheduled visits on Friday, Monday and Tuesday following the conference but I can do couple of more till the end of that week. Just let me know soon before I bought plane tickets.

I also know I virtually know a lot of guys from Sillicon Valley and SF whom I'd love to meet in person. Drop me a note if you're interested I'll have number of evenings and post conference weekend available.

See here.

After a great reception to my MySQL talks at PHP Quebec, I've decided to go ahead and start a user group in Montreal.

I'm still searching for a venue, so let me know if you can help out!

I've heard a lot about Ruby on Rails, and finally had occasion to try to use it. This tutorial was very well laid out, and entirely true - maybe a half dozen commands and a couple dozen lines of code later, there was a nice set of "scaffolds" for browsing & editing my data model.

It didn't "guess" my data model, but I prefer to tell a framework how to handle relationships. Telling rails was as simple as adding a handfull of commands like "has_one :parent", "belongs_to :category". And then you get drop-downs for foreign key values and column sorting virtually free.

read more

It's time for another Meetup of the Hamburg MySQL User Group! As for previous events, we'll meet on Monday, 2nd of April at 19:00 in the Chinese restaurant Ni Hao in Hamburg-Wandsbek.

This time there will be a presentation about "Xing/OpenBC growing pains", held by Erick Dennis und Michael Otto from epublica, the company behind Xing.com.

The talk will be held in english and is a rehearsal for their presentation at our upcoming MySQL Conference and Expo, which will take place from April 23rd-26th in Santa Clara, California. Please subscribe to our …

So far we have received 16 entries for the Proven Scaling Free Ride to MySQL Conference and Expo 2007, which will be in Santa Clara, California, April 23-26. (A recap: We are providing free airfare, hotel, meals, and a full conference pass to three people who impress us with their submissions.) A few of the submissions so far have had the panel laughing hysterically (and we DO appreciate a bit of humour in our judging). A few of you have not tried at all. I thought I’d provide some tips on what helps and what hurts as you submit your entries:

• Helps: Showing that you have a sense of humour, and can tell a good story.
• Hurts: Leaving all of the entry blanks empty.
• Helps: Showing some humility, and that you will …

On Thursday I saw something I’d not seen before. An Empty Innodb Status. Now given the amount of output normally shown it was certainly a first. And it looked like:

mysql> SHOW ENGINE INNODB STATUS;
+--------+------+--------+
| Type   | Name | Status |
+--------+------+--------+
| InnoDB |      |        |
+--------+------+--------+
1 row in set (0.03 sec)

To answer some of the most obvious questions.

• Yes it was a working existing MySQL instance, with InnoDB correctly configured. Indeed we had been benchmarking for several hours.
• MySQL Server was running, indeed a command selecting data from the mysql schema worked just fine after seeing this (All other tables were Innodb).
• Absolutely nothing in the host MySQL error log. (This was the second most disappointing aspect)
• The Process List showed two queries that had been running for some time, everything was taking  ; 1 second. …

Charlie Babcock's GPLv3 story hit this morning. It's an interesting and thoughtful read, and goes to the heart of one of the big disagreements in open source: how far can a license go in seeking to ensure freedom?

There's a rift developing between camps within the free software movement over the next version of the most popular open source license, known as the General Public License, or GPL. And while that infighting might appear to be little more than a family squabble, its ramifications could be significant for how companies use open source software in the future.

A new version of the GPL, the third overall and the first revision since 1991, was supposed to be released this month. But controversy over several new provisions--and the authors' ambitions to thwart Microsoft's Linux pact with Novell--have delayed it until later …

mysql has quite a few open job listings. some positions of note: web developer, support engineer, maintenance developer, qa engineer, and performance architect. all of these positions are available world-wide, so you get to work from home. some of the other jobs from the full list are …