High Performance MySQL [Electronic resources]

Sitemap

High Performance MySQL

Table of Contents

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

1.1 Binary Versus Compiled-From-Source Installations

1.2 Configuration Files

1.3 The SHOW Commands

Chapter 2. Storage Engines (Table Types)

2.1 MySQL Architecture

2.2 Locking and Concurrency

2.3 Transactions

2.4 Selecting the Right Engine

2.5 The Storage Engines

Chapter 3. Benchmarking

3.1 The Importance of Benchmarking

3.2 Benchmarking Strategies

3.3 Benchmarking Tools

Chapter 4. Indexes

4.1 Indexing Basics

4.2 Index Structures

4.3 Indexes and Table Types

4.4 Index Maintenance

Chapter 5. Query Performance

5.1 Query Processing Basics

5.2 Optimizer Features and Oddities

5.3 Identifying Slow Queries

5.4 Influencing MySQL with Hints

5.5 Stupid Query Tricks

Chapter 6. Server Performance Tuning

6.1 Performance-Limiting Factors

6.2 RAID

6.3 Operating System

6.4 Techniques

Chapter 7. Replication

7.1 Replication Overview

7.2 Configuring Replication

7.3 Under the Hood

7.4 Replication Architectures

7.5 Administration and Maintenance

7.6 Common Problems

7.7 The Future of Replication

Chapter 8. Load Balancing and High Availability

8.1 Load Balancing Basics

8.2 Configuration Issues

8.3 Cluster Partitioning

8.4 High Availability

Chapter 9. Backup and Recovery

9.1 Why Backups?

9.2 Considerations and Tradeoffs

9.3 Tools and Techniques

9.4 Rolling Your Own Backup Script

Chapter 10. Security

10.1 Account Basics

10.2 The Grant Tables

10.3 Grant and Revoke

10.4 Operating System Security

10.5 Network Security

10.6 Data Encryption

10.7 MySQL in a chrooted Environment

Appendix A. The SHOW STATUS and SHOW INNODB STATUS Commands

A.1 SHOW STATUS

A.2 SHOW INNODB STATUS

Appendix B. mytop

B.1 Overview

B.2 Getting mytop

B.3 Configuration and Usage

B.4 Common Tasks

Appendix C. phpMyAdmin

C.1 The Basics

C.2 Practical Examples

Colophon

Index

index_SYMBOL

index_A

index_B

index_C

index_D

index_E

index_F

index_G

index_H

index_I

index_J

index_K

index_L

index_M

index_N

index_O

index_P

index_Q

index_R

index_S

index_T

index_U

index_V

index_W

index_X