What a surprisingly busy week.
Spent quite a lot of time tracking down a linking problem on
Itanium. It appears that GNU ld 2.14 has some serious
deficiencies. GNU ld 2.17 (the current stable release) does fix
the problem. Unfortunately, the last supported version of GNU ld
on RedHat AS 3 for Itaniam is version 2.14.90.0.4.20030529 -
which clearly cannot contain the fix which was written in
November of 2003. I suppose what to do is now a decision to be
made by someone else.
Also spent some time with Federated - Bulk insert support within
the storage engine and also how to make Federated play better
with transactions and network overhead. Have to put together a
new WorkLog entry if I cannot find a relevant one. I need to work
on writing better changeset comments. Ingo says, and I have to
admit that I agree a bit, that my comments assume that the reader
is familiar with the code and bug in question. I need to make
them a …
The 2007 MySQL Conference is over, and I finally made it back
home. I have some notes on some of the sessions, which really
aren't that great, so if you want to see what you missed, you
should read Planet MySQL. But I will give some of the
highlights.
There's a lot of new development around storage engines.
MySQL-5.1 has a pluggable storage engine architecture which
allows you to load and unload storage engines while the server is
running. Brian Aker explained that this is for cases where you
have a stable server setup and only want to upgrade the storage
engine. All the storage engines in 5.1 are pluggable, and there
are already some third-party proprietary storage engines
available.
One of the relatively new third-party storage engines is SolidDB.
Solid has been around for quite awhile. In fact, I was using
Solid for a project in the late 1990's …
I find myself thinking about Federated and about how to improve it's connection pooling. Whatever is done should be made safe for transctions. Unfortunately, we cannot suspend and join XA transactions which is a pity as it would make it much easier.
One of the unique elements of MySQL is the ability to use a different storage engine to store your data. You can even mix and match storage engines within the same database.