Adventures in MySQL
summary
Modern MySQL adds concrete tools: a native JSON column stored binary with JSON_EXTRACT and ->/->> operators, spatial types with spherical functions (5.7) for meter-accurate distances, and GTID replication for resilient master switching. EXPLAIN supports writes and OUTPUT FORMAT=JSON for deeper plans; MySQL 8 adds user roles and generated columns (virtual vs stored) to index JSON values. Operational features include invisible indexes, descending indexes (half the query time in a 75k-row test), offline mode and the safe "i am a dummy" CLI flag.
AI-written summary · about
chapters (34)
- 0:00Introduction
- 1:53About TEDx
- 2:28The secret
- 3:56Features
- 4:37No SQL
- 4:49Binary format
- 5:32Downsides
- 5:55New Ideas
- 6:51Data Routes
- 8:29Nested Objects
- 9:57Special Data
- 11:43Geometry
- 12:29Collections
- 13:07Geo Spatial Features
- 16:18Replication
- 17:11GT IDs
- 17:46G Tidy
- 20:35JSON format
- 21:10JSON operator
- 21:23JSON extraction
- 21:40Basic select
- 21:50CRUD cost
- 22:02User roles
- 24:00Generated columns
- 26:14Virtual columns
- 28:09Still generated columns
- 29:07Offline mode
- 30:54Indexes
- 31:15Invisible Indexes
- 33:02Visible Indexes
- 36:11Snares
- 36:57I am a dummy
- 38:40Final thoughts
- 39:53Questions
