What do you think?
Rate this book
High Performance MySQL: Optimization, Backups, Replication & Load Balancing
As users come to depend on MySQL, they find that they have to deal with issues of reliability, scalability, and performance--issues that are not well documented but are critical to a smoothly functioning site. This book is an insider's guide to these little understood topics.Author Jeremy Zawodny has managed large numbers of MySQL servers for mission-critical work at Yahoo!, maintained years of contacts with the MySQL AB team, and presents regularly at conferences. Jeremy and Derek have spent months experimenting, interviewing major users of MySQL, talking to MySQL AB, benchmarking, and writing some of their own tools in order to produce the information in this book.In High Performance MySQL you will learn about MySQL indexing and optimization in depth so you can make better use of these key features. You will learn practical replication, backup, and load-balancing strategies with information that goes beyond available tools to discuss their effects in real-life environments. And you'll learn the supporting techniques you need to carry out these tasks, including advanced configuration, benchmarking, and investigating logs.Topics
304 pages, Paperback
First published January 1, 2004
47 people are currently reading
722 people want to read
About the author
Jeremy D. Zawodny
6Ìýbooks6ÌýfollowersAs of October 2012, Jeremy Zawodny is an employee of Craigslist, having previously worked in Yahoo!'s platform engineering group, where he was described as "Yahoo!'s MySQL guru".
He maintains a popular weblog focused on Yahoo! initiatives, which is listed in CNET News.com's index of the 100 best technology-related blogs. According to CNET, Zawodny has "helped put MySQL and other open-source technologies to use".
He maintains a popular weblog focused on Yahoo! initiatives, which is listed in CNET News.com's index of the 100 best technology-related blogs. According to CNET, Zawodny has "helped put MySQL and other open-source technologies to use".
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 - 18 of 18 reviews
December 22, 2019
Seriously! Why nobody talked about this book during my college years? A graet book I regret not reading it sooner! Lots and lots of things to comprehend!
March 22, 2017
A *great* book for anyone who wants to understan mysql better and how to tune it. I particularly liked it because it started at the basics with a conceptual overview, then dived into details. There are probably even more details it didn't go into, so I'll start looking for the next book. But this one was invaluable.
December 30, 2021
In-depth explanation of MySQL with pragmatic examples.
Would recommend reading the latest release as there are parts that have changed with newer MySQL versions - at the time I read it 4th Edition of the book was the latest.
For me as a developer some of the chapters had information that I could not apply - but I would still recommend to read the parts that you do use like query optimisations, indexing, data types etc.
The first read will give you a good understanding of the behind the scenes but it's one of those books you would like to keep on your side and refer back.
Would recommend reading the latest release as there are parts that have changed with newer MySQL versions - at the time I read it 4th Edition of the book was the latest.
For me as a developer some of the chapters had information that I could not apply - but I would still recommend to read the parts that you do use like query optimisations, indexing, data types etc.
The first read will give you a good understanding of the behind the scenes but it's one of those books you would like to keep on your side and refer back.
January 30, 2007
This a decent book for admins -- well written and easy to read, much more so than the manual. However, it is dated and only covers versions of MySQL up to 4.1 -- too bad as everyone should be using 5.0 nowadays. A good starting point for replication, backups, and optimization. [Read cover-to-cover]
April 6, 2009
For anyone building a solution based on MySQL.. whether its getting the most out of a hosted database, or building a multi-tier master slave replication fan-out, this book will offer great insight from people who've probably already done what you're trying to do. I tend to keep it within reach so that I can flip through the index of the book before googling for the answer to a question.
September 17, 2007
This book is a must read for those working with MySql and concerned with performance. It's not a large book, but it's dense with practical information and if you work with large datasets or complex schemas/queries, it's an invaluable reference.
April 3, 2009
Just started it but so far it is very informative (if you haven't already taken advanced mysql database courses)
September 19, 2009
This book is gold. Everything you wanted to know about MySQL that you can't easily Google, organized in a useful way.
May 29, 2016
This book likes wiki for me. Derek has good talent to write in technical description. I love this book. Derek give me many new things about MySQL.
August 18, 2010
It's must to read book
Want to read
December 4, 2012A real page turner...
Read
March 22, 2013i want to read this book
July 25, 2015
The ultimate book to learn the in and outs of advance MySQL, beyond just writing queries. Made me more eager to learn about database.
May 19, 2016
Read binlog related chapters.
December 30, 2016
A useful reference for the quotidian MySQL user of any level of expertise
May 23, 2011
Perfect Book , Learned to much , it help me to mange my applications databases Performance ,
September 7, 2015
The best techinical book, I ever read.
May 9, 2016
perfect
Displaying 1 - 18 of 18 reviews
Can't find what you're looking for?
Get help and learn more about the design.