Work
A collection of things I’ve done, not already hosted on my personal site here.
Courses
Videos
- I loaded 100,000,000 rows into MySQL
- Auto-generate MySQL schema diagrams with a custom Figma plugin
- Increase speed and durability with MySQL replication
- Watch me 100x a SQL query
- Creating a 100 gigabyte index on 1 billion+ rows
- Bad Schema? Improve it with this tool.
- How Vitess powers your PlanetScale database
- Speed up your MySQL database with the buffer pool
- Slow database? Replicas are here to help.
- Working with strings in MySQL
- Learn Vitess - Introduction (part 1)
- Learn Vitess - Build and Run Vitess (part 2)
- Learn Vitess - Components of a Vitess cluster (part3)
- Learn Vitess - Vertical Sharding (part4)
- Learn Vitess - Horizontal Sharding (part 5)
- Learn Vitess - Multiple Machines (part 6)
- Learn Vitess - Sharding on Multiple Machines (part 7)
- Learn Vitess - Vitess on Kubernetes (part 8)
- Learn Vitess - Vitess at PlanetScale (part 9)
- Case Study: Interview with Steven Tey (Dub)
Blogs
- Identifying and profiling problematic MySQL queries
- Profiling memory usage in MySQL
- The MySQL adaptive hash index
- Dealing with large tables