DeepRead
Cover of Understanding MySQL internals

Understanding MySQL internals

Alexander Sasha Pachev, Alexander Pachev · 2006

Programming and computer science › Databases and distributed data

#7,025 most recommended

About the book

A guide to the internal architecture of the MySQL server, covering how its source code is organised and how a query moves through parsing, optimisation and execution. It also covers the storage engine layer, the threads and locking that support concurrent clients, and the logging and replication machinery. Knowing how the server works internally lets developers and administrators predict its behaviour, diagnose performance problems, and make sound design decisions rather than relying on guesswork. The book presents the source code as a readable system with identifiable components and interfaces, and it argues that a reader who understands those parts can reason about MySQL's behaviour and work with its code directly.

Written by Claude from what it knows of this book.

What Hacker News says 40% recommend · 0% critical

02420172018202020222017 peak · 2
This bookAverage book in Databases and distributed data

In the commenters’ own words

What Open Library readers say

No Open Library reader has rated it yet.

Open Library’s page for the book

What critics say, via Wikipedia

No Wikipedia article about this book yet, so no critics to quote.

Reddit communities — coming later

The threads it came up in

Details

First published
2006
ISBN
9780596009571
Editions known
2 at Open Library
Open Library
OL12443362W

MySQL (Electronic resource)Mysql (computer program language)SQL (Computer program language)

Explore in the mosaic

Read next: its neighbours on the mosaic