
High Performance MySQL
Jeremy D. Zawodny, Derek J. Balling, Baron Schwartz, Peter Zaitsev, Baron Schwartz. Peter Zaitsev. Vadim Tkachenko. Jeremy D. Zawodny. Arjen Lentz. Derek J. Balling · 2004
Programming and computer science › Databases and distributed data
#1,078 most recommended
Hacker News
44
mentions by 40 people · top 8% of 15,732 books
Open Library
4.00★★★★★★★★★★
3 ratings · 8 want to read
Wikipedia
—
No article yet
About the book
A practical guide to running MySQL well at scale, covering schema design, indexing, query optimization, and server configuration. It also addresses replication, high availability, backup and recovery, and the tools used to monitor and benchmark a live system. It is aimed at developers and administrators who need to scale MySQL beyond its defaults. Database performance is a property of the whole system, so tuning a single query or setting rarely solves the underlying problem. The authors argue that understanding how MySQL's storage engines, query optimizer, and locking behave lets you find bottlenecks through measurement and profiling rather than guesswork. They also contend that replication, backups, and failover should be designed in from the start, not added after an outage.
Written by Claude from what it knows of this book.
What Hacker News says 68% recommend · 3% critical
In the commenters’ own words
I don't have any one complete book that I can recommend, and I don't even really have a great reading list for this. But I'll make an attempt to share what I…
You should try to understand how databases in general work, it will help you with your query writing. One thing you have to realize is that once you get a…
What Open Library readers say 4.00 from 3 ratings
- 51
- 41
- 31
- 20
- 10
- 8 want to read
- 0 reading
- 5 have read
Only 3 ratings: treat the average as a hint.
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
- 2004
- ISBN
- 9781449314286
- Editions known
- 22 at Open Library
- Open Library
- OL15705149W
COMPUTERS / Programming Languages / SQLCom051170Cs.cmp_sc.app_swCs.cmp_sc.prog_langData modeling & designDatabase managementGamesGeneralMySQL (Electronic resource)Mysql (computer program language)Professional, career & trade -> computer science -> data modeling & designProfessional, career & trade -> computer science -> generalProfessional, career & trade -> computer science -> programming languages (jr/sr)Professional, career & trade -> computer science -> sql
Read next: its neighbours on the mosaic
MySQL High AvailabilityCharles Bell · 2014 · recommended by 2 people · named together in 3 comments
Scalable Internet architecturesTheo Schlossnagle · 2006 · recommended by 9 people · similar by subject and what people say about it
PostgreSQL 9.0 High PerformanceGregory Smith · 2010 · recommended by 12 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
Understanding MySQL internalsAlexander Sasha Pachev · 2006 · recommended by 2 people · similar by subject and what people say about it
The Art of PostgreSQLDimitri Fontaine · 2019 · recommended by 20 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
MySQLPaul DuBois · 2003 · recommended by 2 people · similar by subject and what people say about it
Systems PerformanceBrendan Gregg · 2013 · recommended by 32 people · similar by subject and what people say about it
SQL antipatternsBill Karwin · 2010 · recommended by 31 people · similar by subject and what people say about it
Database InternalsAlex Petrov · 2019 · recommended by 31 people · similar by subject and what people say about it
The art of SQLStephane Faroult · 2006 · recommended by 8 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
Designing Data-Intensive ApplicationsMartin Kleppmann · 2017 · recommended by 457 people · 2 people recommended both
High-Performance Java PersistenceVlad Mihalcea · 2016 · recommended by 1 person · similar by subject and what people say about it
The data warehouse toolkitRalph Kimball · 1996 · recommended by 23 people · similar by subject and what people say about it
Joe Celko's SQL for SmartiesJoe Celko · 1995 · recommended by 10 people · similar by subject and what people say about it
Building Scalable Web SitesCal Henderson · 2006 · recommended by 14 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
High Performance Browser NetworkingIlya Grigorik · 2013 · recommended by 58 people · similar by subject and what people say about it
Developing time-oriented database applications in SQLRichard T. Snodgrass · 1999 · recommended by 6 people · similar by subject and what people say about it
Seven Databases in Seven WeeksEric Redmond · 2012 · recommended by 8 people · similar by subject and what people say about it
SQL for Web NerdsPhilip Greenspun · 2000 · recommended by 7 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