A quick workaround for the tablespace bug I reported earlier to MySQL.

An extent can't be reused to another table until a LCP has been performed. You can force a LCP by using 'ndb_mgm -e "all dump 7099"'

At least now you can cotinue adding stuff to your database while not having to add extra tablespaces altough you deleted the data ... to be continued :)

No, this isn't about our multi-year extension of the InnoDB agreement with Oracle...  Instead, Apple has said that they will enable intel Mac users to run Windows.  Ok, they are doing it in an unsupported fashion with a bootloader called "Boot Camp" and customers need to install their own copy of Windows XP.  But still, it's a significant change of mind from Apple.  Well done guys!  Maybe Dvorak was right all along.

What's next?  Will Microsoft give a keynote at LinuxWorld?  Actually that happened this morning also, with Bill Hilf, General Manager of Platform Strategy.  …

The Spread Toolkit is one of my favorite Open Source projects. Spread lets you send multicast group messages between applications. It provides reliable, ordered, asynchronous message delivery, and it's efficient, works on large wide-area networks, and can survive and recover from network failures.

What kind of things could you do if a MySQL server could send and receive messages using Spread? I started a new project, the MySQL Message API, to find out. For a few ideas to get started with: if you want to notify a bunch of application servers whenever a particular table changes, you can write a simple trigger to send them all a message. Or if you have lots of different specialized database servers powering your 30-million-user social networking site, you might want to send messages from one server process them (with stored procedure code) on another.

The Message API is a set of MySQL …

For all of the innovation that occurs in today's technology marketplace, the most commonly used business applications-those associated with Microsoft Office -- remain stale and hackneyed. While we wait for Microsoft to come out with a new version of Office that overshoots user need while ensuring that consumers, businesses and government remain locked into Microsoft specific standards, I put forth the notion that an open source business productivity suite has the rare opportunity to dislodge Microsoft's stronghold on the desktop - it just needs a little help from the community.

The Ultimate Battleground?
We are on the cusp of a unique time in the Microsoft product lifecycle. Both Office 12 and Windows Vista loom on the horizon and IT shops and end-users around the world will have to decide just how much extra they are willing to pay (again) for applications like Powerpoint and Access, and how much they plan to use InfoPath and …

I'm using DBDesigner 4 quite a lot. I think the successor, MySQL Workbench, is very promising, but it does not meet my requirements (yet).

Having DBDesigner Generate SQL
Those that've worked with DBDesigner have probably noticed the particular strategy it uses to generate SQL code from the model. First of all, the user needs to specify what kind of SQL script is to be generated: a DROP, CREATE or optimization script. Then, DBDesigner does it's thing. In case of a DROP or CREATE script, exactly one statement is generated for each table in the diagram (or in the current selection if you choose to).

In case of the CREATE script, each CREATE TABLE statement contains not only the column …

I looked through the results of the 2006 SourceForge.net Community Choice Awards and was very happy to see that phpMyAdmin came out first in the Database and SysAdmin categories. Congratulations to Marc Delisle and the rest of the phpMyAdmin team!

phpMyAdmin will actually be showcasing their project in the DotOrg Pavilion at our MySQL Users Conference, taking place April 24-27 in Santa Clara, California. One more reason to not miss this event!

Today I was at the OSS Forum day in Hobart, really interesting. I was honoured to do the opening keynote, which I think was very well received. I met and talked with many good people. There's a lot going on here. Excellent.

This evening talked at the local Linux users group (TasLUG) about MySQL 5.1, which drew a fairly big crowd and we covered some very good and in-depth questions! Oh and the pub had good food, too...

From there, I went on a little two-hour roadtrip North and am now writing this from a hotel room in Launceston. The hotel is charging me an exorbitant amount of money to pick up some email on my laptop, about $0.50 cents per minute and it has just notified me that I actually reached some limit so it's now charging $0.20 per additional MB. Just great.

But, Launceston. I'll be speaking at the local TAFE (colleges …

LinuxWorld's Golden Penguin Bowl was a tight race, but in the end the MySQL nerds nailed a few critical questions to pull ahead and win. My favorite question was a quote about the MIT $100 laptop saying (essentially) that nobody in their right mind would want to use one of those slow, cheap, hand-cranked things. Neither MySQL or Oracle folks guessed that it was Bill Gates.

The Golden Pengin is quite a piece of art in itself, hefty large glass sculpture that is quite a thing to lug around. Jay got lots of strange looks coming home on the subway, and when my kids saw it the next morning they were shure it was some kind of glass rocket with a bent tip. Can't find a photo for reference in Google, if I get a chance to get a photo of it will post.

The photo (the best from a selection of pretty crappy shots) is of Brian Aker, Jay Pipes and Ted Ts'o singing a selection from an old IBM company songbook.

The next Boston MySQL meetup is just around the corner, Monday April 10th.

Jay Pipes is sticking around for a few days after Linux World to present this session, which was given as a webinar back in March and was the 2nd best attended webinar in the history of MySQL webinars. It's also a preview of Jay's performance talk at the MySQL Users Conference. Jay really knows his stuff when it comes to the inner workings of MySQL, you don't want to miss this:

Learn where to best focus your attention when tuning the performance of your applications and database servers, and how to effectively find the "low hanging fruit" on the tree of bottlenecks. It's not rocket science, but with a bit of acquired skill and experience, and of course good habits, you too can do this …

Just got back from the MySQL DevCon in Sorrento, Italy, followed by a fortnight's working holiday in Bangkok. The day before I left Italy, I received a 5AM call advising me that someone had broken into the house (again). My useless sod of a rental agent was reported to have said, "If he thought he might get broken into, he oughtn't have gone overseas." WTF? I was supposed to ring up our CEO and tell him, "Hey, Mårten, you don't mind pushing back the conference about six months until Yong Property Management (pathetically negligent) decide to pull their finger out and do something about the shoddy locks on the windows and doors of that piece of crap I pay them $300 a fortnight for, do you?" Right! Those losers couldn't even be bothered to come secure the door after the fact. If it'd not been for my yard guy and my housekeeper taking matters into their own hands and doing something about my back door having the glass bashed out of it and gaily …