High Performance MySQL: Optimization, Backups, Replication, and More

High Performance MySQL: Optimization, Backups, Replication, and More by Arjen Lentz, Baron Schwartz, Derek J. Balling, Jeremy D. Zawodny, Jeremy Zawodny, Peter Zaitsev and Vadim Tkachenko

High Performance MySQL: Optimization, Backups, Replication, and More

Binding:
Paperback
Number of Pages:
712
ISBN:
0596101716
Product Group:
book
Publisher:
O'Reilly Media
Publication Date:
June 18, 2008
BooksForGeeks.com ID:
1459

Explains how MySQL works 'under the hood' so that experienced users can understand why it's fast and, conversely, what can slow it down. This book teaches how to maximize the speed and robustness of MySQL through advanced configuration, and methods to optimize everything from schemas, queries, server settings and applications to operating systems.

Reviews for High Performance MySQL: Optimization, Backups, Replication, and More

  1. Detailed

    Rated 5 out of 5 stars, January 12th, 2010

    I'm about halfway through reading this book and I've found it extremely enlighting. Though I am not working with applications that require performance of the level this book is referring to, it has taught me lot.

    I finally have a clear picture of indexes and I should work with them, designing queries to use indexes and their sometimes not so obvious features. I generally have found this book to be detailed enough, in many cases there are explanation how MySQL works giving you the necessary info on how to design your schema and queries. I personally find it more pleasing to know why I should implement something in a certain way and not just how. This book offers both.

    So, even though you might not be after that "High Performance", there's no need to pass this book, it will explain a great deal of MySQL's inner workings and give you tools to a secure and efficient database handling.
  2. One of the most useful book on the topic

    Rated 5 out of 5 stars, December 12th, 2009

    Finally something everybody who manages MySQL databases would like to read. It goes in deep details and covers almost all aspect of the performance issues when dealing with large databases. I do recommend it.
    Sergio
  3. A definite read for mysql developers

    Rated 4 out of 5 stars, December 12th, 2008

    This book is not for beginners! This book is aimed at experienced developers who wish to take their mysql skills to the next level.

    If you think you know it all, then you probably dont and this book is worth every penny! It will teach you how to choose the correct engine, optimise & bench mark your work to make sure you get the best out of your system. Its not easy and there is plenty to take in.

    Excellent book - I gave it 4/5 because I felt that it went into too much details in some unimportant areas and skimmed over other areas that I thought were more important - however, this is probably just a personal preference. So might deserve closer to 4.8/5 :)
  4. Still the de-facto reference for serious use of MySQL IMHO

    Rated 5 out of 5 stars, December 12th, 2008

    The first edition of this book was a real find - at last a non-introductory book about MySQL that covers its use in more serious applications, the pros and cons of the variety of DB engines and coverage of other enterprise issues like backup and replication.

    4yrs on after the 1st edition I was delighted to see an updated version of this book. The new book is more than double the thickness of the original, covering MySQL right up to v5.1. The good news is that the high density of detailed useful information packed into the original book has been maintained in this edition.

    You really get the sense the authors know MySQL like the back of their hands, both in theory and practice and are passionate about getting their knowledge across in the book to help in your real-world applications.

    This book is not for beginners learning databases, MySQL or SQL, but must surely be the de-facto reference for performance and enterprise use of MySQL.

Our Network

BooksForGeeks.com is a participant in the Amazon Europe S.à r.l. Associates Programme, an affiliate advertising programme designed to provide a means for sites to earn advertising fees by advertising and linking to amazon.co.uk