I recently learned that my talk has been accepted for the 2009 MySQL Conference in Santa Clara, California. It is currently scheduled for Tuesday the 21st and titled MySQL and Search at Craigslist.

Here's the abstract (which I've promised to expand upon soon):

Millions of people search for things every day on craigslist: tickets, cars, garage sales, jobs, events, and so on.

This talk will look at the recent evolution of database and search architecture at Craigslist, including performance, caching, partitioning, and other tweaks. We'll pay special attention to the unique challenges of doing this for a large data set that has an especially high churn rate (new …

Topics covered include GlassFish v3, Java EE 6, Jersey, OpenSSO, Grizzly Comet, OpenMQ, OpenDS, JavaFX, OpenESB/Fuji, MySQL, partners XWiki, Valtech, Nuxeo and IzPack's despot Julien Ponge. Some are in French but the majority of the slides are in English.

Alternatively, …

MySQL Connector/C++ 1.0.2 alpha is available for download at http://dev.mysql.com/downloads/connector/cpp/1.0.html, please see also the official announcement. Only three weeks after the first alpha, we decided to release a X-Mas edition. Not only the winter evenings in the northern hemisphere have become quite long also the Change History got quite long. Long enough for a bug fix release which brings some minor feature additions and includes our JDBC compliance test suite for the first time. MySQL Connector/C++ 1.0.2 alpha is a source code only release, meaning that you will have to compile it yourself. …

MySQL Connector/C++ 1.0.2 alpha is available for download at http://dev.mysql.com/downloads/connector/cpp/1.0.html, please see also the official announcement. Only three weeks after the first alpha, we decided to release a X-Mas edition. Not only the winter evenings in the northern hemisphere have become quite long also the Change History got quite long. Long enough for a bug fix release which brings some minor feature additions and includes our JDBC compliance test suite for the first time. MySQL Connector/C++ 1.0.2 alpha is a source code only release, meaning that you will have to compile it yourself. Please …

Registration for the MySQL Conference and expo 2009 is now open.

Kudos to Colin Charles, who has the not easy task of being the program chair of the conference, for pulling the schedule together.

The schedule is not complete yet. If you haven't got either an approval or a rejection, your proposal is still under review. In the previous years, some of my talks were approved as late as February, but we are trying to finish off the schedule much earlier this time.

This is my last blog post for this year. I am going on vacation this evening. No computers, no internet. Therefore, no comments are enabled for this post (there would be nobody to moderate and approve them).

Happy new year, Community!

Yes, I’m speaking at  the upcoming MySQL Conference & Expo 2009 - on April 20 - 23 (and yes, it’s in Santa Clara again).

I have three sessions:

MySQL Cluster Tutorial: this time with 6.4 feature goodness. Very hands-on, very interactive.

MySQL Cluster on Windows:  (insert witty text about hating operating system freedom here)

Memory Management in MySQL and Drizzle: not magic setting of buffer variables, but memory allocation and management inside the server, a bunch of malloc() discussion and hopefully some interesting numbers.

Peter said me that previous results http://www.mysqlperformanceblog.com/2008/12/18/xtradb-benchmarks-15x-gain/ are too marketing, and we should show other results also.

Here is the run for CPU Bound,or it would be more correctly to say in-cache benchmark, because there is a lot of CPU remains idle. This run is exactly the same as Disk Bound but with innodb_buffer_pool_size=8G which is more than enough to fit all data in memory.

The XtraDB is showing very modest gain of about 2.5% in this case which can be attributed to measurement error too.

The story becomes more …

Here's another ode to a small but fundamental aspect of Oracle, following the same theme as The Humble IF Statement. This time, let's look at the COUNT( ) function. I think when you look at it the right way, it opens up the whole story about database performance.What's the first thing you do when poking around an unfamiliar system? I'll bet it involves SELECT COUNT(*) queries in one way or

I just got word the Schedule for the MySQL Conference 2009 is now available!

In my previous post, and the one before that I already wrote about my approved proposals. I promised I would post more details on my sessions later on. Well, it's right here:

http://en.oreilly.com/mysql2009/public/schedule/speaker/198

While you're at it, check out the list of speakers. I think it is a pretty good line-up, and I am looking forward to …

Department expands its biometrics-based border database, which requires all 10 fingerprints, a digital photograph, home address, and other information that privacy advocates have criticized as too intrusive.