O’Reilly Verlag

• 
  • Weitere Informationen zu diesem Buch:

    Inhaltsverzeichnis | Index | Probekapitel | Kolophon | Rezensionen |
    

	
Preface 

1. Back To Basics

      Binary Versus Compiled-From-Source Installations 

      Configuration Files 

      The SHOW Commands 

2. Storage Engines (Table Types)

      MySQL Architecture 

      Locking and Concurrency 

      Transactions 

      Selecting the Right Engine 

      The Storage Engines 

3. Benchmarking

      The Importance of Benchmarking 

      Benchmarking Strategies 

      Benchmarking Tools 

4. Indexes

      Indexing Basics 

      Index Structures 

      Indexes and Table Types 

      Index Maintenance 

5. Query Performance

      Query Processing Basics 

      Optimizer Features and Oddities 

      Identifying Slow Queries 

      Influencing MySQL with Hints 

      Stupid Query Tricks 

6. Server Performance Tuning

      Performance-Limiting Factors 

      RAID 

      Operating System 

      Techniques 

7. Replication

      Replication Overview 

      Configuring Replication 

      Under the Hood 

      Replication Architectures 

      Administration and Maintenance 

      Common Problems 

      The Future of Replication 

8. Load Balancing and High Availability

      Load Balancing Basics 

      Configuration Issues 

      Cluster Partitioning 

      High Availability 

9. Backup and Recovery

      Why Backups? 

      Considerations and Tradeoffs 

      Tools and Techniques 

      Rolling Your Own Backup Script 

10. Security

      Account Basics 

      The Grant Tables 

      Grant and Revoke 

      Operating System Security 

      Network Security 

      Data Encryption 

      MySQL in a chrooted Environment 

A. The SHOW STATUS and SHOW INNODB STATUS Commands

B. mytop

C. phpMyAdmin

Index