Chapter 8. Performance Tuning

In this chapter, we will cover:

  • Tuning the Linux kernel IO
  • Tuning the Linux kernel CPU schedulers
  • Tuning MySQL Cluster storage nodes
  • Tuning MySQL Cluster SQL nodes
  • Tuning queries within a MySQL Cluster
  • Tuning GFS on shared storage
  • MySQL Replication tuning

Introduction

In this chapter, we will cover performance tuning techniques applicable to RedHat and CentOS 5 servers that are used with any of the high-availability techniques covered so far in this book. Some of the techniques in this chapter will only work with some high-availability methods (for example, the "MySQL Cluster" recipes are MySQL Cluster-specific), and some will work on pretty much any Linux server (for example, the discussion of the Linux kernel IO and CPU ...

Get High Availability MySQL Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.