Memorial Day Sale: May 12-27
Buy new:
-50% $32.19 ($24.82 / kg)
$8.11 delivery May 20 - 23 to Nashville 37217
Ships from: UPICK MARKETING LLC
Sold by: UPICK MARKETING LLC
$32.19 with 50 percent savings $24.82 per kg
List Price: $64.99
FREE Returns
$8.11 delivery May 20 - 23 to Nashville 37217. Details
Or fastest delivery Wednesday, May 14. Order within 5 hrs 20 mins. Details
Only 1 left in stock - order soon.
$$32.19 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$32.19
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Ships from
UPICK MARKETING LLC
UPICK MARKETING LLC
Ships from
UPICK MARKETING LLC
Returns
30-day refund/replacement
30-day refund/replacement
This item can be returned in its original condition for a full refund or replacement within 30 days of receipt. You may receive a partial or no refund on used, damaged or materially different returns.
Read full return policy
Payment
Secure transaction
Your transaction is secure
We work hard to protect your security and privacy. Our payment security system encrypts your information during transmission. We don’t share your credit card details with third-party sellers, and we don’t sell your information to others. Learn more
$6.00 $4.63 per kg
Get Fast, Free Shipping with Amazon Prime FREE Returns
FREE delivery Saturday, May 17 to Nashville 37217 on orders shipped by Amazon over $35
Or Prime members get FREE delivery Thursday, May 15.
Only 1 left in stock - order soon.
$$32.19 () Includes selected options. Includes initial monthly payment and selected options. Details
Price
Subtotal
$$32.19
Subtotal
Initial payment breakdown
Shipping cost, delivery date, and order total (including tax) shown at checkout.
Access codes and supplements are not guaranteed with used items.
Kindle app logo image

Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.

Read instantly on your browser with Kindle for Web.

Using your mobile phone camera - scan the code below and download the Kindle app.

QR code to download the Kindle App

Follow the authors

Baron Schwartz
Follow
Baron Schwartz
Follow
Something went wrong. Please try your request again later.

High Performance MySQL: Optimization, Backups, and Replication 3rd Edition

