About this talk
This talk covers the significant enhancements introduced in MySQL 8, focusing on its new transactional data dictionary that decouples the database from the file system. The speaker discusses the implications of having millions of tables in a database schema, alongside improved support for JSON data types and the addition of a NoSQL JSON document store, streamlining code development. Attendees will also learn about new features such as resource groups, common table expressions (CTEs), windowing functions for analytics, roles, and histograms, all designed to optimize the MySQL experience for developers. This session is essential for anyone looking to fully leverage the capabilities of MySQL 8.