It seems that there's a bug with MyISAM tables in any version of MySQL since 4.1 running fulltext indexes.

If you do a FLUSH TABLES (without replication running) and then copy these tables to another DB server (which is essentially a mysqlhotcopy) replication will eventually break with:


Error 'Incorrect key file for table './blogindex/FOO.MYI'; try to repair it' on query. Default database: 'mydb'. Query: 'DELETE FROM FOO WHERE FOO.DATE_FOUND < '2006-12-12 22:35:33'', Error_code: 126


This works just fine for regular MyISAM tables and only breaks for tables which have fulltext indexes. It seems that maybe the index isn't correctly being written to disk?

Today, I plan to merge the engines trees into the main trees. There are some bugs which have been waiting for as long as 2 months!

The Solaris Doors API, originally developed as a core part of the Spring Operating System, is basically nothing more than an RPC mechanism. The Solaris Doors, which are made visible as door descriptors (standard UNIX file descriptors) , relies heavily on threads and allows us to call procedures between processes on the same system. A door client makes a call to a door server which has a thread that is awaken, which passed the scheduling control directly to the thread in the door server. The control and the response is passed back to the calling thread when the door server has completed executing the request.

A door is made visible to other applications by attaching an already existing door descriptor to an existing regular file in the UNIX file system.

Solaris supports the following doors functions

• …

MySQL Lifecycle Policy Calendar

The official MySQL Lifecycle Policy calendar terminates the end of the Active Support Lifecycle for MySQL 4.1 at the end of this year. The product is then entering the Extended Support Lifecycle. Please click on the image and read "What is the difference between Active Lifecycle and Extended Lifecycle support?" to understand the implications of this.

Have an Intel Mac? Rely on SIP soft phones, like X-Lite? Realize that it always crashes?

Try the beta, from CounterPath. It’s not called X-Lite, its beta, so it might eat your babies, but I’ve been using it for a while (because MySQL loves VoIP), and it works a charm. Looks like my office phone is back in business, even when I’m on OS X.

This happened a few days ago a few houses up our street: Man crashes car into swimming pool (in the Australian, other mentions on ABC and news.com.au).
(There's a Dutch driving instruction joke: "kaboom = halt!, splash = water". This nutball managed to do both at the same time.)
FYI: two kids had just come out that pool only minutes before. The parked car (with a baby seat) had noone in it at the time. Its smashing into a pole caused a powerline across the road to snap, cutting the power to two houses and putting a rather dangerous live wire on the road, near debris, sparks and water).

A few years ago something similar happened early one …

One annoying aspect of SQL is that sometimes you really want to get some result out of an INSERT or UPDATE statement. But in MySQL, you can. It's just a nifty construct.

First just an UPDATE:

UPDATE tbl SET col = (@var := col), bla=value WHERE ...
SELECT @var

So, you can assign a column to itself (MySQL does a read before write, for updates), but also assign that value to a server-side variable which you can then retrieve. That's how you get data out of a row you're updating!

Now, how about the case where you need to insert something into one table, but regardless of whether or not it already existed you need to insert or update info into a second table (and also the id from the first table).
That's your christmas challenge from me.... no selects or transactions necessary. Good luck!

Need to post more regularly... once I have posting from the plam sorted out.
Actually, just posting more regularly would be a big plus.
(Sounds like a good new year's resolution)

Plugins... Nearing completion. Yay! Quite a reasonably tidy server variables declarations and implementation now. Just one variable which I may eliminate and free (potentially a few kilobytes) as it is no longer strictly necessary.
Right now, only InnoDB has been modified to take advantage of it - easily make MyISAM make use of it for it's few variables.
Need to concider splitting out more subsystems so that more globals can be removed.

Solid Information Technology, best known to the open source community as the providers of a new enterprise storage engine for MySQL, announced this week that it secured four million euros for the expansion of its open source initiatives (press release). The investors participating in this financing were Apax Partners and CapMan.

Although Solid is based in the United States, its investors are both European. I guess this explains why the press release lists the funding amount in euros and not dollars. I wonder if we will see more funding announcements preferring the euro as the currency of record. I left the euro symbol out of this post due to some character set issues.