Making the most out of MySQL

on YouTube ↗39m

" summary

Covers concrete MySQL 5.7 changes: online DDL can be in-place or copy, converting TEXT to JSON triggers a slow copy so run JSON_VALID first, and JSON fields are indexable only via generated columns; measured run: creating stored columns for ~1,200 Twitter rows takes ~2 seconds and a virtual column measured 151 ms locally, indexing location helps fast lookups, and performance_schema (enable briefly) surfaces top slow queries, temp-table creators, IO and connection spikes for diagnosis.

AI-written summary · about

" chapters (11)

1. 0:00Intro
2. 1:36What to Expect
3. 2:28Online DDL Changes
4. 4:41SOL modes comparison
5. 7:44Users Table
6. 10:28Translation
7. 14:33SQL execution
8. 16:23Virtual Columns
9. 23:05Converting TEXT to JSON
10. 26:18Creating a generated columns in JSON fields
11. 31:26What I can do with it?

" related talks

• 40mMaking the most out of MySQLGabriela D'Avila Ferrara · Dutch PHP Conference 2018
• 44mAdventures in MySQLLiam Wiltshire · Dutch PHP Conference 2017
• 58mMySQL 5 7 + JSONMorgan Tocker · PHP UK Conference 2016
• 24mGoing through era of IoT with MySQL 5.7Ricky Setyawan · FOSSASIA Summit 2016
• 47mMy SQL 5 6 - Online Operations and Improved DiagnosticsMorgan Tocker · PHP UK Conference 2014
• 01h 30mMySQL Indexes, Histograms, Locking Options, and Other Ways to Speed Up Your QueriesDave Stokes · All Things Open 2020
• 46mSupercharge Your SQL with Indexes: a Practical IntroductionAlberto Schiabel · DevDays Europe 2024
• 29mHow De-normalizing Your Data with JSON Can Boost Query PerformanceDavid Stokes · PHP UK Conference 2019