High Performance MySQL, 2nd Edition
Optimization, Backups, Replication, and More
Publisher: O'Reilly Media
Final Release Date: June 2008
Pages: 712

High Performance MySQL is the definitive guide to building fast, reliable systems with MySQL. Written by noted experts with years of real-world experience building very large systems, this book covers every aspect of MySQL performance in detail, and focuses on robustness, security, and data integrity.

High Performance MySQL teaches you advanced techniques in depth so you can bring out MySQL's full power. Learn how to design schemas, indexes, queries and advanced MySQL features for maximum performance, and get detailed guidance for tuning your MySQL server, operating system, and hardware to their fullest potential. You'll also learn practical, safe, high-performance ways to scale your applications with replication, load balancing, high availability, and failover.

This second edition is completely revised and greatly expanded, with deeper coverage in all areas. Major additions include:

  • Emphasis throughout on both performance and reliability
  • Thorough coverage of storage engines, including in-depth tuning and optimizations for the InnoDB storage engine
  • Effects of new features in MySQL 5.0 and 5.1, including stored procedures, partitioned databases, triggers, and views
  • A detailed discussion on how to build very large, highly scalable systems with MySQL
  • New options for backups and replication
  • Optimization of advanced querying features, such as full-text searches
  • Four new appendices

The book also includes chapters on benchmarking, profiling, backups, security, and tools and techniques to help you measure, monitor, and manage your MySQL installations.

Table of Contents
Product Details
About the Author
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyHigh Performance MySQL, 2nd Edition
 
5.0

(based on 6 reviews)

Ratings Distribution

  • 5 Stars

     

    (6)

  • 4 Stars

     

    (0)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

100%

of respondents would recommend this to a friend.

Pros

  • Helpful examples (3)
  • Well-written (3)

Cons

    Best Uses

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

    Reviewed by 6 customers

    Sort by

    Displaying reviews 1-6

    Back to top

     
    5.0

    The best book on the subject

    By za_bullet

    from South Africa

    About Me Developer, Sys Admin

    Pros

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

    Cons

      Best Uses

      • Expert
      • Intermediate

      Comments about oreilly High Performance MySQL, 2nd Edition:

      Possibly the only book on the subject. I would recommend this book to any DBAs or Developers who really want to get to know the ins and outs of MySQL. It is a great book for learning as well as a great reference book.

       
      5.0

      Quite good

      By dano

      from Sweden

      About Me Developer, Sys Admin

      Verified Reviewer

      Pros

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

      Cons

        Best Uses

        • Expert
        • Intermediate

        Comments about oreilly High Performance MySQL, 2nd Edition:

        This is a very good book. If you use MySQL, get it.

        (1 of 2 customers found this review helpful)

         
        5.0

        very recommended book

        By ^MadDog^

        from Rishon Leziyon, ISRAEL

        About Me Developer, Sys Admin

        Verified Reviewer

        Pros

        • Concise
        • Helpful examples
        • Well-written

        Cons

          Best Uses

          • Expert
          • Intermediate

          Comments about oreilly High Performance MySQL, 2nd Edition:

          As a hosting provider and sysadmin, I received so much please and positive information from this book. It make you feel like you jumped to a higher grade of your knowledge.

          (5 of 5 customers found this review helpful)

           
          5.0

          Tells the why you would do x, not just the syntax

          By Anonymous

          from Undisclosed

          Comments about oreilly High Performance MySQL, 2nd Edition:

          What makes this book so much better than any others I've seen in the last 8 years is its focus on the why, rather than the how. Certainly it will tell you some hows as well, but it always keeps focused on the priorities you should have in mind. Simple example: it quotes an AB trainer saying that the best you can improve performance of your queries with hardware is about 10x. On the other hand, you can often improve it 1000x by optimizing your queries. That is the kind of thing you can tell to your boss and have her understand.

          I do not mean that there are not a truckload of hows as well in this book - How to set up some benchmarking, major reasons you would pick MyISAM or Innodb, what you can mix and match etc. But the examples always serve their major points.

          I will never be a DBA, but this book is all I need to fake it.

          (1 of 2 customers found this review helpful)

           
          5.0

          this book is the best way to

          By Anonymous

          from Undisclosed

          Comments about oreilly High Performance MySQL, 2nd Edition:

          this book is the best way to learn how to get a high performance on mysql,i love it very much.

          (1 of 1 customers found this review helpful)

           
          5.0

          Best book this year

          By james ransom

          from Undisclosed

          Comments about oreilly High Performance MySQL, 2nd Edition:

          This is the best book of the year. If you run a major site on mysql this

          is your new bible. This book covers what you need to know about

          partitioning, scaling, and taking mysql to the fullest.

          I was eager to jump the replication sections. Its one of the most complex

          topics in mysql and this book was able to break it down.

          I have met one of the authors at a php meetup. To be honest, they are the most respected in the industry.

          Why couldn't I get this version years ago?

          Displaying reviews 1-6

          Back to top

           
          Buy 2 Get 1 Free Free Shipping Guarantee
          Buying Options
          Immediate Access - Go Digital what's this?

          Available in Multiple Languages