High Performance MySQL, 3rd Edition
Optimization, Backups, and Replication
Publisher: O'Reilly Media
Released: March 2012
Pages: 828

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
Table of Contents
Product Details
About the Author
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyHigh Performance MySQL, 3rd Edition
 
5.0

(based on 4 reviews)

Ratings Distribution

  • 5 Stars

     

    (4)

  • 4 Stars

     

    (0)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

100%

of respondents would recommend this to a friend.

Pros

    Cons

      Best Uses

      • Expert (3)
      • Intermediate (3)
        • Reviewer Profile:
        • Developer (4)

      Reviewed by 4 customers

      Sort by

      Displaying reviews 1-4

      Back to top

       
      5.0

      Very good book

      By Taras

      from Lviv, Ukraine

      About Me Developer, Sys Admin

      Verified Buyer

      Pros

        Cons

          Best Uses

          • Expert
          • Intermediate

          Comments about oreilly High Performance MySQL, 3rd Edition:

          Very good book

           
          5.0

          A must have reference book

          By Ivan Kuznetsov

          from Ingå, Finland

          About Me Developer, DevOps, Sys Admin

          Verified Reviewer

          Pros

          • Accurate
          • Helpful examples
          • Well-written

          Cons

            Best Uses

            • Expert
            • Intermediate

            Comments about oreilly High Performance MySQL, 3rd Edition:

            I have first-hand experience using second edition of this book, and I can say that it paid itself back many times over when I was debugging critical performance issues I came across in HeiaHeia.com operations. Now this third edition (published in 2012) covers also new features in MySQL version 5.5.

            (1 of 1 customers found this review helpful)

             
            5.0

            Amazing book

            By Martins Sipenko

            from Riga, Latvia

            About Me Developer

            Pros

              Cons

                Best Uses

                  Comments about oreilly High Performance MySQL, 3rd Edition:

                  Great book, I would suggest to read it for everyone who is in some way involved with MySQL.

                  (2 of 2 customers found this review helpful)

                   
                  5.0

                  How to think about MySQL

                  By vkats

                  from Greece

                  About Me Developer, Educator

                  Verified Reviewer

                  Pros

                  • Accurate
                  • Concise
                  • Easy to understand
                  • Helpful examples
                  • Well-written

                  Cons

                    Best Uses

                    • Expert
                    • Intermediate

                    Comments about oreilly High Performance MySQL, 3rd Edition:

                    The book's 3rd edition keeps up with the reputation of the last one. A must-read when someone wants to use MySQL efficiently in a high performance environment.

                    The books is for the MySQL DBA who wants to optimize their DB infrastructure and application, and manage the challenges that appear when the workload increases. However, the book is also useful to developers who want to have a good understanding of the way MySQL works.

                    The success of the book stems from methodically approaching all the subjects it covers, with emphasis on 'methodically'. The text is not restricted to a list of recipes and hints & tips, but explains the reason why one should deal with certain subjects and the way they should be approached. This translates to setting questions for the application's requirements, and the proper way answers should be given. The book manages to cover the need for defining problems and giving solutions properly, but also has a refreshing educational character.

                    Topics include benchmarking και profiling (DB server and application), optimization (DB server, application, OS and hardware), replication, scaling, HA, backups and tools. Moreover, there is a chapter dedicated to an interesting discussion about the pros, cons and the cost of the "cloud" both in general and specifically for MySQL.

                    Displaying reviews 1-4

                    Back to top

                     
                    Buy 2 Get 1 Free Free Shipping Guarantee
                    Buying Options
                    Immediate Access - Go Digital what's this?
                    Ebook: $39.99
                    Formats:  ePub, Mobi, PDF
                    Print & Ebook: $54.99
                    Print: $49.99