Getting the Best MySQL Performance in Your Products: Part IV, Partitioning

We're adding Partitioning to our extremely popular "Getting the Best MySQL Performance in Your Products" webinar series. 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 (100G 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.

The speaker for Part IV will be MySQL technical expert and principal sales consultant, Tony Holmes. Tony will show you how to create a proper partitioning layout and will discuss different partitioning types. He will also show real world scenarios where partitioning does (and does not) make sense.

Tony will review the following topics:

• Partitioning 101
• Types of partitioning in MySQL
• Managing Partitions
• Partitions and Indexes
• Short Term Rolling Data
• Long Term Rolling Data
• Optimize, Analyze, etc. by Partition
• New in MySQL 5.5 and 5.6

Don't worry if you've missed the earlier sessions in our series! You can watch them on-demand:

Part I, Performance Fundamentals; Part II, Beyond the Basics; Part III, Query Tuning

WHO:

WHERE: