| Speakers | |
|---|---|
|
Giuseppe Maxia |
| Schedule | |
| Day | Sunday |
| Room | AW1.126 |
| Start time | 15:00 |
| End time | 16:00 |
| Duration | 01:00 |
| Info | |
| Event type | Podium |
| Track | MySQL |
| Language | English |
Boost performance with MySQL 5.1 partitions
MySQL 5.1 introduces partitioning – a very useful feature for databases with large tables. This session explains the benefits of partitioning and shows in practice how to take advantage of its features.
Topics include:
- Benefits and limits of partitioning
- Understanding the partitioning types (RANGE, LIST, HASH and KEY)
- Partitioning pruning and EXPLAIN additions
- Benchmarking partitions
- How to partition by dates
- Partitioning with MyISAM tables
- Partitioning with InnoDB tables
- Partitioning with Archive tables
- Use cases
- Partition maintenance:
- converting partitioned tables to normal ones;
- adding and dropping partitions
- reorganizing partitions
- checking and repairing partitions