Overview
Explore strategies for managing billions of records in MySQL through this conference talk by Lukas Vileikis at Conf42 Platform Engineering 2024. Dive into performance optimization techniques, including MySQL configuration tuning, storage engine selection, and schema optimization. Learn how to efficiently handle large datasets, implement advanced features, and develop effective backup strategies for big data. Gain insights into useful tools and best practices for maintaining high-performance MySQL databases at scale. Benefit from practical lessons learned and expert advice on tackling the challenges of massive data management in MySQL environments.
Syllabus
intro
understanding full text search queries
identifying and fixing query bugs
speaker introduction and background
agenda and performance basics
optimizing mysql configuration
choosing and optimizing storage engines
schema optimization principles
handling large datasets efficiently
advanced features and techniques
backup strategies for big data
tools and best practices
conclusion and feedback
Taught by
Conf42