High Performance MySQL [Electronic resources] نسخه متنی

• Table of Contents

• Index

• Reviews

• Reader Reviews

• Errata

• Academic

High Performance MySQL

By
Derek J. Balling, Jeremy Zawodny

Publisher: OReilly

Pub Date: April 2004

ISBN: 0-596-00306-4

Pages: 294

Slots: 1.0

Copyright

Preface

The Basic Layout of This Book

Software Versions and Availability

Conventions Used in This Book

Using Code Examples

How to Contact Us

Acknowledgments

Chapter 1.
Back To Basics

Section 1.1.
Binary Versus Compiled-From-Source Installations

Section 1.2.
Configuration Files

Section 1.3.
The SHOW Commands

Chapter 2.
Storage Engines (Table Types)

Section 2.1.
MySQL Architecture

Section 2.2.
Locking and Concurrency

Section 2.3.
Transactions

Section 2.4.
Selecting the Right Engine

Section 2.5.
The Storage Engines

Chapter 3.
Benchmarking

Section 3.1.
The Importance of Benchmarking

Section 3.2.
Benchmarking Strategies

Section 3.3.
Benchmarking Tools

Chapter 4.
Indexes

Section 4.1.
Indexing Basics

Section 4.2.
Index Structures

Section 4.3.
Indexes and Table Types

Section 4.4.
Index Maintenance

Chapter 5.
Query Performance

Section 5.1.
Query Processing Basics

Section 5.2.
Optimizer Features and Oddities

Section 5.3.
Identifying Slow Queries

Section 5.4.
Influencing MySQL with Hints

Section 5.5.
Stupid Query Tricks

Chapter 6.
Server Performance Tuning

Section 6.1.
Performance-Limiting Factors

Section 6.2.
RAID

Section 6.3.
Operating System

Section 6.4.
Techniques

Chapter 7.
Replication

Section 7.1.
Replication Overview

Section 7.2.
Configuring Replication

Section 7.3.
Under the Hood

Section 7.4.
Replication Architectures

Section 7.5.
Administration and Maintenance

Section 7.6.
Common Problems

Section 7.7.
The Future of Replication

Chapter 8.
Load Balancing and High Availability

Section 8.1.
Load Balancing Basics

Section 8.2.
Configuration Issues

Section 8.3.
Cluster Partitioning

Section 8.4.
High Availability

Chapter 9.
Backup and Recovery

Section 9.1.
Why Backups?

Section 9.2.
Considerations and Tradeoffs

Section 9.3.
Tools and Techniques

Section 9.4.
Rolling Your Own Backup Script

Chapter 10.
Security

Section 10.1.
Account Basics

Section 10.2.
The Grant Tables

Section 10.3.
Grant and Revoke

Section 10.4.
Operating System Security

Section 10.5.
Network Security

Section 10.6.
Data Encryption

Section 10.7.
MySQL in a chrooted Environment

Appendix A.
The SHOW STATUS and SHOW INNODB STATUS Commands

Section A.1.
SHOW STATUS

Section A.2.
SHOW INNODB STATUS

Appendix B.
mytop

Section B.1.
Overview

Section B.2.
Getting mytop

Section B.3.
Configuration and Usage

Section B.4.
Common Tasks

Appendix C.
phpMyAdmin

Section C.1.
The Basics

Section C.2.
Practical Examples

Colophon

Index