Boosting MySQL Performance
summary
Shows concrete MySQL specifics: exact storage sizes for INT family storage bytes, when VARCHAR temporary to MEMORY conversion inflates RAM, blob/text limits (65KB, 16MB), and charset pitfalls like utf8mb4 vs utf8mb3. Gives actionable defaults (unsigned INT primary keys, index both sides of relations), describes using generated columns indexed (MySQL 5.7/8.0) and warns about unnecessary engines or tuning. Useful if you want precise rules and gotchas, not high-level theory.
AI-written summary · about
chapters (11)
- 0:00Start
- 23:20BINARY and CHAR: Fixed length
- 28:17VARBINARY and VARCHAR
- 33:15The Blob family
- 39:47The Date and Time Family
- 46:18Default to an Integer for your PK
- 49:35Index the two sides of relations
- 51:14N-M relation: Junction tables
- 53:32Don't operate on fields
- 54:02Polish your maths: Algebra
- 55:19The old switcheroo...
related talks
34mMySQL and InnoDB Performance for the Rest of Us
26mUnderstanding MySQL Concepts
47mMySQL Indexing Best Practices
56mOptimization Techniques in MySQL
33m7 or so deadly MySQL performance sins
53mIntroduction to MySQL Performance Tuning - workshop 1hr
46mSupercharge Your SQL with Indexes: a Practical Introduction
28mMysql Optimizer Features in 5.7 and 8.0