January 2019
Intermediate to advanced
286 pages
7h 41m
English
Content preview from Advanced MySQL 8
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
What this book covers
Chapter 1, Introduction, walks through the changes that took place in MySQL 8, compared to the previous versions. We also study what makes MySQL 8 a next-generation database, and also cover its architectural design.
Chapter 2, MySQL 8 – New Features, not only covers all the new, exciting features of MySQL 8.0, but also reviews the deprecated and removed features as well.
Chapter 3, Indexing Your Data for High Performance, explains how to optimize MySQL performance by using indexes and Query Execution plans with examples. Optimization involves a good understanding of MySQL Optimizer, index strategies, and a solid knowledge of how indexes and queries work together.
Chapter 4, Advanced Data Techniques for Large Queries ...