---

MySQL Database Design and Tuning

ISBN: 0672327651
EAN: 2147483647

Year: 2005
Pages: 131

Authors: Robert D Schneider

BUY ON AMAZON

• MySQL Database Design and Tuning
• MySQL Database Design and Tuning
• Copyright
• About the Author
• Acknowledgments
• We Want to Hear from You
• Introduction: The Purpose of This Book
• Who Should Read This Book?
• Benefits of Using This Book
• How to Use This Book
• Information About MySQL Software and Environments
• Information About Examples
• Part I: Introduction
• Chapter 1. Setting Up an Optimization Environment
• Pretesting Preparation
• After Testing Is Under Way
• Posttesting Implementation
• Chapter 2. Performance Monitoring Options
• MySQL Tools and Utilities
• Operating System Tools
• Chapter 3. MySQL Overview and New Performance-Related Features
• MySQL Products
• About the Versions Used for This Book
• Performance-Boosting Features from Version 4.0 Onward
• Part II: Advanced Database Design Concepts
• Chapter 4. Designing for Speed
• Choosing the Right Storage Engine and Table Type
• Optimizing Table Structure
• Using Views to Boost Performance
• When Not to Normalize
• Chapter 5. Using Constraints to Improve Performance
• UNIQUE Constraints
• PRIMARY KEY
• FOREIGN KEY
• DEFAULT and NOT NULL
• ENUM
• SET
• Chapter 6. Understanding the MySQL Optimizer
• What Is an Optimizer?
• Optimizer Diagnostics and Tuning
• Chapter 7. Indexing Strategies
• Index Key Terms and Concepts
• Index Reports and Utilities
• MyISAM Indexing Features
• InnoDB Indexing Features
• Indexing Scenarios
• Part III: Optimizing Application Code
• Chapter 8. Advanced SQL Tips
• Improving Searches
• Improving Data Modification
• Chapter 9. Developing High-Speed Applications
• Understanding Locking
• Optimal Transactions
• Stored Procedures and Functions
• Triggers
• Writing Efficient Application Code
• Part IV: Optimizing and Tuning the MySQL Engine
• Chapter 10. General Server Performance Parameters and Tuning
• Server Settings Scope
• Connectivity
• Memory Management
• Application Control
• User Resource Control
• Chapter 11. MyISAM Performance Enhancement
• Optimal Data Storage
• MyISAM and Memory
• Speeding MyISAM Operations
• Chapter 12. InnoDB Performance Enhancement
• InnoDB Storage Architecture and IO
• InnoDB and Memory
• InnoDB Operational Control
• Chapter 13. Improving Disk Speed
• General Suggestions
• MyISAM Suggestions
• InnoDB Suggestions
• Operating System-Specific Disk Suggestions
• Chapter 14. Operating System, Web Server, and Connectivity Tuning
• Operating System Considerations
• Web Server Performance Considerations
• Connectivity Tuning
• Chapter 15. Improving Import and Export Operations
• Speeding Data Exports
• Accelerating Data Loading
• Part V: Distributed Computing
• Chapter 16. Optimal Replication
• Introduction
• Creating a Replication Strategy
• High-Performance Replication
• Chapter 17. Optimal Clustering
• Introduction
• How Does Clustering Work?
• Is Clustering Right for You?
• Creating a Clustering Strategy
• Configuring MySQL Cluster for High Performance
• Part VI: Case Studies
• Chapter 18. Case Study: High-Hat Delivers
• Problem Queries
• Random Transaction Bottlenecks
• Implementing These Solutions
• Chapter 19. Case Study: Friends Fly Free-for-All-A Promotion Gone Wrong
• Server Availability
• Application and Transaction Issues
• Chapter 20. Case Study 3: Practice Makes Perfect
• Data Importing
• Clustering
• Stored Procedures
• 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