
Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet or computer – no Kindle device required. Learn more
Read instantly on your browser with Kindle for Web.
Using your mobile phone camera, scan the code below and download the Kindle app.

Follow the Authors
OK
High Performance MySQL 3e: Optimization, Backups, Replication, and More Paperback – 13 April 2012
Save Extra with 3 offers
10 days Replacement
Replacement Reason | Replacement Period | Replacement Policy |
---|---|---|
Physical Damage, Defective, Wrong and Missing Item | 10 days from delivery | Replacement |
Replacement Instructions

Read full returns policy
There is a newer edition of this item:
₹3,563.00
(32)
Only 2 left in stock.
Enhance your purchase
How can you bring out MySQL’s full power? With High Performance MySQL, you’ll learn advanced techniques for everything from designing schemas, indexes, and queries to tuning your MySQL server, operating system, and hardware to their fullest potential. This guide also teaches you safe and practical ways to scale applications through replication, load balancing, high availability, and failover.
Updated to reflect recent advances in MySQL and InnoDB performance, features, and tools, this third edition not only offers specific examples of how MySQL works, it also teaches you why this system works as it does, with illustrative stories and case studies that demonstrate MySQL’s principles in action. With this book, you’ll learn how to think in MySQL.
- Learn the effects of new features in MySQL 5.5, including stored procedures, partitioned databases, triggers, and views
- Implement improvements in replication, high availability, and clustering
- Achieve high performance when running MySQL in the cloud
- Optimize advanced querying features, such as full-text searches
- Take advantage of modern multi-core CPUs and solid-state disks
- Explore backup and recovery strategies—including new tools for hot online backups
- Print length828 pages
- LanguageEnglish
- PublisherO′Reilly
- Publication date13 April 2012
- Dimensions17.78 x 4.37 x 23.34 cm
- ISBN-101449314287
- ISBN-13978-1449314286
Customers who viewed this item also viewed
Special offers and product promotions
- 10% Instant Discount up to INR 500 on J&K Bank Card Transactions. Minimum purchase value INR 2000 Here's how
- 10% Instant Discount up to INR 500 on IDBI Bank Card Trxns. Min purchase value INR 2000 Here's how
- 5% Instant Discount up to INR 250 on HSBC Cashback Card Credit Card Transactions. Minimum purchase value INR 1000 Here's how
- No cost EMI available on select cards. Please check 'EMI options' above for more details. Here's how
- Get GST invoice and save up to 28% on business purchases. Sign up for free Here's how
Product description
Book Description
About the Author
Baron Schwartz is Chief Performance Architect at Percona. He createstools and techniques to make MySQL easier to use and more dependable,and speaks regularly at conferences worldwide. He lives in Virginia with his family.
Peter managed the High Performance Group within MySQL until 2006, when he founded Percona. Peter has a Master's Degree in Computer Science and is an expert in database kernels, computer hardware, and application scaling. He serves as CEO of Percona, while keeping touch with his technical roots by continuing to do consulting for key customers.
Vadim Tkachenko is the CTO and co-founder of Percona, and an authoron the MySQLPerformanceBlog.com and SSDPerformanceBlog.com blogs. Vadim leads Percona's development group, which produces the Percona Server, Percona XtraDB Cluster, and Percona XtraBackup.
Product details
- Publisher : O′Reilly; 3rd edition (13 April 2012)
- Language : English
- Paperback : 828 pages
- ISBN-10 : 1449314287
- ISBN-13 : 978-1449314286
- Item Weight : 1 kg 300 g
- Dimensions : 17.78 x 4.37 x 23.34 cm
- Best Sellers Rank: #400,240 in Books (See Top 100 in Books)
- #531 in Database Storage & Design
- #866 in Databases & Big Data
- #2,019 in Programming Languages (Books)
- Customer Reviews:
About the authors
Baron is a prominent MySQL performance expert, community leader, speaker, author, and software engineer. After earning a degree in Computer Science and spending several years as a software engineer, Baron grew and led Percona's consulting team and practice to international prominence, then founded VividCortex to give developers and operations teams deep visibility into the behavior and performance of production database systems. Although he is most recognized for his MySQL expertise, Baron understands and appreciates many types of databases, and participates actively in several database communities as a speaker and advocate, as evidenced by his Oracle ACE award among others.
Discover more of the author’s books, see similar authors, read author blogs and more
Customer reviews
-
Top reviews
Top reviews from India
There was a problem filtering reviews right now. Please try again later.
However, performance engineering applies to all areas of component collaboration. So, one needs to have expertise in those be it writing better algorithms, optimizing hotspots etc.,
(2) Even advanced concepts like replication and query optimization are dealt with quite well
(3) But it assumes that you are familiar with mysql, atleast basic commands like insertion, updation and altering tables.
Top reviews from other countries

It also has much useful information about backup and recovery techniques as well.
Although written in 2012 I have found it very useful with MySQL 5.6 and 5.7 although I expect some of the details of InnoDB have advanced since the book was written, and the chapter on Databases in the Cloud may be a little dated.
The book is written in a friendly conversational manner but does not hesitate from deep dives into the intricacies of InnoDB.

While some parts do require a number of visits before they 'sink in' and make sense, I have to say this book is ideal for sorting both the silly 'start up' database designer problems as well as being a potentially good reference for the more established database user. I say 'potentially' as I'm not an 'established database designer' so can only assume the books usefulness for such a person.
I have not completed the entire book, after all I see it as reference work, but what I have read has changed my view that making even the most basic database more efficient doesn't necessarily require massive effort.

Already been able to make some measured inprovements to systems we are running.

