Book description
The authoritative, hands-on guide to advanced MySQL programming and administration techniques for high performance is here. MySQL Database Design and Tuning is the only guide with coverage of both the basics and advanced topics, including reliability, performance, optimization and tuning for MySQL. This clear, concise and unique source for the most reliable MySQL performance information will show you how to:
Deploy the right MySQL product for your performance needs.
Set up a performance management and monitoring environment using tools from MySQL.
Implement the right indexing strategy
Apply good performance strategy when developing software to work with the MySQL database.
Configure dozens of variable to correctly tune the MySQL engine.
If you deal with the intricacies and challenges of advanced MySQL functionality on a daily basis, you will be able to build on your knowledge with author Robert Schneider's real-world experiences in MySQL Database Design and Tuning.
Table of contents
- Title Page
- Copyright Page
- Dedication
- About the Author
- Acknowledgments
- Contents
- We Want to Hear from You!
- Introduction: The Purpose of This Book
- Part I. Introduction
- 1. Setting Up an Optimization Environment
- 2. Performance Monitoring Options
- 3. MySQL Overview and New Performance-Related Features
- Part II. Advanced Database Design Concepts
- 4. Designing for Speed
- 5. Using Constraints to Improve Performance
- 6. Understanding the MySQL Optimizer
- 7. Indexing Strategies
- Part III. Optimizing Application Code
- 8. Advanced SQL Tips
- 9. Developing High-Speed Applications
- Part IV. Optimizing and Tuning the MySQL Engine
- 10. General Server Performance Parameters and Tuning
- 11. MyISAM Performance Enhancement
- 12. InnoDB Performance Enhancement
- 13. Improving Disk Speed
- 14. Operating System, Web Server, and Connectivity Tuning
- 15. Improving Import and Export Operations
- Part V. Distributed Computing
- 16. Optimal Replication
- 17. Optimal Clustering
- Part VI. Case Studies
- 18. Case Study: High-Hat Delivers!
- 19. Case Study: Friends Fly Free-for-All—A Promotion Gone Wrong
- 20. Case Study 3: Practice Makes Perfect
- Index
Product information
- Title: MySQL® Database Design and Tuning
- Author(s):
- Release date: June 2005
- Publisher(s): Sams
- ISBN: None
You might also like
book
Managing & Using MySQL, 2nd Edition
MySQL is a popular and robust open source database product that supports key subsets of SQL …
article
Run Llama-2 Models Locally with llama.cpp
Llama is Meta’s answer to the growing demand for LLMs. Unlike its well-known technological relative, ChatGPT, …
book
MySQL High Availability
Server bottlenecks and failures are a fact of life in any database deployment, but they don't …
article
Detect Fraud Using Isolation Forest
These shortcuts delve into generative AI, where algorithms and models create synthetic data, detect anomalies, and …
