Yet Another Partitioning Article…
The article that Peter Gulutzan and I wrote a couple of weeks ago is now online:
MySQL 5.1 New Features: MySQL Partitions
Here’s a brief outline:
- A Grammar Description That’s Expressed Differently From The Manual
- Partitioning Types
- Creating Partitioned Tables
- Partitioning Keys, Primary Keys, and Unique Keys
- Altering Partitioning Tables
- Performance Considerations
- Advantages of Partitioning
- Partition Pruning
- Maintenance of Big Tables
- Doing It With Dates And Times
- Some Simple Speed Tests
- Comparison With Other Database Systems
- Examples:
- Creating a Table With 500 Partitions
- Patching Maintenance Mistakes
- Searching One Partition At A Time
- References
Since this is a rather long article (ca. 30 pages), I’ve decided to make it even more worthwhile reading by introducing an exciting Guess The Author Contest, which I’m sure will provide countless hours of enjoyment for the entire family: The first person to guess correctly which of us (Jon Stephens or Peter Gulutzan) wrote which sections of the article will receive a modest assortment of quality Australian-made Freddo chocolates from me. Send guesses to me in an email or post them in a comment to this article. Deadline: Midnight, Sunday 27 August 2006 GMT +10.00. Employees/Contractors of MySQL AB/Inc/GmbH/KK and their families are not eligible to participate in this contest. Neither Peter Gulutzan nor MySQL AB/Inc/GmbH/KK have any involvement whatsoever in this contest, so don’t bother asking them about it, please. Winner is responsible for taxes and customs duties. Not responsible for mail that is late, stolen, misdirected, or allowed to stay out in the sun for too long. Prohibited where void. Cash value of prize offering is approximately AUD10.00. I’ll post the name and URL (if desired) of the winner on this site on or before Monday 28 August 2006. Or - if there’s no winner by then - I’ll eat the chocolates myself, and tell you how nice they were.