Message from Dean - May 8th 2007

I am currently testing out a new version of the APF Bridge Component - If you notice any errors within this demo store please drop me a line.

Binding: Paperback
Dewey Decimal Number: 005.7565
EAN: 9780596101718
Edition: 2
Format: Illustrated
ISBN: 0596101716
Label: O'Reilly Media, Inc.
Manufacturer: O'Reilly Media, Inc.
Number Of Items: 1
Number Of Pages: 708
Publication Date: June 26, 2008
Publisher: O'Reilly Media, Inc.
Studio: O'Reilly Media, Inc.

---

Related Items:

• MySQL Cookbook
• Building Scalable Web Sites: Building, scaling, and optimizing the next generation of web applications
• High Performance Web Sites: Essential Knowledge for Front-End Engineers
• MySQL Stored Procedure Programming
• Understanding MySQL Internals
• see more

Browse for similar items by category:

• Books > Specialty Stores > Custom Stores > By Publisher > O'Reilly > Programming > General
• Books > Specialty Stores > Custom Stores > New & Used Textbooks > Computer Science > Database Storage & Design
• Books > Specialty Stores > Custom Stores > New & Used Textbooks > Computer Science > Programming Languages
• Books > Specialty Stores > Custom Stores > New & Used Textbooks > Computer Science > General AAS
• Books > Specialty Stores > Custom Stores > New & Used Textbooks > General AAS

---

Editorial Review:

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.




Rating: - Amazing must have
If you have ever so much as sneezed near a MySQL statement you must read this book. I have been using MySQL and reading other books for at least a decade but had no idea how much I didn't know (had never thought of this way). This book is very well written, very useful and practical, detailed for complex concepts but high level for noob-esk items. At first I found the structure odd but after finishing I wouldn't change it. Even if you are not looking for 'performance' there is so much useful MySQL fundamentals clearly explained it is extremely useful. Just as a case in point, I lent it to a graphics designer whoes code is abstracted by an automated framework and it still helped him to make drastic improvements by more clearly understanding the impact his requests had. He has since not only purchased the book but passed it on to several others. Did I mention he was a graphics designer recommending a book about 'that database stuff'?

Hope this helps, best regards and may ... Read More

---

Rating: - Good goog.
Very good MySQL book for people who knows the basics and want to get deeper.

---

Rating: - Outstanding
The second edition of this book is far superior to any documentation or other books on MySQL that I have read. The content is extremely useful (see the table of contents), the writing is excellent and the explanations and diagrams are so lucid and elegant. The workarounds and other nifty pieces of advice are also valuable. I often couldn't put it down, which is unbelievable for a database text!

---

Rating: - Turbo Charging MySQL
Well, the first thing you want to do when you finish a book like this is go on and on about how impressed you are. This is one of the best database technology books I've read, and the best one on MySQL.

Digging into the book I would say I was an intermediate DBA. With 12 years experience on Oracle I was a seasoned DBA. And although I've used MySQL for about 10 years, I had not used all of the high end or newest 5.0 and 5.1 features. After reading this book, or while reading it, you'll be ready to dig into everything from MySQL master-master replication (not to be confused with multi-master), creating a logging server, optimizing your query cache, or even using some of the Google MySQL patches to add some much needed but missing feature to MySQL.

The book is organized pretty well. Keep in mind that this is not a beginner book. If you're looking for more general across the board MySQL book, I'd recommend the APress Pro MySQL by Kruckenberg and Pipes Pro MySQL ... Read More

---

Rating: - Huge improvement over 1st edition
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.

---