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

(based on 9 reviews)

Ratings Distribution

  • 5 Stars

     

    (7)

  • 4 Stars

     

    (1)

  • 3 Stars

     

    (1)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

100%

of respondents would recommend this to a friend.

Pros

  • Accurate (5)
  • Helpful examples (5)
  • Well-written (5)
  • Concise (4)
  • Easy to understand (3)

Cons

    Best Uses

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

    Reviewed by 9 customers

    Sort by

    Displaying reviews 1-9

    Back to top

     
    5.0

    My Go To

    By Carmen

    from Raleigh, NC

    About Me DBA

    Verified Reviewer

    Pros

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

    Cons

      Best Uses

      • Expert
      • Intermediate
      • Novice
      • Student

      Comments about oreilly High Performance MySQL, 3rd Edition:

      I use this book on a daily basis. It's easy to reference, and is clearly written. There are good examples in the book.

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

                        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