
Understanding MySQL internals
Alexander Sasha Pachev, Alexander Pachev · 2006
Programming and computer science › Databases and distributed data
#7,025 most recommended
Hacker News
5
mentions by 5 people · top 48% of 15,732 books
Open Library
—
No ratings yet
Wikipedia
—
No article yet
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
In the commenters’ own words
I've gathered all the book titles in this thread and created Amazon affiliate links (if you don't mind. Otherwise you still have all the titles together :-) )…
Some of the most interesting books I've read in support of my software-development work are: * "Compilers: Principles, Techniques, & Tools" by Aho et al…
What Open Library readers say
No Open Library reader has rated it yet.
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)
Read next: its neighbours on the mosaic
Transaction processingGray, Jim · 1993 · recommended by 13 people · loosely similar by subject
Database system implementationHector Garcia-Molina · 1999 · recommended by 3 people · similar by subject and what people say about it
Data flow analysisUday Khedker · 2009 · recommended by 4 people · loosely similar by subject
Genetic programmingWolfgang Banzhaf · 1998 · recommended by 2 people · loosely similar by subject
Database InternalsAlex Petrov · 2019 · recommended by 31 people · similar by subject and what people say about it
High Performance MySQLJeremy D. Zawodny · 2004 · recommended by 27 people · similar by subject and what people say about it
Pro SQL Server InternalsDmitri Korotkevitch · 2014 · recommended by 2 people · similar by subject and what people say about it
MySQLPaul DuBois · 2003 · recommended by 2 people · similar by subject and what people say about it
MySQL High AvailabilityCharles Bell · 2014 · recommended by 2 people · similar by subject and what people say about it
Linux Kernel DevelopmentRobert Love · 2004 · recommended by 44 people · similar by subject and what people say about it
Database systemsHector Garcia-Molina · 2001 · recommended by 11 people · similar by subject and what people say about it
Database System ConceptsKorth · 2005 · recommended by 4 people · similar by subject and what people say about it
SQL Performance ExplainedMarkus Winand · 2011 · recommended by 26 people · similar by subject and what people say about it
Solaris internalsRichard McDougall · 2006 · recommended by 4 people · similar by subject and what people say about it
Database management systemsRaghu Ramakrishnan · 2001 · recommended by 7 people · similar by subject and what people say about it
Database Design for Mere MortalsMichael J. Hernandez · 1996 · recommended by 12 people · similar by subject and what people say about it
Database design and implementationEdward Sciore · 2008 · recommended by 7 people · similar by subject and what people say about it
Compilers, principles, techniques, and toolsAlfred V. Aho · 1986 · recommended by 195 people · 2 people recommended both
Database in depthC. J. Date · 2005 · recommended by 4 people · similar by subject and what people say about it
Fundamentals of database systemsRamez Elmasri · 1989 · recommended by 2 people · similar by subject and what people say about it
Understanding Linux network internalsChristian Benvenuti · 2005 · recommended by 2 people · similar by subject and what people say about it
Unix InternalsUresh Vahalia · 1995 · recommended by 6 people · similar by subject and what people say about it
Architecture of a database systemJoseph M. Hellerstein · 2007 · recommended by 7 people · similar by subject and what people say about it
Understanding The Linux KernelDaniel P. Bovet · 2000 · recommended by 24 people · similar by subject and what people say about it