by Baron Schwartz (Author), Peter Zaitsev (Author), Vadim Tkachenko (Author)
4.6 out of 5 stars 147 ratings
{"desktop_buybox_group_1":[{"displayPrice":"$32.19","priceAmount":32.19,"currencySymbol":"$","integerValue":"32","decimalSeparator":".","fractionalValue":"19","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"K6f9C2QjMtddSLQG7BOcsTV3qOcPRLsCfxZ1ibKe9suRdQIejQST1MxXFyTsbPtarx4TFOnR5aerq668h%2BVVgoxRs%2FecyTl%2B4N%2FgPCrhVlS7R7PCBn45VnARvWa79NErz1H2ny3JDRs47Kb1EbIEGBJQFTnGlt5fNjlGlChP9hRIm60uYV7QihY6PnSbhpKJ","locale":"en-US","buyingOptionType":"NEW","aapiBuyingOptionIndex":0}, {"displayPrice":"$6.00","priceAmount":6.00,"currencySymbol":"$","integerValue":"6","decimalSeparator":".","fractionalValue":"00","symbolPosition":"left","hasSpace":false,"showFractionalPartIfEmpty":true,"offerListingId":"K6f9C2QjMtddSLQG7BOcsTV3qOcPRLsCZAMwq1q0kXfV4hWvxgDFkdVnuDPQBGB7JBpDgHgW0maFy%2FBYFjSll6wEDM6bJGFTC14lv0QBvvRbMCGfBhIMZVysqQEPRR1RGobhluQVMkTsKqFCKCAdLdcE8t9UTQYb6CqmsyKMMUec6fX9eqcafcTI6SjOFVz0","locale":"en-US","buyingOptionType":"USED","aapiBuyingOptionIndex":1}]}

Purchase options and add-ons

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

Read more
Previous slide of product details
  1. ISBN-10
    1449314287
  2. ISBN-13
    978-1449314286
  3. Edition
    3rd
  4. Publisher
    O'Reilly Media
  5. Publication date
    May 1, 2012
  6. Language
    English
  7. Dimensions
    7 x 1.72 x 9.19 inches
  8. Print length
    823 pages
Next slide of product details

There is a newer edition of this item:

High Performance MySQL: Proven Strategies for Operating at Scale
High Performance MySQL: Proven Strategies for Operating at Scale
$41.49
(47)
Only 10 left in stock (more on the way).

From the brand

Previous page

  2. Sharing the knowledge of experts

    O'Reilly's mission is to change the world by sharing the knowledge of innovators. For over 40 years, we've inspired companies and individuals to do new things (and do them better) by providing the skills and understanding that are necessary for success.

    Our customers are hungry to build the innovations that propel the world forward. And we help them do just that.

  3. Software Architecture: The Hard Parts: Modern Trade-Off Analyses for Distributed Architectures
    Machine Learning Design Patterns: Solutions to Common Challenges in Data Preparation, Model Build...
    Essential Math for Data Science: Take Control of Your Data with Fundamental Linear Algebra, Proba...
    Articulating Design Decisions: Communicate with Stakeholders, Keep Your Sanity, and Deliver the B...

    Your partner in learning

    Visit the Store

  4. Hands-On Machine Learning with Scikit-Learn, Keras, and TensorFlow: Concepts, Tools, and Techniqu...
    Hands-On Large Language Models: Language Understanding and Generation
    Designing Data-Intensive Applications: The Big Ideas Behind Reliable, Scalable, and Maintainable ...
    AI Engineering: Building Applications with Foundation Models

    Bestsellers

    Visit the Store

  5. Fundamentals of Software Architecture: An Engineering Approach
    Platform Engineering: A Guide for Technical, Product, and People Leaders
    Facilitating Software Architecture: Empowering Teams to Make Architectural Decisions
    Building Green Software: A Sustainable Approach to Software Development and Operations

    Software Development

    Visit the Store

  6. Fluent Python: Clear, Concise, and Effective Programming
    JavaScript: The Definitive Guide: Master the World's Most-Used Programming Language
    Learning Java: An Introduction to Real-World Programming with Java
    Programming Rust: Fast, Safe Systems Development

    Programming Languages

    Visit the Store

  7. Hands-On Machine Learning with Scikit-Learn, Keras, and TensorFlow: Concepts, Tools, and Techniqu...
    Designing Machine Learning Systems: An Iterative Process for Production-Ready Applications
    Hands-On Generative AI with Transformers and Diffusion Models
    Prompt Engineering for LLMs: The Art and Science of Building Large Language Model–Based Applications

    AI / Machine Learning

    Visit the Store

  8. Learning Data Science: Data Wrangling, Exploration, Visualization, and Modeling with Python
    Data Science from Scratch: First Principles with Python
    Essential Math for Data Science: Take Control of Your Data with Fundamental Linear Algebra, Proba...
    Data Science: The Hard Parts: Techniques for Excelling at Data Science

    Data Science

    Visit the Store

  9. Python for Data Analysis: Data Wrangling with pandas, NumPy, and Jupyter
    Database Internals: A Deep Dive into How Distributed Data Systems Work
    Fundamentals of Data Engineering: Plan and Build Robust Data Systems
    Learning Data Science: Data Wrangling, Exploration, Visualization, and Modeling with Python

    Data, Databases and more

    Visit the Store

  10. Building Microservices: Designing Fine-Grained Systems
    System Design on AWS: Building and Scaling Enterprise Solutions
    Cloud Native Infrastructure with Azure: Building and Managing Cloud Native Applications
    Hacking Kubernetes: Threat-Driven Analysis and Defense

    Cloud Services

    Visit the Store

  11. The Manager's Path: A Guide for Tech Leaders Navigating Growth and Change
    The Art of Leadership: Small Things, Done Well
    Laws of UX: Using Psychology to Design Better Products & Services
    Product Leadership: How Top Product Managers Launch Awesome Products and Build Successful Teams

    Business

    Visit the Store

  12. Financial Data Engineering: Design and Build Data-Driven Financial Products
    Deep Learning for Finance: Creating Machine & Deep Learning Models for Trading in Python
    Reinforcement Learning for Finance: A Python-Based Introduction
    Artificial Intelligence in Finance: A Python-Based Guide

    Finance

    Visit the Store

  13. Mastering Blockchain: Unlocking the Power of Cryptocurrencies, Smart Contracts, and Decentralized...
    Blockchain Tethered AI: Trackable, Traceable Artificial Intelligence and Machine Learning
    Programming Bitcoin: Learn How to Program Bitcoin from Scratch
    Mastering the Lightning Network: A Second Layer Blockchain Protocol for Instant Bitcoin Payments

    Blockchain / Cryptocurrency

    Visit the Store

  14. Security as Code: DevSecOps Patterns with AWS
    Inside Cyber Warfare: Mapping the Cyber Underworld
    Security Chaos Engineering: Sustaining Resilience in Software and Systems
    Container Security: Fundamental Technology Concepts that Protect Containerized Applications

    Security

    Visit the Store

  15. Arduino Cookbook: Recipes to Begin, Expand, and Enhance Your Projects
    SQL Cookbook: Query Solutions and Techniques for All SQL Users
    AWS Cookbook: Recipes for Success on AWS
    Web Accessibility Cookbook: Creating Inclusive Experiences

    Cookbooks

    Visit the Store

  16. Head First Java: A Brain-Friendly Guide
    Head First Software Architecture: A Learner's Guide to Architectural Thinking
    Head First Python: A Learner's Guide to the Fundamentals of Python Programming, A Brain-Friendly ...
    Head First Design Patterns: Building Extensible and Maintainable Object-Oriented Software 2nd Edi...

    Head First series

    Visit the Store

  17. 97 Things Every Engineering Manager Should Know: Collective Wisdom from the Experts
    97 Things Every Information Security Professional Should Know: Collective Wisdom from the Experts
    97 Things Every UX Practitioner Should Know: Collective Wisdom from the Experts
    97 Things Every Data Engineer Should Know: Collective Wisdom from the Experts

    97 Things series

    Visit the Store

  18. Running Lean: Iterate from Plan A to a Plan That Works
    Lean Analytics: Use Data to Build a Better Startup Faster
    Lean UX: Designing Great Products with Agile Teams
    Lean AI: How Innovative Startups Use Artificial Intelligence to Grow

    Lean series

    Visit the Store

Next page

Editorial Reviews

About the Author

Baron Schwartz is Chief Performance Architect at Percona. He creates tools 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 author on 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 Media; 3rd edition (May 1, 2012)
  • Language ‏ : ‎ English
  • Paperback ‏ : ‎ 823 pages
  • ISBN-10 ‏ : ‎ 1449314287
  • ISBN-13 ‏ : ‎ 978-1449314286
  • Item Weight ‏ : ‎ 3.07 pounds
  • Dimensions ‏ : ‎ 7 x 1.72 x 9.19 inches
  • Customer Reviews:
    4.6 out of 5 stars 147 ratings

About the authors

Follow authors to get new release updates, plus improved recommendations.
Previous page
  1. Baron Schwartz

    Baron Schwartz

    Brief content visible, double tap to read full content.
    Full content visible, double tap to read brief content.

    Discover more of the author’s books, see similar authors, read book recommendations and more.

    See more on the author's page
  2. Baron Schwartz

    Baron Schwartz

    Brief content visible, double tap to read full content.
    Full content visible, double tap to read brief content.

    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.

    See more on the author's page
Next page

Customer reviews

4.6 out of 5 stars
147 global ratings

Review this product

Share your thoughts with other customers
Write a customer review

Customers say

Customers find the book provides great information, with one noting it gives clear answers to complex questions. Moreover, the book is extremely well written for a technical book, and customers appreciate its organization. They consider it worth every penny, with one customer highlighting the outstanding value of chapters 5 and 6.

AI-generated from the text of customer reviews

Select to learn more

26 customers mention "Information quality"24 positive2 negative

Customers find the book provides great information and helps master MySQL knowledge, with one customer noting that the information is presented in an accessible way.

"...The authors guide you through understanding and not just provide platitudes...." Read more

"...extremely well written for a technical book, and targets its content at exactly the right level: toward people who have the MySQL basics down, but..." Read more

"...5 and 6 are of outstanding value to grok MySQL optimization and parsing subroutines...." Read more

"...The information is presented in a very accessible way though and if you are coming from another RDBMS or have a decent technical background and are..." Read more

25 customers mention "Readability"25 positive0 negative

Customers find the book extremely well written and easy to read, with one customer noting how the authors guide readers through understanding the material.

"...The authors guide you through understanding and not just provide platitudes...." Read more

"...It's well organized, extremely well written for a technical book, and targets its content at exactly the right level: toward people who have the..." Read more

"...Overall, great book, hope authors rush a 4th edition." Read more

"This book is amazing! It has saved me a couple times at work. Our systems are growing and we are running into performance issues...." Read more

4 customers mention "Organization"4 positive0 negative

Customers appreciate the organization of the book, with one customer noting its well-structured content and another highlighting its effective database design guidance.

"...It's well organized, extremely well written for a technical book, and targets its content at exactly the right level: toward people who have the..." Read more

"...The book is extremely well organized and more information has been added to every single chapter...." Read more

"...to understand important stuffs about MySQL administration, configs composition, profiling and benchmarks...." Read more

"I am new to MySQL. This book helped me to properly design a MySQL database with performance issues in mind...." Read more

3 customers mention "Value for money"3 positive0 negative

Customers find the book worth every penny, with one customer specifically highlighting the outstanding value of chapters 5 and 6.

"...2. Especially, chapter 5 and 6 are of outstanding value to grok MySQL optimization and parsing subroutines...." Read more

"...The new edition is well worth picking up, even if you have already read the 2nd edition cover-to-cover." Read more

"Worth every penny! This book is your best resource if you want to learn and/or master your MySQL knowledge." Read more

Top reviews from the United States

  • Adam Scott
    5.0 out of 5 stars Must read for making MySQL perform
    Reviewed in the United States on July 19, 2012
    Verified Purchase
    If you want to make MySQL perform well, understand the deeper underpinnings related to performance and some administrative tasks, there's a surprising amount of information in the text.

    The authors guide you through understanding and not just provide platitudes. They show you how to profile a server and use that to help you optimize (focused performance improvement vs. tuning -- implying random tweaking) your server and environment based on their experience. Their shared experience is more than worth the price of the book.

    They offer some tactics scattered throughout that may be really useful like Computing the Distance Between Points (used in mapping applications)), improving high volume counters using a counter table, and the fastest way to transfer large files.

    You need this if you want to optimize MySQL. (They cover Replication, Clustering, Sharding, Backup & Recovery, HA among many other topics as well.)

    11.8.2013 - Still very good. The authors provide deep insights. Must have.
    Helpful
     Report
  • MCT
    5.0 out of 5 stars Indispensable
    Reviewed in the United States on October 1, 2012
    Verified Purchase
    "High Performance MySQL" is required reading for anyone who needs to dig deeper than MySQL 101. It's well organized, extremely well written for a technical book, and targets its content at exactly the right level: toward people who have the MySQL basics down, but are looking to add to their understanding and knowledge of MySQL in order to tackle both everyday and more esoteric problems. The writers do an excellent job of explaining how everything is working and fitting together in the background, which has certainly given me a clearer picture of MySQL's architecture, which in turn provides a better basis for problem-solving. This book is full of practical tips that are clearly based in the real-world troubleshooting experience of the authors. Highly recommended.
    One person found this helpful
    Helpful
     Report
  • Nilendu Misra
    4.0 out of 5 stars Best Practitioners' Book on MySQL out there..
    Reviewed in the United States on June 17, 2017
    Verified Purchase
    I recently had to come up to speed with MySQL to solve some major scale issues and I relied heavily on this book. Very highly recommended for -

    1. This is a practitioner's book. e.g., when it covers "clustered table", it also explains why the secondary indexes on InnoDB tables will be wider than usual. Such similar references are across the book.

    2. Especially, chapter 5 and 6 are of outstanding value to grok MySQL optimization and parsing subroutines. Pair it with Charles Bell "Expert MySQL" to understand what optimizer actually does and how it is very different from other databases you have worked with (e.g., no hash join etc.)

    This would be a straight 5-stars if -

    3. It covered some of the newer features of MySQL 5.6 (or 5.7+)
    4. Be a little laconic in most, especially earlier, chapters. e.g., does it really need another 35 pages to go over "why and what you should tune"?
    5. Real-life use cases the top 1-percent of MySQL users who need to extract full juice out of it (e.g., handler interfaces).

    Overall, great book, hope authors rush a 4th edition.
    14 people found this helpful
    Helpful
     Report
  • Joshua Prunier
    5.0 out of 5 stars A must have for any MySQL DBA or developer!
    Reviewed in the United States on September 8, 2012
    Verified Purchase
    I am extremely pleased with my purchase of High Performance MySQL, 3rd edition. I own the 2nd edition and my company recently upgraded to 5.5 so getting the 3rd edition was a no brainer. The book is extremely well organized and more information has been added to every single chapter. The new chapter on MySQL in the cloud is a timely welcome addition. The section on solid stage storage is also an example of how the contents have been updated to reflect the latest technology and trends. The book is full of real world scenarios and solutions the folks at Percona have encountered over the years. They do a great job of noting where features and functionality differs between 5.5 and 5.1 and also make reference to known features coming in 5.6. The level of detail contained within is much deeper than you will find in the online documentation and the authors do a great job of making clear the circumstances where features, configurations, engines and hardware may help or hurt with your specific application.

    If you are brand new to MySQL this is probably not the right choice for you. The information is presented in a very accessible way though and if you are coming from another RDBMS or have a decent technical background and are committed to learning more MySQL, I recommend it highly. The book is definitely biased towards Linux which the authors admit in the foreward. But even if you are running a WAMP stack you will still find tons of useful information inside. I'm constantly pulling this book off my shelf to look up something real quick; either to confirm a thought or see if the experts have anything else to add on the subject. I can't wait for the 4th edition covering 5.6!
    Helpful
     Report
  • Zechariah Campbell
    5.0 out of 5 stars When StackOverflow can't help, this book will save you.
    Reviewed in the United States on November 10, 2016
    Verified Purchase
    This book is amazing! It has saved me a couple times at work. Our systems are growing and we are running into performance issues. We are hitting problems you just can't google. This book provides some amazing insight into how MySQL works which has helped us fix some pretty big production bugs quickly. Can't recommend this book highly enough. So far I've used it to better understand Indexing (which it does a great job explaining) and to understand what Deadlocks are and how they occur. I naturally search StackOverflow.com first, but when I wasn't satisfied with StackOverflow answers, I turned to this book and it doesn't disappoint. Very nice work.
    18 people found this helpful
    Helpful
     Report

Top reviews from other countries

Translate all reviews to English
  • メンマ
    5.0 out of 5 stars 英語で読む価値あり
    Reviewed in Japan on February 13, 2013
    Verified Purchase
    仕事でMySQL5.5を使用することになり、日本語版の発売までに１年以上かかりそうなので英語の勉強もかねて発売直後に購入をした。

    設定ファイルのチューニングの症が非常に役に立った、なんでMySQLの本体に付属する設定ファイルは内容があんなに古いんだろうか・・・

    ちょっと英語が難しいけれど、非常に参考になったので英語で読む価値ありだと思います。
    Report
  • Chetan Vashisht
    5.0 out of 5 stars Excellent reference book
    Reviewed in India on May 22, 2019
    Verified Purchase
    (1) Has a lot of useful information and well written
    (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.
    Report
  • Alex Dicianu
    5.0 out of 5 stars Great book for people who want to know more about mysql
    Reviewed in France on August 17, 2013
    Verified Purchase
    I've been a web developer for years, but I discovered new things I had no idea about in every chapter. If you want to really understand mysql I highly recommend this book.
    Report
  • Amazon Customer
    5.0 out of 5 stars Imprescindible
    Reviewed in Spain on September 22, 2014
    Verified Purchase
    Quizá el mejor libro de MySQL que haya leído nunca, tanto para seniors como para iniciados en la materia. Se nota que el autor no solo tiene un conocimiento muy avanzado en la materia sino también, y he aquí lo difícil, que lo sabe transmitir a un público muy amplio.
    Report
  • Stephane Grenier
    5.0 out of 5 stars Book title is a perfect match
    Reviewed in Canada on February 4, 2016
    Verified Purchase
    This book is specific to MySQL and how to get the absolute best performance out of it. There is a lot of information and you should definitely be reading this book if you plan on using MySQL in a production environment.
    Report