Partitioning Under the Hood in MySQL 5.5

Mattias Jonsson (Sun Microsystems), Mikael Ronstrom (MySQL)
Average rating: **...
(2.71, 7 ratings)

We will primarily go through the implementation and how partitioning works inside MySQL server, rather than talk about how to use partitioning.

We will go through how partitioning works and explain how COLUMNS partitioning in 5.5 is different from the partitioning types in 5.1, and also talk about truncate partition and MyISAM key caches can now be used per partition.

We will explain why the current implementation have some challenges with tables with many partitions (too much overhead since it need to open and lock each and every partition before the optimization stage, where the pruning happens). And what is being done to solve it.

We will give some peeks at what we are developing right now:

  • Decrease the overhead of many partitions by using the new Metadata locking to allow pruning before locking (to also prune away open and lock operations).
  • Exchange partition with table, swap place of a partition and a table.
  • Explicit pruning, only use the partitions specified in the FROM clause
  • Parallel ALTER TABLE where the partitions are altered in parallel, thus higher utilization of multi CPU systems.

At the end of the session we will also have questions and answers where the audience can get technical answers, and have the chance of getting their voices heard directly by the developers.
Maybe by discussing new feature requests that we should focus on next (Global index, exchange partition with table, default list partition, explicit pruning, parallel operations such as alter/partition scan/index scan/insert/update/delete) or proposals from the audience.

So take the opportunity to make your voice heard, while getting deeper insight into the server!

Mattias Jonsson

Sun Microsystems

MSc in Electrical Engineering, Developer of MySQL Partitioning since 2007.

Photo of Mikael Ronstrom

Mikael Ronstrom

MySQL

Ph.D in Technical Information Systems.
Founder of MySQL Cluster technology.
Developer of MySQL Partitioning.
Currently working on MySQL Architecture.

  • Oracle
  • Monty Program
  • Calpont
  • Facebook
  • Gear6
  • Infobright, Inc
  • JasperSoft
  • Joyent
  • Kickfire
  • NorthScale, Inc.
  • Percona
  • Schooner Information Technology
  • Solid Quality Mentors (SolidQ)
  • Intel
  • Pentaho
  • Linux Pro Magazine

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at yromaine@oreilly.com

Download the O'Reilly MySQL Conference & Expo Sponsor/ Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

O'Reilly MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference newsletter (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference contacts.