Two weeks into the New Year, and four weeks since I got back from Thailand, I finally get round to updating this thing. By “updating”, I don’t just mean posting. Gojira the One-Lung Webserver has had an overhaul as well: I’ve added some more RAM, caught up with the last couple of months’ worth of Windows 2000 patches, updated to the latest versions of PHP, MySQL, WordPress, and Cygwin. (Tip: If you’re running PHP and MySQL on Windows, be sure to get rid of the libMySQL.dll that comes with PHP — because it’s crap — and to use the version that comes with MySQL instead.)

So… 2006 was a pretty decent year, with a number of positive changes:

• I got to see my daughter grow up some more. She’s just more amazing every time I see her.
• I got out of the hell-hole of a house that I’d lived in for 3 years. I must admit that I had some mixed emotions about that. I’d lived there …

While MySQL customers have been bitterly complaining about the move to package support and rigorous testing of binaries into a paid package, Stephen Walli of Optaros has been thinking:

What if Microsoft SQL Server open sourced their codebase, provided support and testing of binaries in a paid package similar to MySQL Network, and “DB mashups” ensued?

http://stephesblog.blogs.com/my_weblog/2007/01/microsoft_and_m.html

It’s an interesting read to get you thinking. Most of my thought was, “that’d be neat….I wonder if folks would stop complaining about the MySQL Enterprise and Community models if that actually happened.”

Flying to Boston this morning, I have a talk to give at MIT tomorrow, and will spend the rest of the week with the MySQL Falcon team.

So how is security this morning?

The raver chick in front of me in line had a "gallon bag" which the
agent spent ten minutes on trying to help her sort through. He
wouldn't let her friend take anything from the bag and pack it in her
own.

"Sorry, it is her stuff and she is limited to the advertised amount."

He helped her sort out the liquid items since she had the bag
completely filled.

He put the glitter in the liquid bag.

Glitter is a liquid?

Now it floats in air so it is sort of a fluid... not really.

This doesn't matter to me at all though.

Why is that?

Did I …

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