Goodreads helps you keep track of books you want to read.
Start by marking “High Performance MySQL: Optimization, Backups, and Replication” as Want to Read:
High Performance MySQL: Optimization, Backups, and Replication
Enlarge cover
Rate this book
Clear rating
Open Preview

High Performance MySQL: Optimization, Backups, and Replication

4.38  ·  Rating details ·  220 ratings  ·  15 reviews

How can you bring out MySQL’s full power? With High Performance MySQL, you’ll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high avai

Kindle Edition, 826 pages
Published March 5th 2012 by O'Reilly Media (first published June 18th 2008)
More Details... Edit Details

Friend Reviews

To see what your friends thought of this book, please sign up.

Reader Q&A

To ask other readers questions about High Performance MySQL, please sign up.

Be the first to ask a question about High Performance MySQL

Community Reviews

Showing 1-30
Average rating 4.38  · 
Rating details
 ·  220 ratings  ·  15 reviews

More filters
Sort order
Start your review of High Performance MySQL: Optimization, Backups, and Replication
Jul 15, 2018 rated it it was ok
Shelves: cs
Databasing is all of the following: a hard precondition of almost all modern social activities; the high-stakes application of some very deep intellectual tortures; unutterably boring. This book's a nice intro to higher-level considerations: Query tuning (i.e. ask the question better), indexing (i.e. ask if it's been asked before), server tuning (ask a better person), replication (ask several people), benchmarking (ask trick questions). Not exactly chatty, but as engaging as you could expect:
Dmytro Shteflyuk
This is one of those you always keep closeby. A must-read for anybody who works with MySQL.
Sep 01, 2012 rated it it was amazing  ·  review of another edition
Great read! Helped us(Jaxtr) to scale to 10 million users in 8 months.
Jan 22, 2019 rated it it was amazing  ·  review of another edition
Fantastic book.

There's a ton of great content in here, whether you're a DBA or an app developer that wants to understand their MySQL infrastructure better.

Discussion is not always focused on MySQL and reminds you to view MySQL as a component in a larger high performance system. Topics (eg. performance profiling) teach lessons valuable beyond MySQL, but with specific techniques for MySQL>

I could see parallels between the systems described in the book and what I see running in production and walke
Sohaib Shaheen
Mar 17, 2020 rated it it was amazing
One of the best books ever written on optimizing MySQL engine for performance. Will highly recommend to all developers, who are not aware of how DB engines work and how small tweaks can make difference in magnitudes of performance. I was myself able to optimize database with over 14 million records to respond in mere seconds after just optimizing indexes and data structure.

Use it as a guide to continuously improve your knowledge and as checkpoint list to apply to all systems with significant dat
Alexander Baygeldin
Feb 19, 2019 rated it really liked it
This book is an immense source of information. The authors put an enormous effort into condensing their knowledge about MySQL performance in a single book. However, in my opinion, the ratio of the book's value to its size is kind of upsetting. After finishing the book, I can't really say that the time I spent on it was worth it. But at least I know where to look for a piece of advice if I encounter an issue with MySQL performance.
May 20, 2017 rated it really liked it  ·  review of another edition
Some excellent tips in here, particularly the sections on table types and indexes. More of a reference work that you'll dip into than something to read from cover to cover - e.g. I keep a printed copy of the explanation of EXPLAIN columns on my desk.

If you have the electronic version from O'Reilly, make sure you download the latest copy as there was a second release in 2015.
Mark McGranaghan
The canonical resource on deploying and operating MySQL in production. Obviously based on the authors' extensive production experiences and work in the MySQL OSS and commercial support worlds. A little annoying that there are frequent branches in the book to account for different storage engines and MySQL distributions, but that's the nature of the beast.
Jan 20, 2015 rated it really liked it  ·  review of another edition
The standard book for everyone who wants to learn more about MySQL performance. The book is written by multiple authors and that shows in that different sections easier or harder to read but the overall level of information is very good. The book does require some basic knowledge about MySQL and relational databases in general.
Uri Mogilevsky
Jan 09, 2014 rated it it was amazing  ·  review of another edition
Shelves: nonfiction
A lot of important and helpful information + very good, readable style, especially for a book on such a technical issue. Excellent!
Filip Tepper
Good introduction to more advanced MySQL topics for beginners, though with years of experience you probably you won't find anything surprising in this book.
Aurimas Mikalauskas
Sep 24, 2013 rated it it was amazing  ·  review of another edition
Shelves: print
THE bible of MySQL
Artur Sabirov
Apr 06, 2012 rated it really liked it  ·  review of another edition
Огромная книга с избыточной подачей материала для простого чтения. Можно прочесть главы по оптимизации запросов, индексам, движкам и тюнингу конфига. Остальное можно дочитывать по мере необходимости.
Ladislav Prskavec
Jan 03, 2014 rated it it was amazing
Best book about MySQL.
rated it really liked it
Oct 22, 2018
Dan Hirsch
rated it it was amazing
Jul 19, 2018
Igor Dvoretskyi
rated it really liked it
May 25, 2014
Neal C
rated it liked it
May 20, 2017
rated it really liked it
Aug 19, 2018
rated it it was amazing
Jan 18, 2016
rated it really liked it
Apr 18, 2012
rated it liked it
Aug 25, 2018
Volodymyr Dmytrechko
rated it it was amazing
Aug 16, 2017
Julio Sueiras
rated it it was amazing
Jan 20, 2015
rated it really liked it
Nov 26, 2019
Mihailo Joksimovic
rated it it was amazing
Jul 28, 2017
rated it really liked it
Mar 17, 2018
Dominik Fijaś
rated it really liked it
Feb 05, 2017
Federico Fregosi
rated it really liked it
Jan 18, 2020
rated it it was amazing
Apr 08, 2012
« previous 1 3 4 5 6 7 8 next »
There are no discussion topics on this book yet. Be the first to start one »

Readers also enjoyed

  • Domain-Driven Design: Tackling Complexity in the Heart of Software
  • Patterns of Enterprise Application Architecture
  • The Manager's Path: A Guide for Tech Leaders Navigating Growth and Change
  • Building Microservices: Designing Fine-Grained Systems
  • Designing Data-Intensive Applications
  • The Pragmatic Programmer: From Journeyman to Master
  • Clean Code: A Handbook of Agile Software Craftsmanship
  • Accelerate: Building and Scaling High-Performing Technology Organizations
  • Peopleware: Productive Projects and Teams
  • The Mythical Man-Month: Essays on Software Engineering
  • Kafka: The Definitive Guide: Real-Time Data and Stream Processing at Scale
  • The Gulag Archipelago 1918–1956 (Abridged)
  • Debugging: The 9 Indispensable Rules for Finding Even the Most Elusive Software and Hardware Problems
  • Clean Architecture
  • Pro Spring 5: An In-Depth Guide to the Spring Framework and Its Tools
  • Elegant Objects
  • Cracking the Coding Interview: 150 Programming Questions and Solutions
  • Pro Java Clustering and Scalability: Building Real-Time Apps with Spring, Cassandra, Redis, WebSocket and RabbitMQ
See similar books…

Goodreads is hiring!

If you like books and love to build cool products, we may be looking for you.
Learn more »

Related Articles

There's something great about a paperback book: They're perfect book club choices, you can throw them in your bag and go, and they've been out in...
59 likes · 17 comments