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

Remember Everything You Learn from Podcasts

Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.
App store bannerPlay store banner