Pages

▼

Thursday, December 24, 2009

Holiday gift - A deep look at MySQL 5.5 partitioning enhancements


A deep look at MySQL 5.5 partitioning enhancements

Half a day into my vacation, I managed to finish an article on a topic that has been intriguing me for a while.
Since several colleagues were baffled by the semantics of the new enhancements of MySQL 5.5 partitions, after talking at length with the creator and the author of the manual pages, I produced this article: A deep look at MySQL 5.5 partitioning enhancements.
Happy holidays!

UPDATE This matter was more tricky than it appeared at first sight. As Bug#49861 shows, several MySQL engineers were initially fooled by the multiple column partitions. Also I wrote something wrong in the article, and I updated the text to explain more accurately the behavior of the partitioning engine.
at

1 comment:

  1. UnknownDecember 27, 2009 at 2:10:00 PM GMT+1

    It's not true you may use partitions only for numeric values/columns in 5.1! - Don't forget about KEY PARTITIONING! :-)

    Rgds,
    -Dimitri

    ReplyDelete

Note: Only a member of this blog may post a comment.