UUIDs are Bad for Performance in MySQL - Does Postgres Win? Let us Discuss

The Backend Engineering Show with Hussein Nasser

Episode | Podcast

Date: Thu, 04 Feb 2021 19:47:09 GMT

<p>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 &nbsp;&nbsp;&nbsp;</p> <p><br /></p> <p>https://www.percona.com/blog/2019/11/22/uuids-are-popular-but-bad-for-performance-lets-discuss/</p>