logo
episode-header-image
May 2020
18m 55s

How Does Database Store Tables on Disk? ...

Hussein Nasser
About this episode

in this video I explain how database systems store their data on Disk both f from SSD (solid-state drives) and HDD (HarD disk drive).   There are many factors that go into that discussion so I tried to cover the high level here.   Reseources https://www.extremetech.com/extreme/210492-extremetech-explains-how-do-ssds-work https://www.percona.com/blog/2019/12/18/give-love-to-your-ssds-reduce-innodb_io_capacity_max/

Up next
Apr 15
My new book - Root cause, Stories from two decades of backend bugs
I wrote a new book that has been in the works for years. It is called Root Cause, and it is for those who enjoy the art of backend engineering.Early in my career, 20 years ago, I built backend and database applications without fully grasping their inner mechanics. Performance iss ... Show More
9m 48s
Jan 2026
5 Backend Design Patterns for Managing Threads and Sockets
In this video I introduce 5 different design patterns for building backend applications. Each mode explains how a socket listener is established, a connections are established and how threads and connections are managed to read, write and process requests. 
46m 9s
Dec 2025
Page Tables
Page tables provide the mapping between virtual memory and physical memory for each process. This means it needs to be as efficient and as fast as possible. I explore the inner workings of page tables in this episode.0:00 Intro2:00 Virtual Memory ⁃ ⁃ 8:00 MMU10:00 Page Tables ⁃ ⁃ ... Show More
46m 39s
Recommended Episodes
Aug 2020
Hard Disk Drives vs Solid State Drives
When it comes to long-term data storage on computers, there are two main camps. In this episode, we learn how hard disk drives are different from solid state drives. Learn more about your ad-choices at https://www.iheartpodcastnetwork.comSee omnystudio.com/listener for privacy in ... Show More
49m 23s
Jun 2024
Seagate Helps Tame the Cloud’s Exabyte Demand
Seagate’s relentless hard-disk-drive technology innovation has expanded mass-capacity storage solutions over the past several years. Jason Feist, senior vice president of products and markets, sits down with Woo Jin Ho, Bloomberg Intelligence hardware and networking analyst, in t ... Show More
39m 17s
Mar 2024
Hard Disk Drive | Can't Sleep? Learn How Computers Store Data
In this episode, Benjamin reads about Hard Disk Drive — the history, key details, and the parts most people never think to look up. It's a relaxed reading designed to give your mind something steady to follow as you wind down. No whispering, no sudden changes, just a consistent p ... Show More
47m 47s
Oct 2023
Things Legacy Storage Made You Worry About (That You Shouldn't Have To)
Ever wondered about the origin of certain storage or IT administrative tasks? Because of legacy architectures, IT practitioners have been forced to worry about and repeatedly carry out certain administrative tasks because, well, "that's how it's always been with this product." Jo ... Show More
54m 56s
Sep 2023
Unplugged Volume 14: Metadata - the Secret Sauce, Events and Disk Retirement webinar recap
The intrepid Unplugged crew returns for an exciting Volume 14 where Andrew Miller, JD Wallace and I take on another of Pure's architectural decisions - this time we dig deep into the use of Metadata in the software stack. The extensive use of Metadata enables FlashArray to delive ... Show More
48m 50s
Feb 2020
Data Modeling That Evolves With Your Business Using Data Vault
<div class="wp-block-jetpack-markdown"><h2>Summary</h2> <p>Designing the structure for your data warehouse is a complex and challenging process. As businesses deal with a growing number of sources and types of information that they need to integrate, they need a data modeling st ... Show More
1h 6m
Apr 2024
Des cartes SD bientôt de 4 To de stockage ?
<p>C’est dans un communiqué diffusé mi-avril que Western Digital, le spécialiste des cartes SD et des disques durs, a évoqué l'arrivée prochaine de cartes SD de 4 To. Jusqu’à présent, seules des cartes de 1 To étaient disponibles dans la gamme SanDisk Extreme Pro. Mais en quadrup ... Show More
1m 48s