Rating:  Summary: High Performance INDEED! Review: There's mysql documenation, and then there's this book. This book is like taking having the opportunity to pick at a seasoned pro's brain! I have almost every MySQL book out there and while the others merely taught me how to use MySQL, this one taught me how to push make it work FAST and EFFICIENT!I honestly couldn't believe how much insight and experience I gained from this book. Almost every single page was fun and easy to read. I can honestly say that I can design and build one (...) database now as a direct result of this book. Thank you so much guys!
Rating:  Summary: Essential for any serious MySQL User Review: This is a very helpful and informative book. I learned a lot from it even though I have been using MySQL for nearly three years. I was able to improve the speed and performance of my server using the information provided by Jeremy and Derek. The book contains a lot of very helpful information the theory and practice of MySQL replication. The authors clearly and explicitly describe how to setup and manage replication, and how to deal with failures and failover. There are plenty of architecture diagrams, accompanied by lucid descriptions of the good and bad points of each one. The sections on query and server optimization are first class as well. There are plenty of vignettes drawn from Jeremy's real-world experience running MySQL at Yahoo. My only criticism is that the book seemed too short. I can't identify any particular elements that they omitted. However, like a good novel, this book was over way too soon.
Rating:  Summary: Make MySQL efficient Review: While the authors go over the basics of MySQL briefly in the first couple of chapters this is not a book for the new MySQL administrator. It assumes a good deal of basic knowledge about MySQL. On the other hand, if you know the basics and need to get that extra knowledge to move your system from one that just works to one that truly performs then this book is for you. From the initial steps of benchmarking your system and tweaking the indexes the book moves on to improving your performance through optimizing queries and server performance tuning. This includes examining all aspects of your system from disk and file system selection to minor configuration changes that may make great changes in performance. Once the server is working at its optimum for your needs the book turns to how to scale your SQL system up to multiple servers and configure replication, load balancing, and high availability systems. The main text of the book ends with a section on backup, recovery, and security. If you need performance, reliability and security beyond the standard configuration and need to maximize throughput this is the book you will want to have at hand. "High Performance MySQL" is one of the best optimization and performance books available for the intermediate to advanced user of MySQL - very highly recommended.
Rating:  Summary: Make MySQL efficient Review: While the authors go over the basics of MySQL briefly in the first couple of chapters this is not a book for the new MySQL administrator. It assumes a good deal of basic knowledge about MySQL. On the other hand, if you know the basics and need to get that extra knowledge to move your system from one that just works to one that truly performs then this book is for you. From the initial steps of benchmarking your system and tweaking the indexes the book moves on to improving your performance through optimizing queries and server performance tuning. This includes examining all aspects of your system from disk and file system selection to minor configuration changes that may make great changes in performance. Once the server is working at its optimum for your needs the book turns to how to scale your SQL system up to multiple servers and configure replication, load balancing, and high availability systems. The main text of the book ends with a section on backup, recovery, and security. If you need performance, reliability and security beyond the standard configuration and need to maximize throughput this is the book you will want to have at hand. "High Performance MySQL" is one of the best optimization and performance books available for the intermediate to advanced user of MySQL - very highly recommended.
|