Tech debt is a great topic for learning. But it is hard to discuss in public because it becomes marketing fodder for the competition.
MySQL has tech debt just like all other mature DBMS, and it is a great product despite that.
Conversation
Replying to
As a Postgres person, I would much rather hear about MySQL's notable strengths. Weaknesses *can* be interesting when they hint at an interesting underlying trade-off, but not otherwise. The fact that the MySQL optimizer is subpar is well known, and of no interest to me.
4
3
16
Replying to
For me: OLTP, InnoDB, replication, community and the storage engine API.
1
2
Replying to
I was the primary author of on ON CONFLICT DO UPDATE in Postgres. That design owes plenty to MySQL. Asserting that you have nothing to learn from so-called "out-group" always seems like self-indulgence to me.