u/spaghetti_toasterin r/databasedevelopment • Recommends
On “What is Memory-Mapping really doing in the context of databases?”
Yes, see also: link to this video
0:00 / 0:00
Are You Sure You Want to Use MMAP in Your Database Management System?
CIDR DB
1.8K subscribers • 1 video on Hallway
- Recommended by 2 people: 2 in engineering communities.
- Presented by Andrew Crotty, Carnegie Mellon University
- An opinion. It argues one side of a question engineers disagree on.
Advanced. Deep dive for people who know the field.
23K views4 years ago2 recommendations
Databases and dataSystems programmingDatabase internalsOperating systemsPerformance and optimization
Andrew Crotty presents a paper explaining why memory-mapped file I/O (mmap) is problematic for modern database management systems.
Paper: cidrdb.org/cidr2022/papers/p13-crotty.pdf Authors: Andrew Crotty (Carnegie Mellon University)*; Viktor Leis (Friedrich-Alexander-Universität Erlangen-Nürnberg); Andrew Pavlo (Carnegie Mellon University)Why it's here
2 people recommend thisWhat people say. Recommended as the definitive explanation and paper presentation on why mmap is unsuitable for database storage engines.
u/WideSense8018in r/C_Programming • Recommends
On “Efficient File IO in C?”
In this video [video they mention why mmap is bad for DBMS. Also they wrote a paper explaining it.
u/avinasshin r/databasedevelopment • Mentions
On “Are You Sure You Want to Use MMAP in Your Database Management System?”
paper link: https://db.cs.cmu.edu/papers/2022/cidr2022-p13-crotty.pdf
video: link to this video