The Backend Engineering Show with Hussein Nasser cover image

How Discord Stores Trillions of Messages - A deep dive

The Backend Engineering Show with Hussein Nasser

00:00

How to Insert a Row in a Clustered MySQL Database

In unclustered Indexes the leaf pages will not have actual data. They will have simple pointers to the actual table I can post because it's the tuple ID which is a page ID and the index of the tuptuple. In clustered indexes you need to order them so that they are inserted in the correct order. You don't have to flush the page to disk, right? But eventually you will have to and b plus three if you flush the page. It's an update It's an actual Physical update to the OS. He said hey this page go and update it and what does that mean? Well the page is a fixed size It lives on desk on a file and

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