High Performance MySQL, 2nd Edition

High Performance MySQL, 2nd Edition Book 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.

About the Authors
Baron Schwartz is a software engineer who lives in Charlottesville, Virginia and goes by the online handle of "Xaprb," which is his first name typed in QWERTY on a Dvorak keyboard. When he's not busy solving a fun programming challenge, he relaxes with his wife Lynn and dog Carbon. He blogs about software engineering at http://www.xaprb.com/blog/. He's the consulting team lead at Percona (MySQL and full-stack application performance consulting group) and a popular speaker.

A former manager of the High Performace Group at MySQL AB, Peter Zaitsev now runs the mysqlperformanceblog.com site. He specializes in helping administrators fix issues with Web sites handling millions of visitors a day, dealing with terabytes of data using hundreds of servers. He is used to making changes and upgrades both to hardware to software (such as query optimization) in order to find solutions. He also speaks frequently at conferences.

Vadim Tkachenko was a Performance Engineer in at MySQL AB. As an expert in multithreaded programming and synchronization, his primary tasks were benchmarks, profiling, and finding bottlenecks. He also worked on a number of features for performance monitoring and tuning, and getting MySQL to scale well on multiple CPUs.

Jeremy Zawodny and his two cats moved from Northwest Ohio to Silicon Valley in late 1999 so he could work for Yahoo!--just in time to witness the .com bubble bursting first-hand. He's been at Yahoo! ever since, helping to put MySQL and other Open Source technologies to use in fun, interesting, and often very big ways. Starting with the popular and high-traffic Yahoo! Finance site, he worked to make MySQL part of the site's core infrastructure in large batch operations as well as real-time feed processing and serving content directly on the site. He then helped to spread "the MySQL religion" to numerous other groups within Yahoo!, including News, Personals, Sports, and Shopping. Nowadays he acts as Yahoo!'s MySQL guru, working with Yahoo!'s many engineering groups to get the most out of their MySQL deployments.

Customer Reviews : High Performance MySQL, 2nd Edition

Average Customer Review:   (1 Customer Reviews)     Read all 1 reviews |

Showing 1- 1 of 1 reviews ...

High Performance MySQL - A gripping guide  
By jagadish, 17/09/2009 09:28:11

This book by Baron SchwartzPeter et al is indeed a good read, especially if you are in the Computer Science field. The book is essentially an ideal guide to construct fast and reliable systems with central focus on robustness, security and data integration.

MySQL is the world's most popular open source database software having over 100 million copies distributed throughout its history. Equipped with superior speed, consistency, and user friendly options, MySQL is indeed the preferred choice for Web, Web 2.0, SaaS, ISV and major Telecom companies across the globe. That`s not all, a majority of forward-thinking corporate IT Managers find it to be extremely useful as it eliminates the major problems that are associated with downtime, administration and maintenance.

The ingenuity of the book doesn't end at that, as it delves deeper into the subject and teaches advanced techniques, enabling readers to be able to bring out MySQL's optimum power. The book has a thorough emphasis on performance and reliability. It teaches the users to design schemas, indexes and queries in an impeccable fashion. I have found this book to be very useful to scale applications with high precision replication and load balancing. This is the second edition and I must say is more comprehensive and completely revised with extensive coverage in all areas.

I would certainly recommend this book to my colleagues and trainees as I have found this to be an immensely resourceful and highly accurate guide.

Review posted for High Performance MySQL, 2nd Edition   |   Login to rate this review.

Average Customer Review:   (1 Customer Reviews)     Read all 1 reviews |

Discussion : High Performance MySQL, 2nd Edition