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
SQL Tips & Techniques (Miscellaneous)
Using SQL Data Definition Language (DDL) to Create Data Tables and Other Database Objects
Understanding SQL Transactions and Transaction Logs
Working with SQL JOIN Statements and Other Multiple-table Queries
Understanding SQL Subqueries
Working with SQL Database Data Across the Internet
The CISSP and CAP Prep Guide: Platinum Edition
Access Control
Telecommunications and Network Security
Cryptography
The Accreditation Phase
Continuous Monitoring Process
C++ GUI Programming with Qt 3
Dynamic Dialogs
Creating Main Windows
QString and QVariant
UDP Networking with QSocketDevice
XML
Twisted Network Programming Essentials
Web Servers
Sharing Web Services with SOAP
Sending Mail Using SMTP
Listing Mailboxes on an IMAP Server
Setting Up a Custom SSH Server
Professional Struts Applications: Building Web Sites with Struts ObjectRelational Bridge, Lucene, and Velocity (Experts Voice)
Creating a Struts-based MVC Application
Form Presentation and Validation with Struts
Managing Business Logic with Struts
Creating a Search Engine with Lucene
Building the JavaEdge Application with Ant and Anthill
InDesign Type: Professional Typography with Adobe InDesign CS2
Using Placeholder Text
The Glyphs Palette
Working with Table Cells
Text Wraps: The Good, the Bad, and the Ugly
Vertical (Stacked) Alignment
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