I have moved on to InnoDB: Innovative Technologies for Performance and Data Protection by Ken Jacobs at MySQL Conference and Expo.

With a brief history lesson of inception from 1994, inclusion in MySQL in 2000 and acquired by Oracle in 2005. Most of the work was done by one person. InnoDB is based on sound database computer science using Gray & Reuters definitive text on database design.

Some key points in Ken’s discussion.

• Adaptive Hash indexing for frequent queries on keys.
• In plugin Adaptive Hash is configurable
• Insert Buffering - Deferring secondary index writes
• Fast Index Create - doesn’t requires all indexes to be rebuilt
• Table Compression - Changing the page size

The InnoDB plugin available in 5.1 …

The video for the 2009 MySQL Conference presentation:

Starring Sakila: Data Warehousing Explained, Illustrated, and Subtitled
Roland Bouman (XCDSQL Solutions / Strukton Rail), Matt Casters (Pentaho Corp.)

Description

(no slides available at the time of the posting).

I am now sitting in on MySQL and Search at Craigslist by Jeremy Zawodny at MySQL Users Conference

Some of the technical difficulties that required addressing.

• High churn rate
• half life can be very short
• Growth
• Traffic
• Need to archive postings, e.g. 100M but be searchable
• Internationalization and UTF-8

Some of the Craigslist Goals

• Open Source
• Easy and approachable
• be green with energy use

A review of the Internals server configuration

• Load Balancer (perlbal like)
• Read Proxy Array (perl+memcached)
• Web Read Array (apache 1.3 + mod_perl)
• Object Cache (Perl + memcached)
• Read DB Cluster …

the "MySQL Drizzle Project". Nor is it "shepparded by MySQL". Sorry, Karen, but in the future, MySQL may play more of a role in Drizzle, but currently, it doesn't. And it doesn't by choice.

Forget to say, I've also tested PostgreSQL 8.3.7 during the last benchmark serie with dbSTRESS!

A big surprise - if two years ago on the same workload PostgreSQL was two times faster (see: http://dimitrik.free.fr/db_STRESS_BMK_Part2_ZFS.html ), now it's MySQL 5.4 outperforming PostgreSQL!

• Read-Only workload: MySQL is near two times faster now! (13.500 TPS vs ~7.000 TPS for PostgreSQL)
  
  
• Read+Write workload: MySQL performs as well or better (7.000-8.000 TPS vs 6.000-7.000 TPS for PostgreSQL)

For more details: http://dimitrik.free.fr/db_STRESS_MySQL_540_and_others_Apr2009.html#note_5443  

This blog entry is a bit of a written confession from the Sun Drizzle team. It tells the story of the last few weeks, and how we didn't "Do the Right Thing". It's a tale which ends, hopefully, in our redemption through acknowledgement of what happened, a written commitment that it won't happen again, and a bit of a manual on how to have our actions match our team values.

What Happened?

A few weeks ago, we received an email from Allan Packer, who works in the Performance Engineering group at Sun. The email contained the results of some benchmarks that Allan had performed comparing Drizzle and a version of MySQL 5.1.

The results for Drizzle weren't flattering. In fact, at lower concurrencies, the results were downright embarrassing, with some runs showing 5.1 outpacing Drizzle in throughput by 100%.

"How could this be?" we askedcursed. …

As you may already know, today Sun announces MySQL 5.4. It's a big step forward and I hope you'll have enough time today to follow all blog posts and other interesting related publications! :-)

I leave my colleagues to tell you what is new in 5.4 and what will come with next releases! (start with Mikael's and Allan's blogs). As well you will not have a whole story if you miss Tim's, Neel's, Richard's, Vince's, David's and many other valuable blogs posts!

From my part I want to present you some "unofficial" dbSTRESS …

Here is a semi-liveblog from the opening keynote of the 2009 MySQL Conference & Expo on April 21st in Santa Clara, California. Karen Padir presents “State of the Dolphin”.

The room is big, with 2 screens on each side of the central stage. It seems to be completely filling up, but I got a good spot on the second row in the front. Directly around me I see Dups, Sheeri, Giuseppe, Kai, Mark Callaghan and many other faces I know, even they don’t necessarily know me

Opening music, fancy animations. Quotes from satisfied customers, combined with tribal-style music and statistics.

Colin Charles kicks off. Good morning, welcome. learn a lot, provide feedback. Thanking sponsors in the first minute..

…

Today Sun announced the availability of MySQL 5.4, which contains a number of performance and scalability enhancements to the base MySQL 5.1 code. For the full run down on all of the enhancements, and the resulting scalability improvements, check out these blogs from Mikael Ronstrom and Allan Packer. You can also read Neelakanth Nadgir's blog, where he describes some performance fixes that were tried but rejected. As he says, sometimes you can learn a lot from the things that don't work out!

This release contains a range of improvements, both from the community (especially Google) and from work that has taken place in the MySQL performance team. As you can guess, we aren't stopping here, and there are a number of additional enhancements in the pipeline for …

After 4hrs train / airport, 11hrs flight and another 2hrs commuting time on Sunday 19th I made it from London to Santa Clara. Practically exhausted I checked in, targeting a comfy hotel bed only to end up on a 1.5 hrs drive to Monterey with three good friends / colleagues! It was a great start [...]