🚨 PERFORMANCE ALERT: MySQL 8.0+ made me lose 8 seconds of my life... and that's just the beginning!
Imagine: Your brand new MacBook Pro M3 Pro struggling on a simple migration of 12 tables. 😱
That's EXACTLY what happened to me last week.
And the worst part? It wasn't the first time MySQL 8.0+ disappointed me.
🔍 The story begins this summer...
On my LFGitignore project (a little Django side project), the performance was so catastrophic that I had to implement Redis as an emergency measure. Result? I migrated to MariaDB after seeing MySQL 8.4's "performance". 📉
💥 But the drama doesn't stop there!
Last week, I'm rewriting a Django project in Ruby on Rails (yes, I know, what an idea 😅).
Confident, I run: rails new my_awesome_project -d mysql
I set up my tables with ActiveRecord, everything's ready...
rails db:migrate
⏱️ 8 SECONDS to create 12 tables. EIGHT. SECONDS.
On an M3 Pro! 🤯
🎯 The plot twist?
I switch to PostgreSQL (it was about time anyway).
Same command: rails db:migrate
Result: INSTANT ⚡
✅ The moral of this story?
I could have wasted my time disabling the bin log, optimizing parameters, figuring out why MySQL is so slow...