Efficient MySQL Performance: Best Practices and Techniques

iebukes O'Reilly 40 次浏览 没有评论
Efficient MySQL Performance: Best Practices and Techniques Front Cover

Efficient MySQL Performance: Best Practices and Techniques

by Daniel Nichter
  • Length: 350 pages
  • Edition: 1
  • Publisher: O’Reilly Media
  • Publication Date: 2022-01-17
  • ISBN-10: 1098105095
  • ISBN-13: 9781098105099
  • Sales Rank: #761059 (See Top 100 Books)
Description

You’ll find several books on MySQL basics today, but only one that covers advanced MySQL performance–and nothing in between. That’s because explaining MySQL performance without addressing its complexity is difficult. This practical book bridges the gap by teaching developers mid-level MySQL knowledge beyond the fundamentals, but well shy of deep-level internals required by DBAs.

Daniel Nichter shows you how to apply best practices and techniques that directly affect efficient MySQL performance. You’ll learn how to focus on query response time, optimize queries and data to increase performance, and monitor and understand the most important MySQL metrics. You’ll also discover how not to use MySQL, including situations where this database is clearly the wrong choice.

  • Understand why query response time is the North Star of MySQL performance
  • Learn why indexing, not hardware or MySQL config, is the key to performance
  • Examine query metrics in detail, including aggregation, reporting, and analysis
  • Explore ways of improving query response time through query optimization
  • Understand how to monitor MySQL and learn what the metrics mean

Efficient MySQL Performance: Best Practices and Techniques

 
 扫描二维码,关注微信公众号,发送“FWMM”获取下载访问密码,关注我,永不迷路  
                微信公众号二维码