Flylib.com
MySQL Database Design and Tuning
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
MySQL Database Design and Tuning
ISBN: 0672327651
EAN: 2147483647
Year: 2005
Pages: 131
Authors:
Robert D Schneider
BUY ON AMAZON
Software Configuration Management
A Practical Approach to Documentation and Configuration Status Accounting
A Practical Approach to Configuration Verification and Audit
Appendix I System Service Request
Appendix N Corrective Action Processing (CAP)
Appendix V Functional Configuration Audit (FCA) Checklist
Adobe After Effects 7.0 Studio Techniques
Selections: The Key to Compositing
Blue-Screen and Green-Screen Keying
The Essentials
Conclusion
Wind
C & Data Structures (Charles River Media Computer Engineering)
Function
Trees
Problems in Stacks and Queues
Problems in Strings
Problems in Graphs
Introducing Microsoft ASP.NET AJAX (Pro - Developer)
The Pulsing Heart of ASP.NET AJAX
Partial Page Rendering
Built-in Application Services
Remote Method Calls with ASP.NET AJAX
Building AJAX Applications with ASP.NET
Junos Cookbook (Cookbooks (OReilly))
Setting the Routers Source Address
Using VRRP on Ethernet Interfaces
Dealing with Nonconfigurable Interfaces
Routing Policy and Firewall Filters
Setting Up a PIM-SM Bootstrap Router
Cultural Imperative: Global Trends in the 21st Century
Culture and Religion
Cultural Spectacles
Americanization versus Asianization
Culture and Globalization
Empires Past, Present, and Future
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies