Regular marked price: $49.99Discount Price: $31.49
Cost Savings: $18.50 (37%)Price fluctuation possible.
How soon does it ship: Normal ship time within one day
Shipping? Absolutely FREE if you qualify for Super Saver Shipping.
Type of bind: Paperback
Dewey Decimal Number: 005.7565
EAN num: 9780596101718
Format: Illustrated
ISBN number: 0596101716
Label: O'Reilly Media, Ltd.
Manufacturer: O'Reilly Media, Ltd.
Quantity: 1
Page Count: 708
Printing Date: June 26, 2008
Publishing house: O'Reilly Media, Ltd.
Sale Popularity Level: 9257
Studio: O'Reilly Media, Ltd.
Other books you might be interested in perusing:
Editor's Notes and Comments:
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 discusion 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.
User popularity level:
Rated by buyers 
-
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 subsequent printing.
Rated by buyers 
-
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 very first book about MySQL (not only knowledge but some experience is handy) but definitely second one ;)
Rated by buyers -
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.
Rated by buyers -
Very nice book but unfortunately this book is not for beginners so if you're new in databases try to read some tutorials or books for beginners and then come back for this book.
Rated by buyers -
As a MySQL expert with 9 years in MySQL performance and scalability, this book is definitely even in my library with my company 42SQL -- www.42sql.com
The 2nd edition is a complete rework with multiple new authors, with entire new content and significantly more volume then the 1st edition.
Containing a cross section from sound basic design tips such as choosing the optimal data types, and indexing strategies to the in-depth details of OS specifics such as the Raid chunk size for disk subsystems and LVM snapshot management this book has plenty of detail.
Being an independent publication not from the supplier, you are sure to also know where the strengths and weaknesses exist with the product. Comments like "MySQL replication has a number of shortcomings that MySQL AB plans to address in the future" pg. 407 highlights that MySQL is not perfect, and it's important to know any present limitations and how to address them.
I've yet to find the time to sit down and read this book from cover to cover, however for somebody relatively new to MySQL, this is a great book to read after you know the basic syntax of MySQL. A lot may not make sense the very first time, but re-read it again in 6-12 months after you continue to use and understand MySQL.
The book is already exceeding expectations with news of a second printing with small corrections and translations already commencing in several languages.
Find other books like this one:
