| Overview
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.
Editorial ReviewsProduct DescriptionHigh 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. |
Other Readers Also Read | Top Sellers in This Category | Browse Similar Topics | | | Top Level Categories:Sub-Categories: | | | | |
Reader Reviews From Amazon (Ranked by 'Helpfulness') Average Customer Rating: based on 16 reviews. Good, but incomplete, 2009-03-18 Reviewer rating: I bought this book hoping to get a detailed understanding of how to best create and use indexes for my high traffic web site. While the book does a great job of covering the pros and cons of standard indexes, it devotes only a single page to the utility of index_merge (introduced in Mysql 5.0). Combined with a general dearth of information about index_merge on the web, this was a really disappointment, since index_merge seems to afford the possibility of using multiple, smaller indexes, rather than smaller number of bulky indexes (as this book recommends).
In my eyes, a thorough analysis of indexing techniques in Mysql 5+ must discuss the strategic opportunities afforded by index_merge. It would seem to me that this gives the developer the ability to simply index the fields they want indexed, without having to sweat left-precedence of combined indexes or trying to make long indexes that include all of the possibly needed indexes in an order that will satisfy all possible query combinations.
If limitations to the utility of index_merge make some of these possibilities not feasible, the book ought to at least give a rundown of the pros and cons of index_merge vs. compound indexes.
The near-total omission of a new feature that could have profound implications upon the most optimal way to query & index makes me recommend this book with a tablespoon of salt. | Seminal book on MySQL performance, 2009-03-03 Reviewer rating: If you want to scale MySQL, this book is a requirement for you. The real world experience covered by the team of authors of this seminal book on MySQL is unmatched. Your knowledge of this topic won't be complete until you've read the book. This is not necessarily an easy read if you haven't used everything covered in the book, but it's worth buying if only to cover the topics that apply to you. | good !!, 2009-02-24 Reviewer rating: The book is good. lots of new information as compared to the previous edition.
the book arrived in time. | Great for beginner to advanced, 2009-02-21 Reviewer rating: This book is great for anyone (Developer, DBA, etc.) that touches MySQL. From beginners to the advanced user, you will learn something. High Performance MySQL is a must read for anyone building something with MySQL. | Good guide and starting point for advanced projects, 2009-01-17 Reviewer rating: I purchased this book when starting a project wherein I needed to utilize replication, Federated tables, and some other moderately advanced features. Beyond just how to use these features, this book provides insight into tips and methods that only practice can provide. You save time sidetracking time sinks and are shown tools you might not have been aware of. If you need to do more than access a few tables and change a column or two, pick this book up. |
Some information above was provided using data from Amazon.com. View at Amazon > |
| |
|
|
