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.37  ·  Rating details ·  215 ratings  ·  14 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 availab ...more
ebook, 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

This book is not yet featured on Listopia. Add this book to your favorite list »

Community Reviews

Showing 1-30
Average rating 4.37  · 
Rating details
 ·  215 ratings  ·  14 reviews

More filters
Sort order
Start your review of High Performance MySQL: Optimization, Backups, and Replication
Jul 15, 2018 rated it it was ok  ·  review of another edition
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 walke
Sohaib Shaheen
Mar 17, 2020 rated it it was amazing  ·  review of another edition
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
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
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
Tomasz Kowalczyk
rated it it was amazing
Jul 22, 2014
« 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

  • Load Balancing with HAProxy: Open-source technology for better scalability, redundancy and availability in your IT infrastructure
  • The Tangled Mind: Unraveling the Origin of Human Nature
  • Unlimited Memory: How to Use Advanced Learning Strategies to Learn Faster, Remember More and be More Productive (Mental Mastery Book 1)
  • Beginning Node.js, Express & MongoDB Development
  • The Manager's Path: A Guide for Tech Leaders Navigating Growth and Change
  • Speed Reading: How To Read 3-5 Times Faster And Become an Effective Learner (Positive Psychology Series Book 6)
  • Networking for Systems Administrators (IT Mastery Book 5)
  • Introducing Game Theory: A Graphic Guide
  • Machine Learning: A Visual Starter Course For Beginner's
  • The Adventures of Rabbi Harvey: A Graphic Novel of Jewish Wisdom and Wit in the Wild West
  • Quotes That Will Change Your Life: A Curated Collection of Mind-Blowing Wisdom
  • Decision Trees and Random Forests: A Visual Introduction For Beginners: A Simple Guide to Machine Learning with Decision Trees
  • A History of the World in 21 Women: A Personal Selection
  • The Best of the Rejection Collection: 293 Cartoons That Were Too Dumb, Too Dark, or Too Naughty for The New Yorker
  • A Human's Guide to Machine Intelligence: How Algorithms Are Shaping Our Lives and How We Can Stay in Control
  • Talk to Me: How Voice Computing Will Transform the Way We Live, Work, and Think
  • Gen Z @ Work: How the Next Generation Is Transforming the Workplace
  • Business Model Generation
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

San Francisco is a gold rush town. There aren’t many books about people in their 20s who move to Silicon Valley with dreams of earning a living wag...
34 likes · 1 comments