First Principles: Inside MySQL HeatWave Lakehouse on OCI

Explore cloud innovations powering MySQL HeatWave Lakehouse in this 22-minute video from Oracle. Dive into the massively partitioned architecture, transaction processing capabilities, and the ability to process and query half a petabyte of data in object storage with record performance and cost savings. Learn about adaptive data sampling, smart scheduling, and how MySQL Autopilot enhances query performance. Discover how the system handles query plan outliers and achieves the same performance for queries on object stores as traditional databases. Gain insights into schema inference, adaptive data flow, and the overall architecture that enables MySQL HeatWave Lakehouse to deliver high-performance data processing at scale.

Introduction
MySQL HeatWave Overview
Massively Partitioned Architecture
Transaction Processing in MySQL HeatWave
MySQL HeatWave Lakehouse
Loading Half a Petabyte in Lakehouse
Schema Inference by MySQL Autopilot
Adaptive Data Sampling
Adaptive Data Flow
Same Performance for Query on Object Store
MySQL Autopilot Powers Query Performance
Smart Scheduler's Compute and Communication Overlap
Handling Query Plan Outliers
Takeaways