Earlier today, MySQL 5.1 was downloaded for the millionth time.  Pretty cool!  I wonder if we can find out who the lucky downloader is who got the millionth copy.  Maybe we could embarass them with a MySQL logo prize or something at the MySQL Conference April 20-23 in Santa Clara.

Congrats to all those who created MySQL 5.1, to all our users, to the many who found, fixed or otherwise helped us chase down bugs.  Thank you for making this a great release!  

• MySQL: MySQL 5.1 Download, …

Error can’t create table … I was trying to add new table and alter another table to add new column and foreign key to the new table. Here’s basically what I had When I execute the code, I got an error message something like Error can’t create table … (errno: 150). It turned out that […]

A (slightly belated) Happy New Year to you! I just returned from my Christmas vacation two days ago, which I spent mostly at home and with my parents-in-law in St. Radegund, Austria. Now I am busy catching up with what has piled up during my absence (I managed to resist the temptation to check my work email during the time off).

Some MySQL-related news that came up in the past weeks and are worth sharing:

• My talk about MySQL HA solutions has been accepted in the main FOSDEM conference track
• The FOSDEM organizers also accepted my lightning talk proposal about Bazaar - it will take place on Saturday, 14h20 (tentative)
• MySQL will have a …

A (slightly belated) Happy New Year to you! I just returned from my Christmas vacation two days ago, which I spent mostly at home and with my parents-in-law in St. Radegund, Austria. Now I am busy catching up with what has piled up during my absence (I managed to resist the temptation to check my work email during the time off).

Some MySQL-related news that came up in the past weeks and are worth sharing:

• My talk about MySQL HA solutions has been accepted in the main FOSDEM conference track
• The FOSDEM organizers also accepted my lightning talk proposal about Bazaar - it will take place on Saturday, 14h20 (tentative)
• MySQL will have a …

Wohoo!

I just got word that the proposals I submitted for FOSDEM are appoved! I was going to go to FOSDEM no matter what, and when I saw Lenz Grimmer's call for participation, I decided to give it a go.

I'll be doing two talks:

• 
  
• MySQL Plugins - Learn about this exciting MySQL 5.1 feature
  
• Starring Sakila - A datawarhousing and Business Intelligence mini-tutorial using the Sakila sample database
  

Having the opportunity to do these talks adds to the fun, and I feel honored for being given the chance. Thank you!

This year, Fosdem looks very promising for the MySQL crowd. Lenz himself is …

We’re happy to announce the first version of the Gearman rewrite in C, along with some interesting new MySQL UDFs based on the C library. Check out the Gearman wiki for an overview of what this is, download details, and API documentation.

For the anxious, here is a quick how-to:

Download: http://launchpad.net/gearmand/trunk/0.1/+download/gearmand-0.1.tar.gz
tar xzf gearmand-0.1.tar.gz
cd gearmand-0.1/
./configure
make
make install

You should now have the job server (gearmand) installed in /usr/local/bin, along with headers in libraries in /usr/local/lib & include. You can now see it work by running some simple clients and workers in the examples/ directory:

gearmand &      (this is assuming /usr/local/bin is in your path)
cd examples
./reverse_worker &
./reverse_client "Hello, Gearman!"

If everything went well, your terminal should look something …

A collague at Sun asked me for tips on how to tune MySQL to get fast bulk loads of csv files. (The use case being, insert data into a data warehouse during a nightly load window.) Considering that I spend most of my time working with MySQL Cluster, I was amazed at how many tips I could already come up with both for MyISAM and InnoDB. So I thought it might be interesting to share, and also: Do you have any more tips to add?

[A Sun partner] have requested to do a POC to test mysql's bulk loading capabilities from CSV files. They have about 20GB of compressed CSV files, and they want to see how long it takes to load them.

They haven't specified which storage engine they intend to use yet.

Good start, well defined PoC. The storage engine question actually is significant here.

- MyISAM typically may be up to twice as fast for bulk loads compared to InnoDB. (But there may be some tuning that makes …

We re-ran iiBench based on Mark Callaghan's excellent work. We used standard InnoDB engine in MySQL 5.1 without the Google or Percona patches. Our hardware is similar to Mark's except we used a 6-disk hardware RAID 0, whereas Mark employed a 10-disk software RAID 0. We ran on the same hardware as we did before, a Sunfire x4150 with 8 cores and 16GB of memory, and we made the following changes compared to our original run:

• 6 SATA disk HW RAID 0 (original run on 6 disk HW RAID 5)
• 1,000 rows inserted per SQL INSERT statement
• Used my.cnf settings based on what Mark did and what Percona suggested. …

I have been tagged by numerous people (Marcus, Lars, Mark and probably a few others .. just too man people playing along!).

So semi random facts about me ..

• I actually picked my first name Lukas myself. At birth my name was Kahwe Haddad, but when I was adopted by the man I call my father in elementary school I changed my last name to his and also picked a new first name, moving Kahwe to be my middle name.
• As some may have guessed from my birth name, I am half persian on my fathers side. My mother is from East Germany and actually escaped with her family from East Germany. My adoptive father is american. So I am a German, with a …

Installing Nginx With PHP5 And MySQL Support On Ubuntu 8.10

Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on an Ubuntu 8.10 server with PHP5 support (through FastCGI) and MySQL support.