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.40  ·  Rating details ·  193 ratings  ·  13 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 availa

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
4.40  · 
Rating details
 ·  193 ratings  ·  13 reviews

More filters
Sort order
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:
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 wa
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
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
rated it it was amazing
Apr 08, 2012
Tomasz Kowalczyk
rated it it was amazing
Jul 22, 2014
rated it liked it
Oct 01, 2016
rated it it was amazing
Jul 29, 2016
rated it really liked it
Sep 30, 2018
« previous 1 3 4 5 6 7 next »
There are no discussion topics on this book yet. Be the first to start one »

Readers also enjoyed

  • The Definitive Guide to Django: Web Development Done Right
  • Seven Databases in Seven Weeks: A Guide to Modern Databases and the NoSQL Movement
  • Code Simplicity: The Fundamentals of Software
  • Web Operations: Keeping the Data on Time
  • Linux System Programming: Talking Directly to the Kernel and C Library
  • jQuery: Novice to Ninja
  • MapReduce Design Patterns: Building Effective Algorithms and Analytics for Hadoop and Other Systems
  • SSH Mastery: OpenSSH, PuTTY, Tunnels and Keys
  • Programming Android: Java Programming for the New Generation of Mobile Devices
  • MongoDB: The Definitive Guide
  • JavaScript Enlightenment
  • MySQL Cookbook
  • Developing Backbone.js Applications
  • Version Control with Git
  • PHP Objects, Patterns, and Practice
  • SQL and Relational Theory: How to Write Accurate SQL Code
  • MongoDB in Action
  • The Art of SQL
See similar books…

Goodreads is hiring!

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