High Performance MySQL: Optimization, Backups, Replication, and More | 
 enlarge | Authors: Baron Schwartz, Peter Zaitsev, Vadim Tkachenko, Jeremy Zawodny, Arjen Lentz, Derek Balling
Publisher: O'Reilly Media, Inc.
Category: Book
List Price: $49.99
Buy New: $28.48
You Save: $21.51 (43%)
New (29) Used (6) from $28.48
Avg. Customer Rating:  7 reviews
Sales Rank: 3543
Format: Illustrated
Media: Paperback
Edition: 2
Number Of Items: 1
Pages: 708
Shipping Weight (lbs): 2.2
Dimensions (in): 9.1 x 7 x 1.3
ISBN: 0596101716
Dewey Decimal Number: 005.7565
EAN: 9780596101718
ASIN: 0596101716
Publication Date: June 26, 2008
Availability: Usually ships in 1-2 business days
Shipping: International shipping available
Condition: Brand new item. Over 4 million customers served. Order now. Selling online since 1995. Few left in stock - order soon. Code: I20081010021123S
|
| Editorial Reviews:
Product Description
High Performance MySQL is the definitive guide to building fast, reliable systems with MySQL. Written by noted experts with years of real-world experience building very large systems, this book covers every aspect of MySQL performance in detail, and focuses on robustness, security, and data integrity. High Performance MySQL teaches you advanced techniques in depth so you can bring out MySQL's full power. Learn how to design schemas, indexes, queries and advanced MySQL features for maximum performance, and get detailed guidance for tuning your MySQL server, operating system, and hardware to their fullest potential. You'll also learn practical, safe, high-performance ways to scale your applications with replication, load balancing, high availability, and failover. This second edition is completely revised and greatly expanded, with deeper coverage in all areas. Major additions include: Emphasis throughout on both performance and reliability Thorough coverage of storage engines, including in-depth tuning and optimizations for the InnoDB storage engine Effects of new features in MySQL 5.0 and 5.1, including stored procedures, partitioned databases, triggers, and views A detailed discussion on how to build very large, highly scalable systems with MySQL New options for backups and replication Optimization of advanced querying features, such as full-text searches Four new appendices The book also includes chapters on benchmarking, profiling, backups, security, and tools and techniques to help you measure, monitor, and manage your MySQL installations.
|
| Customer Reviews: Read 2 more reviews...
 Huge improvement over 1st edition October 4, 2008
If you read the first edition and were underwhelmed, this is a vastly improved book. This second edition is entirely rewritten, more than twice as long, and covers a wide array of topics in depth, giving detailed advice and analysis in every chapter. The authors' advice on Innodb tuning, query optimization, and advanced replication issues is very strong. If you are responsible for a non-trivial MySQL installation, get this book.
Excellent September 17, 2008
1 out of 1 found this review helpful
This is a must have book for any Mysql DBA who want to learn more about performance tuning beyond reading the explain plan. The only gripe I have is that aside from the Query Performance Optimization and Optimizing Server Settings section, the authors should have another section dealing specifically with Tuning Writes and Tuning Reads other than that it's an excellent book, it even includes snippets on Prepared statements which I used often along with stored procedures to optimize performance.
Excellent book for advanced users September 1, 2008
2 out of 2 found this review helpful
The title of this book is very appropriate. Great coverage on performance, reliability, backup & recovery. Definitely not an introductory book.
There were a couple of places where the writing was hard to follow, but I'm sure that'll be fixed in the next printing.
 One of the most usefull books about MySQL nowdays August 24, 2008
1 out of 1 found this review helpful
This book has to have any MySQL DBA (both administrators and architects). It provides very deep view on how MySQL works and reacts on your configuration and SQL.
If you are programmer, you should browse this book too, to get background about MySQL and what it can do for you and what you can do for MySQL to get best performance SQL.
This probably should not be your first book about MySQL (not only knowledge but some experience is handy) but definitely second one ;)
Outstanding book on tuning MySQL August 20, 2008
I work with MySQL in a web server environment every day and performance
is always an issue. This book is simply excellent. The authors are quite knowledgeable -- they not only tell you what settings to you, but also include why. They debunked a lot of misconceptions I held about getting the best performance out of the server and when to use MyISAM v. InnoDB.
I especially appreciated the deep background into server operation and how data is stored and queries processed with the different storage engines. If you are thinking of using MySQL on a large project, you need this book.
There's a good reason this is a 2nd edition -- a great book.
|
|
|
