The Backend Engineering Show with Hussein Nasser cover image

How Shopify’s engineering improved writes by 50% with ULID | The Backend Engineering Show

The Backend Engineering Show with Hussein Nasser

00:00

Clustered Indexes - Clustering MySQL Databases

As the tables start to grow, as you start inserting these random goods, you will find yourself pointing to random pages. There is no order of the way you're inserting these things, they are not ordered at all. It's exactly identical to inserting random integer values, identical. So we get a get this page, you insert that random GUID, and then you insert another random UUIDs, and guess what? It's not on the same page,. You end up filling the buffer pool, which is the memory with pages that almost receive just one or two rights. And let's just hope that this page will receive another right, which will never be given because everything is random.

Transcript
Play full episode

The AI-powered Podcast Player

Save insights by tapping your headphones, chat with episodes, discover the best highlights - and more!
App store bannerPlay store banner
Get the app