Explore the major redesign of MySQL 8 in this 34-minute conference talk from PHP UK Conference 2018. Discover the new features including a true data dictionary, support for millions of tables within a schema, windowing functions, common table expressions, multi-plane character support for emojis, user roles, enhanced JSON functions, and significant optimizer improvements. Learn about the improved 'out of the box' user experience and uncover the mystery behind the absence of MySQL 6 and 7. Dive into topics such as system tables, sub-queries, partitioning data, recursive table expressions, histograms, aware transaction scheduling, character sets, invisible indexes, resource groups, GIS improvements, JSON enhancements, Docker images, and active master replication. Gain insights into the future of the most popular database on the web and understand how these changes will impact web development with PHP.