Continuing MySQL saga… This is actually a follow up on my previous post. Developers tried to rewrite all statements and even overdid it. As we say in Russia - “teach fool how to pray and he will break his forehead”. Note, I had to rename columns/tables as I write so sorry for possible typos Query converted by [...]

Last week I needed to write an update SQL script that would insert some records into a database. However as the script was to be incorporated into a software update that was going to be deployed to all our customers, it needed to check some condition first and see, whether the insert was required at all.

Even though MySQL provides some non-standard SQL enhancement there is no INSERT IF EXISTS kind of statement.

I managed to do it using some temp-tables and a combination of INSERT IGNORE ... SELECT FROM and UPDATE ... WHERE statements.

The following example demonstrates how to insert a new row of data in the table named real_table. The data must only be inserted into this table, if another record in a table named condition_table exists. No change of real_table must occur, if there is no record matching the condition.

Moreover (because I …

Last week I needed to write an update SQL script that would insert some records into a database. However as the script was to be incorporated into a software update that was going to be deployed to all our customers, it needed to check some condition first and see, whether the insert was required at all.

Even though MySQL provides some non-standard SQL enhancement there is no INSERT IF EXISTS kind of statement.

I managed to do it using some temp-tables and a combination of INSERT IGNORE ... SELECT FROM and UPDATE ... WHERE statements.

The following example demonstrates how to insert a new row of data in the table named real_table. The data must only be inserted into this table, if another record in a table named condition_table exists. No change of real_table must occur, if there is no record matching the condition.

Moreover (because I …

From Rishab's excellent report came a few graphics that I thought worth calling out separately from the report itself. It's interesting to see how Europe's adoption and usage of open source compares with the US'. Here are a few slides (from IDC and Optaros - its report is here [Registration req'd]) that depict the differences.

First, here are the open source applications most prevalently used in Europe:

Compared to the US, first large ($1B+) enterprises:

And then mid-sized companies ($50M - $1B):

I will be spending the coming week in Washington, DC to attend a four day MySQL performance tuning training session.

I believe Tobias Asplund will be the presenter. During the MySQL conference last year (then known as MySQL Users Conference), I attended a three hour performance tuning session presented by Tobias and Peter Zaitsev and enjoyed it very much so I cannot wait to attend this one.

The training will be held at MySQL's training facility in downtown Washington, DC.

I will be staying at Washington Suites in Georgetown, DC. Their suites are less expensive than many hotel rooms.

A big thanks to …

Convert Flash Video (.flv) to AVI (.avi) or MPEG (.mpg) - lifehack.org: "Convert Flash Video (.flv) to AVI (.avi) or MPEG (.mpg)Hitrec at VideoHelp forum introduces a software called RivaFLVencoder which able you to convert .flv files (Flash Video) into avi and mpg files. This is extremely useful when you download youtube or google videos and you don’t like it play in flv player. With this

How to Download Google Video Okay, it is just not fun to play video online with slow Internet connection - to have smooth video playback, the best way it is still downloading the whole clip locally and playback. However Google Video does not provide a link for one to download. The movie is played by Google Video Player, which is Online Flash FLV player. New

I have a bit book of ideas, and I want to code all of them.

There is of course only so many hours in the day.

Ever since I first read about ATA over Ethernet I have been wondering if I could use this as some form of redundant bad ass storage for a database or any other block like need.

The API is easy, and sure you could use it just as a filesystem, but you could also just write to the interface.

Read the link I provided... its one of those interesting technologies that isn't getting a lot of headlines but you know... its got an open source implementation and a number of OS'es now have drivers for it. For SAN it makes a lot of sense. For a block network implementation it could be pretty nifty.

I had promised myself that in December I would set aside a couple of days for myself to implement a …

You know, sometimes there is nothing like finding the bug you have been hunting for, for a couple of days, on a Friday at 5:40 PM.

The optimize() call in Archive didn't have the right table buffer after someone updated the call to field->offset(). Tricky little thing... heisenbug (and no this is not in any release of 5.1 as far as I can tell, recent change).

Ok, technically this is a shroedinbug.

Oracle made a pretty big splash a while back when they announced their intentions to provide support for Red Hat Linux through their own forked version called Oracle Linux.  While Red Hat's stock took a short term hit at that time, since then, it seems like Oracle's impact has been a lot less than many people imagined.  By end of year, Oracle had 9,000 downloads.  While that's a decent number, it's pretty modest compared to most popular open source projects.  Red Hat gets about 12,500 downloads per day for RHEL and Fedora, and MySQL gets about 50,000 per day.

Interestingly enough, when Oracle and Red Hat announced their most recent earnings, Oracle's stock went down and …