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:
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!
MSc in Electrical Engineering, Developer of MySQL Partitioning since 2007.
Ph.D in Technical Information Systems. Founder of MySQL Cluster technology. Developer of MySQL Partitioning. Currently working on MySQL Architecture.
For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at firstname.lastname@example.org
For media-related inquiries, contact Maureen Jennings at email@example.com
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).
View a complete list of O'Reilly MySQL Conference contacts.