UUIDs are Bad for Performance in MySQL - Does Postgres Win? Let us Discuss
from The Backend Engineering Show with Hussein Nasser Hosted by Hussein Nasser
MySQL is clustered by default on the primary key which means inserts have to be ordered, let us discuss why UUID (random in nature) has bad performance in MySQL and whether postgres wins here. We will also explain why Sequential Writes are Faster than Random in MYSQL and https://www.percona.com/blog/2019/11/22/uuids-are-popular-but-bad-for-performance-lets-discuss/
Embed this episode
No transcript yet.
Frequently asked questions
How long is this episode of The Backend Engineering Show with Hussein Nasser?
This episode is 21 minutes long.
When was this The Backend Engineering Show with Hussein Nasser episode published?
This episode was published on February 4, 2021.
Can I download this The Backend Engineering Show with Hussein Nasser episode?
Yes. Use the download control on the episode player to save the publisher-provided media file.