Previous Section  < Day Day Up >  Next Section

• Table of Contents
• Index
• Reviews
• Reader Reviews
• Errata
• Academic
High Performance MySQL
By Derek J. Balling, Jeremy Zawodny
Publisher: O'Reilly
Pub Date: April 2004
ISBN: 0-596-00306-4
Pages: 294
Slots: 1.0   

      The Basic Layout of This Book
      Software Versions and Availability
      Conventions Used in This Book
      Using Code Examples
      How to Contact Us
      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
Previous Section  < Day Day Up >  Next Section