A bug titled DELETE FROM inconsistency for NDB (Bug#19066) dropped into my lap, and while fixing it, we had to make some hard decisions on what should be considered the "correct" way to solve this.

The bug is related to the difference between TRUNCATE TABLE and DELETE FROM with no WHERE clause. On the surface, they seem to be equivalent, but when digging deeper, we will see that there is big difference between the statement when replication comes into play.

Before delving into the problem and the solution, I'll start by recapitulate some selected parts of the manual.

• The TRUNCATE TABLE and DELETE FROM with no condition are "logically equivalent": TRUNCATE TABLE empties a table completely. Logically, this is equivalent to a DELETE statement that …

I've spoken with all of the participants in our "How I Work" series and we're all having the same reaction. Not only is it cool to see how our peers do things, but you can actually put this stuff into practice. After reading Brian Akers' profile, I immediately started using OmniOutliner for my todo list. Now if only I could somehow sync it to a web interface...

All of us were surprised how many others use Macs and Treos. In fact, it seems that those who use Macs use Treos and those who use Windows lean towards BlackBerry. To that end, none of us have gotten a damn thing for free from either company. One of my Bschool chums works for Palm and thinks he can pry a 700p out of their coffers using the family discount, but not for free. I still can't believe Cingular and RIM haven't hit us up to test drive the 8700, which Peter was raving about and has made me rethink my Palm choice.

Anyway, if you want to do your "How I work" just follow …

Unisys Corporation (NYSE: UIS) today announced that it has signed a worldwide distribution agreement with MySQL, Inc. that will enable Unisys to distribute MySQL software products and provide consulting, integration and support services for customers implementing MySQL open source databases in their technology infrastructures.

I’m clearing some space on the bookshelf and have a few books up on eBay looking for a good home.

Click Me!

One of the things I did this weekend was knit the pattern I’d made for Sakila, the dolphin in the MySQL logo. Click on the image for a bigger picture:

The only problem is I have no idea what to do with it. I have more of the orange and blue yarn. I thought I would make it into a purse but it turned out much wider than I expected. I could make it into a big handbag but I don’t think I’d use it. Any suggestions?

The pattern itself:

dolphin: (56 sts wide by 59 rows)
When I say "k to stitch marker and remove", I mean knit to the stitch marker, and take the stitch marker off.

cast on 56 sts.
knit 2 rows

I had to tweak the pattern mid-knit, so I *think* this is the correct pattern. If the count looks OK for …

Just spotted: Microsoft CEO: catching Yahoo, Google to take time"We are a little bit late in the game," Ballmer said. "But at the end of the day it is going to be about the ability to create a mass marketplace for buyers and consumers."
Ballmer said Microsoft would seek to create a marketplace where consumers want to spend their time and advertisers want to spend their money.
It also plans to leverage the popularity of its MSN, Hotmail and Instant Messaging products, he said.
"We are hard at work on our own core services where at the heart we want the users to be in control," Ballmer said. "There is a whole set of things we are doing to let the user be in control."Oh dear Mr Ballmer... users in control will not, at least in the long run, put up with advertising bombardments and being treated like a bunch of consumers in a mass market. That's not …

Franprix and Leader Price have chosen MySQL, the world's most popular open source database, to manage the data in their enterprise-wide supply chain and product distribution platforms -- servicing over 620 Franprix stores and 490 Leader Price outlets.

With MySQL 5.1 you can store the general query log in a table. But what if you don't want to log every single statement but only the users logging in and the hosts they're coming from? There exists in fact a very simple solution that even works with MySQL 5.0 and (with some changes) with earlier versions.

The idea is to use the init_connect server variable as a hook to install a logging routine. The init_connect variable holds SQL statements to be executed for each client that connects (except for SUPER users).

We need to create a database and a table first to hold our connection log. I don't really recommend to use the mysql database for this as we don't know what might be added in there by future …

I have a new web site. I registered the datacharmer.org and datacharmer.com domains, which are now jointly my main page. (Both addresses point to the same page)


Another change involves the MySQL General Purpose Stored Routines Library, which has evolved to version 1.0 (not alpha anymore). Its home is now at SourceForge.