Description:

The authoritative, hands-on guide to advanced MySQL programming and administration techniques for high performance is here. MySQL Performance Optimization is the only guide with coverage of both the basics and advanced topics, including reliability, performance, optimization and tuning for MySQL. This clear, concise and unique source for the most reliable MySQL performance information will show you how to:

• Deploy the right MySQL product for your performance needs.
• Set up a performance management and monitoring environment using tools from MySQL.
• Implement the right indexing strategy
• Apply good performance strategy when developing software to work with the MySQL database.
• Configure dozens of variable to correctly tune the MySQL engine.

If you deal with the intricacies and challenges of advanced MySQL functionality on a daily basis, you will be able to build on your knowledge with author Robert Schneider's real-world experiences in MySQL Performance Optimization.

 

Table of Contents:

The Purpose of This Book.

    Who Should Read This Book?

    Benefits of Using This Book

    How to Use This Book

    Information About MySQL Software and Environments

    Information About Examples

I. INTRODUCTION.

1. Setting Up an Optimization Environment.

    Pretesting Preparation

    Hardware

    Connectivity

    Software

    Data

    Your Test Plan

    Change One Variable at a Time

    Organizational Support

    After Testing Is Under Way

    Posttesting Implementation

    Recording Your Results

    Making Improvements

2. Performance Monitoring Options.

    MySQL Tools and Utilities

    Character-Based Tools and Utilities

    Graphical Tools

    Logging

    Operating System Tools

    Windows

    Linux/Unix

3. MySQL Overview and New Performance-Related Features.

    MySQL Products

    MySQL Core Technologies

    Database Storage Engines and Table Types

    Distributed Computing Technologies

    Graphical Tools and Assistants

    Connectors

    APIs

    Utilities