There is a bug in MySQL that causes an UPDATE to fail with a unique index violation, even though the statement doesn’t create duplicate values. In this article I’ll explain when this bug can happen, and how to work around it. The bug This is easiest to demonstrate with SQL: create table t (i int not null primary key); insert into t(i) values (1), (2), (3), (4); update t set i = i + 1; -- ERROR 1062 (23000): Duplicate entry '2' for key 1 The bug is caused by MySQL’s method of updating the values.

Garvin Hicking has released Serendipity 1.0 today.

Congratulations to Garvin and his contributors! Thank you for the best blogging software there is!

Garvin Hicking has released Serendipity 1.0 today.

Congratulations to Garvin and his contributors! Thank you for the best blogging software there is!

For those interested, there is now a Spanish translation of the MySQL Reference Manual online:

http://dev.mysql.com/doc/refman/5.0/es/index.html

In addition, the Connector/ODBC documentation has been re-worked, you can see it at:

http://dev.mysql.com/doc/refman/5.0/en/myodbc-connector.html

If you happen to use MySQL and live around Hamburg, Germany, here's your chance to meet with other MySQL users, developers and DBAs: I am happy to announce the second Hamburg MySQL Usergroup Meeting, which will take place on Monday, 3rd of July, 19:00. The location will be the same one as last time, the chinese restaurant Ni Hao in Hamburg-Wandsbek.  The food there is quite excellent and they will provide us with a separate room and video projector again. I'll try to arrange a presentation about MySQL and there will be plenty of time for chatting and discussing. If you'd like to join us, please RSVP via our event page on meetup.com and join the mailing list for further details! Looking forward to meeting you! Some pictures of our last meeting are available …

This might be handy

Jeroen Swart, one of the most capable and knowledgable Microsoft .NET Professionals I know, provided me with a pointer to www.connectionstrings.com. This site lists connection string formats for a whole bunch of databases. Of course, Oracle, MySQL and MS SQL are there, as are Postgres and DB2.

But what about Mimer? Lightbase? Right, that's why you might visit them.

Actually, there are also some products missing, like HSQL and SQLite and what have you. And they could pick a nicer Icon for MySQL. Otherwise, handy site.

I'm continuing my experiments with different OS and today I tested FreeBSD 6.0 on my box.
(more details about box and benchmark see here http://www.mysqlperformanceblog.com/2006/06/13/quick-look-at-ubuntu-606/).
Initially I was very pessimistic about FreeBSD, as results were (in transactions/sec, more is better.
for comparison the results from Suse 10.0):

As I mentioned here, I?m a member of the documentation team at MySQL, a job I started back in April. I?ve just completed a major tranche of documentation, and thought it would be interesting to let you guys know exactly what happens in a typical day for a member of the documentation team.

read more

There are some proposed changes in the Australian copyright law that are just too weird.

Australia has its newish free-trade agreement with the US, and so is now harmonising some of its laws. Unfortunately, things are being tightened without the corresponding "fair use" clauses that are part of the equivalent US legislation, and some flawed US stuff like the DMCA is also finding its way into the Australian proposals... laws have a fairly long cycle. The DMCA may get fixed at some point, but a new Australian law will take years again to pick up any such changes.

So, about the new copyright proposals:The proposed changes include allowing individuals to record a television program but only allowing a single viewing before it must be deleted.
The proposed laws also make it illegal to lend recorded programs to friends …

In recent articles I explained how I've optimized queries on some large tables at my current employer, and how I've written archiving and purging jobs to trim the tables down to a manageable size. This article explains how I re-indexed some of those tables without taking the server offline.