A comprehensive talk about MySQL 5.7 features and improvements, focusing on online DDL changes, strict modes, generated columns, and performance monitoring. The speaker explains how these features can improve data consistency and application performance while highlighting important migration considerations from MySQL 5.5/5.6 to 5.7.

A comprehensive talk about database indexing fundamentals and best practices, focusing on MySQL/MariaDB. The speaker explains how B-tree indexes work, demonstrates common indexing pitfalls, and shows how to properly design indexes based on query patterns. Through live coding examples, he illustrates how to analyze query execution plans and optimize index usage for better performance.

This talk focuses on MySQL 8 features and best practices for developers. The speaker, Gabi, discusses the latest improvements in MySQL 8 including new default configurations, performance enhancements with the CATS algorithm, invisible indexes, window functions, and common table expressions (CTEs). The presentation emphasizes practical examples using sample databases and demonstrates how these features can improve query performance and code readability.