MySQL database design and tuning

Format:

Book

Author/Creator:

Schneider, Robert D., Author.

Contributor:

Safari Tech Books Online.

Language:

English

Subjects (All):

MySQL (Electronic resource).

SQL (Computer program language).

Physical Description:

1 online resource (xvii, 414 p. ) ill. ;

Edition:

1st edition

Place of Publication:

[Place of publication not identified] MySQL Press 2005

Language Note:

English

System Details:

text file

Summary:

The authoritative, hands-on guide to advanced MySQL programming and administration techniques for high performance is here. MySQL Database Design and Tuning 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 Database Design and Tuning .

Contents:

Cover

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

PART I: Introduction

1 Setting Up an Optimization Environment

Pretesting Preparation

After Testing Is Under Way

Posttesting Implementation

2 Performance Monitoring Options

MySQL Tools and Utilities

Operating System Tools

3 MySQL Overview and New Performance-Related Features

MySQL Products

About the Versions Used for This Book

Performance-Boosting Features from Version 4.0 Onward

PART II: Advanced Database Design Concepts

4 Designing for Speed

Choosing the Right Storage Engine and Table Type

Optimizing Table Structure

Using Views to Boost Performance

When Not to Normalize

5 Using Constraints to Improve Performance

UNIQUE Constraints

PRIMARY KEY

FOREIGN KEY

DEFAULT and NOT NULL

ENUM

SET

6 Understanding the MySQL Optimizer

What Is an Optimizer?

Optimizer Diagnostics and Tuning

7 Indexing Strategies

Index Key Terms and Concepts

Index Reports and Utilities

MyISAM Indexing Features

InnoDB Indexing Features

Indexing Scenarios

PART III: Optimizing Application Code

8 Advanced SQL Tips

Improving Searches

Improving Data Modification

9 Developing High-Speed Applications

Understanding Locking

Optimal Transactions

Stored Procedures and Functions

Triggers

Writing Efficient Application Code

PART IV: Optimizing and Tuning the MySQL Engine

10 General Server Performance Parameters and Tuning

Server Settings Scope

Connectivity

Memory Management

Application Control

User Resource Control

11 MyISAM Performance Enhancement

Optimal Data Storage

MyISAM and Memory

Speeding MyISAM Operations.

12 InnoDB Performance Enhancement

InnoDB Storage Architecture and I/O

InnoDB and Memory

InnoDB Operational Control

13 Improving Disk Speed

General Suggestions

MyISAM Suggestions

InnoDB Suggestions

Operating System-Specific Disk Suggestions

14 Operating System, Web Server, and Connectivity Tuning

Operating System Considerations

Web Server Performance Considerations

Connectivity Tuning

15 Improving Import and Export Operations

Speeding Data Exports

Accelerating Data Loading

PART V: Distributed Computing

16 Optimal Replication

Introduction

Creating a Replication Strategy

High-Performance Replication

17 Optimal Clustering

How Does Clustering Work?

Is Clustering Right for You?

Creating a Clustering Strategy

Configuring MySQL Cluster for High Performance

PART VI: Case Studies

18 Case Study: High-Hat Delivers!

Problem Queries

Random Transaction Bottlenecks

Implementing These Solutions

19 Case Study: Friends Fly Free-for-All-A Promotion Gone Wrong

Server Availability

Application and Transaction Issues

20 Case Study 3: Practice Makes Perfect

Data Importing

Clustering

Stored Procedures

Index.

Notes:

Bibliographic Level Mode of Issuance: Monograph

Description based on publisher supplied metadata and other sources.

ISBN:

9786612648984

9780672332692

0672332698

9781282648982

1282648985

9780672332265

0672332264

OCLC:

1027199233