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.
Overview
Syllabus
Introduction
Safe Harbor Agreement
Database Revolution
Resources
MySQL 6 7
Data Dictionary
System Tables
Millions of Tables
Sub queries
Windowing functions
Partitioning data
Using tes
Using recursive table expressions
The optimizer
No wait
Another example
Histograms
CompromiseAware Transaction Scheduling
Roles
Character Sets
Why is this important
Emojis
Invisible Indexes
Set persist
Resource groups
GIS
PostGIS
JSON
JSON Pretty
JSON Array aggregation
JSON Storage
JSON Table
Plugins
Docker images
Official MySQL Guide
Active Master Replication
JSON Document
Feedback
XDev API
Dog
Taught by
PHP UK Conference
