High Performance MySQL, 3rd Edition
Optimization, Backups, and Replication
Publisher: O'Reilly Media
Final Release Date: 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
 
4.6

(based on 8 reviews)

Ratings Distribution

  • 5 Stars

     

    (6)

  • 4 Stars

     

    (1)

  • 3 Stars

     

    (1)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

100%

of respondents would recommend this to a friend.

Pros

  • Accurate (4)
  • Helpful examples (4)
  • Well-written (4)
  • Concise (3)

Cons

    Best Uses

    • Expert (5)
    • Intermediate (5)
      • Reviewer Profile:
      • Developer (5), Sys admin (3)

    Reviewed by 8 customers

    Sort by

    Displaying reviews 1-8

    Back to top

     
    4.0

    You can do much more with MySQL

    By Francisco Avendaño

    from Santiago,Chile

    Verified Buyer

    Comments about oreilly High Performance MySQL, 3rd Edition:

    Change the way you think in mysql, not only installing and connecting applications.

    (0 of 1 customers found this review helpful)

     
    3.0

    too much promotional content

    By MD

    from Queens, NY

    Comments about oreilly High Performance MySQL, 3rd Edition:

    I understand that the author wants to promote his company, but still that shouldn't take such a prominent place in a book that claims to be technical.

     
    5.0

    Excellent

    By mkalioby

    from Egypt

    About Me Developer, Sys Admin

    Verified Reviewer

    Pros

    • Accurate
    • Concise
    • Different Mysql Ver
    • Differ Mysql Versions
    • Easy to understand
    • Helpful examples
    • Well-written

    Cons

      Best Uses

      • Expert
      • Intermediate

      Comments about oreilly High Performance MySQL, 3rd Edition:

      Comprehensive guide for server tuning

       
      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

          Very good - a lot of detailed examples !

          By BluesBrother

          from Frankfurt/Germany

          Verified Buyer

          Pros

          • Accurate
          • Concise
          • Helpful examples
          • Well-written

          Cons

            Best Uses

            • Expert
            • Intermediate

            Comments about oreilly High Performance MySQL, 3rd Edition:

            - very real examples
            - good hints for any possible traps

             
            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-8

                      Back to top

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