My SQL 5 6 - Online Operations and Improved Diagnostics

on YouTube ↗47m

" summary

MySQL 5.6 introduces online DDL so many ALTERs (creating/dropping indexes, some column changes) run without blocking reads/writes and support LOCK=NONE / ALGORITHM=INPLACE to refuse blocking operations. It adds buffer-pool dump/restore, export/import InnoDB tablespaces, nonblocking logfile resizing, GTIDs and per-schema multithreaded replication. Diagnostics add EXPLAIN FORMAT=JSON, optimizer_trace, and a performance_schema on by default with sub-5% overhead; PS queries report index usage, slow-query aggregates, and real working-set measurements that cut CI times (example 40→14 minutes).

AI-written summary · about

" chapters (6)

1. 0:00Introduction and development
2. 2:16MySQL development model
3. 6:22Operational enhancements
4. 17:45Diagnostics and performance
5. 37:49Information schema and tuning
6. 40:36Future outlook and Q&A

" related talks

• 39mMaking the most out of MySQLGabriela D'Ávila · Laracon EU 2016
• 40mMaking the most out of MySQLGabriela D'Avila Ferrara · Dutch PHP Conference 2018
• 24mGoing through era of IoT with MySQL 5.7Ricky Setyawan · FOSSASIA Summit 2016
• 43mState of the DolphinKaren Padir · MySQL Conference & Expo 2009
• 28mMysql Optimizer Features in 5.7 and 8.0Sree Harsha Ramanavarapu · FOSSASIA Summit 2017
• 53mMySQL DevOpsV. Fedorkov, A. Raspopina · DevOps Pro Moscow 2019
• 37m8.0 New FeaturesDave Stokes · Open Source 101 at Home 2020
• 22mMySQL Replication: Latest DevelopmentsSujatha Sivakumar · FOSSASIA Summit 2017