|
High Performance MySQL: Optimization, Backups, Replication, and More |  | Authors: Baron Schwartz, Peter Zaitsev, Vadim Tkachenko, Jeremy Zawodny D., Arjen Lentz, Derek J. Balling
Publisher: O'Reilly Media
Category: Book
List Price: $49.99
Buy New: $27.49
as of 3/15/2010 15:07 CDT details
You Save: $22.50 (45%)
New (33) Used (13) from $27.46
Seller: palimpsest-ca
Rating:  21 reviews
Sales Rank: 39585
Media: Paperback
Edition: 2
Pages: 712
Number Of Items: 1
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 18, 2008
Availability: Usually ships in 1-2 business days
| |
| Features:
|
| Also Available In:
|
| Similar Items:
| |
| 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:
Showing reviews 1-5 of 21
 A good start point into high performance February 11, 2010
Lucas de L. Lorenzo (Madrid, Spain)
It's a good start point into high performance tunning, but not a deep into every concept, which is not possible in a single book. The book dives into some benchmark, optimization of queries, the capabilities of every storage engine, and also its weaknesses, some compared backup strategies, replication, and master-slave configurations, all well explained, up to MySQL 5.1, but with new versions in mind. I enjoy this book, although some concerns are hard by nature, and some kind of query optimization could be more graphical to better understanding.
 Very useful... just very useful. November 11, 2009
Gaston Draque (Buenos Aires, Argentina)
1 out of 1 found this review helpful
How come I did not comment on this book before? Its been some time since I got it, read it, and used it! That's what this book is... useful, very useful. We had to optimize a DB, specially a huge table with millions of numbers and managed to go from tens of seconds to milisecs. I would say it was.. well, very useful;)
PERFECT BOOK! JUMP INTO ACTION IN FEW PAGES October 10, 2009
F. Levanti (Firenze - Florence, Italy IT)
A good book for developers that want more. They want to optimize their scripts and really understand how MYSQL works also behind the scene.
A must have book
I'll be surprised if I don't get a raise after mastering this book July 30, 2009
Michael T. Saldivar (Castro Valley, CA USA)
For weeks, I'd been searching online, trying to find out what MySQL's slow queries log actually was. Eventually I found it.
And then I got this book, and there was an even better description than what I'd found in MySQL's online documentation.
I swear, after I've worked my way through this book, if I don't double my wages, I'll be a monkey's uncle.
A very good percpective of MySQL June 27, 2009
M. Thomas Boquet (Paris, FRANCE)
This book helped me understand how MySQL works internally and a lot of tricks to improve the performances of both the server itself and the SQL queries I run against it.
If you want to improve the performances of MySQL related work in your applications, this book is definitively for you
Showing reviews 1-5 of 21
|
|
|
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME. [ powered by full speed ]
| |
