< Day Day Up >

•	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

		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

< Day Day Up >