Germany: +49 89 143 01280
France: +33 1 57 60 83 57
Italy: +39 02 249 59 120
UK: +44 207 553 8447
Partitioning can greatly increase the performance of your queries, especially when doing full table scans over large tables. Partitioning is also an excellent way to manage very large tables (100GB or more). It’s one of the best ways to build higher performance into your product’s embedded or bundled MySQL, and particularly for hardware-constrained appliances and devices.
This presentation shows you how to create a proper partitioning layout and reviews the different types of partitioning. It also reviews real world scenarios in which partitioning does (and does not) make sense. The presentation covers the following topics.