MySQL Database Design and Tuning
MySQL Database Design and Tuning
ISBN: 0672327651
EAN: 2147483647
EAN: 2147483647
Year: 2005
Pages: 131
Pages: 131
Authors: Robert D Schneider
- 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
MySQL Database Design and Tuning
ISBN: 0672327651
EAN: 2147483647
EAN: 2147483647
Year: 2005
Pages: 131
Pages: 131
Authors: Robert D Schneider