High Performance MySQL

最新推荐文章于 2024-11-25 10:12:11 发布

原创最新推荐文章于 2024-11-25 10:12:11 发布 · 494 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#performance #benchmarking #optimization #mysql #scalability #tools

MySql 专栏收录该内容

36 篇文章

订阅专栏

本书由资深MySQL专家Jeremy Zawodny撰写，深入探讨了MySQL的可靠性、可扩展性和性能优化等关键议题。内容覆盖了索引优化、复制、负载均衡、备份与恢复等实用策略，并介绍了高级配置技巧及基准测试方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

As users come to depend on MySQL, they find that they have to deal with issues of reliability, scalability, and performance--issues that are not well documented but are critical to a smoothly functioning site. This book is an insider's guide to these little understood topics. Author Jeremy Zawodny has managed large numbers of MySQL servers for mission-critical work at Yahoo!, maintained years of contacts with the MySQL AB team, and presents regularly at conferences. Jeremy and Derek have spent months experimenting, interviewing major users of MySQL, talking to MySQL AB, benchmarking, and writing some of their own tools in order to produce the information in this book. In High Performance MySQL you will learn about MySQL indexing and optimization in depth so you can make better use of these key features. You will learn practical replication, backup, and load-balancing strategies with information that goes beyond available tools to discuss their effects in real-life environments. And you'll learn the supporting techniques you need to carry out these tasks, including advanced configuration, benchmarking, and investigating logs. Topics include:

*A review of configuration and setup options
*Storage engines and table types
*Benchmarking
*Indexes
*Query Optimization
*Application Design
*Server Performance
*Replication
*Load-balancing
*Backup and Recovery
*Security

http://rapidshare.com/files/51556836/0596003064.zip