Session
High Performance Data Warehousing with MySQL: Tricks and Tips from the Field
Brian Miezejewski, Principal Consultant, MySQL inc.
Track: Data Warehousing and Business Intelligence
Date: Thursday, April 26
Time: 2:30pm
- 3:15pm
Location: Ballroom C
This presentation will cover solutions to problems encountered by Brian Miezejewski during his last ten years of large scale data warehouse implementations. Solutions specific to MySQL will include:
- Using Partitioning and Merge tables for Data Warehousing
- Using the insert on duplicate update statement to speed up aggregations
- Emulating star schema optimization in MySQL
- Using Merge tables or partitioning and deltas to solve the load/purge problem
- Backup strategies for massive data warehouses
- Optimizing MyISAM for data warehousing
- What are the critical configuration options for data warehousing
- Monitoring a MySQL data warehouse and what to look for
- When InnoDB is better for a data warehouse than MyISAM
- New storage engines optimized for data warehousing