By Solomon Chang
Table partitioning is a data organization scheme in which table data is divided across multiple files according to values in one or more table columns. Each data partition is stored separately and may even exist on separate block devices in the same server.
Many databases implementations generally don't give the administrator much control over which records are stored on a specific partition, but a user-defined partition in MySQL (5.1.6 and later) will let you specify exactly which partition a record is stored by default, based on a specific value.
In this talk, Solomon will cover:
- In which situations Table Partitioning would increase performance
- How to set up a basic Partition on a single server
- Organization schemes: hash vs. range
- Managing Table Partitions
- Determining Partition usage
Solomon Chang is a MySQL-certified DBA, and currently a Senior SysAdmin at Sosbuzz Inc., a social marketplace centered around helping people. SOSBUZZ connects buyers, sellers and causes for the benefit of all.
Apache
