Efficient MySQL Performance: Best Practices and Techniques

Nichter, Daniel

  • 出版商: O'Reilly
  • 出版日期: 2022-01-04
  • 定價: $2,100
  • 售價: 8.0$1,680
  • 語言: 英文
  • 頁數: 352
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1098105095
  • ISBN-13: 9781098105099
  • 相關分類: MySQLSQL
  • 立即出貨 (庫存 < 4)

買這商品的人也買了...

商品描述

You'll find several books on basic or advanced MySQL performance, but nothing in between. That's because explaining MySQL performance without addressing its complexity is difficult. This practical book bridges the gap by teaching software engineers mid-level MySQL knowledge beyond the fundamentals, but well shy of deep-level internals required by database administrators (DBAs).

Daniel Nichter shows you how to apply the best practices and techniques that directly affect MySQL performance. You'll learn how to improve performance by analyzing query execution, indexing for common SQL clauses and table joins, optimizing data access, and understanding the most important MySQL metrics. You'll also discover how replication, transactions, row locking, and the cloud influenceMySQL performance.

  • Understand why query response time is the North Star of MySQL performance
  • Learn query metrics in detail, including aggregation, reporting, and analysis
  • See how to index effectively for common SQL clauses and table joins
  • Explore the most important server metrics and what they reveal about performance
  • Dive into transactions and row locking to gain deep, actionable insight
  • Achieve remarkable MySQL performance at any scale

商品描述(中文翻譯)

你會發現有許多關於基礎或高級MySQL性能的書籍,但中間卻沒有什麼資料。這是因為在不解釋MySQL性能的複雜性的情況下,很難進行解釋。這本實用的書籍彌補了這一空白,教授軟體工程師超越基礎知識,但又不需要深入了解資料庫管理員(DBA)所需的內部知識的中級MySQL知識。

Daniel Nichter向您展示如何應用直接影響MySQL性能的最佳實踐和技術。您將學習通過分析查詢執行、為常見的SQL子句和表連接進行索引、優化數據訪問以及了解最重要的MySQL指標來提高性能。您還將了解複製、事務、行鎖定和雲端如何影響MySQL性能。

- 瞭解為什麼查詢響應時間是MySQL性能的重要指標
- 詳細了解查詢指標,包括聚合、報告和分析
- 看看如何有效地為常見的SQL子句和表連接進行索引
- 探索最重要的伺服器指標以及它們對性能的影響
- 深入研究事務和行鎖定,獲得深入且可操作的見解
- 在任何規模下實現卓越的MySQL性能

作者簡介

Daniel Nichter is a DBA with over 15 years of experience with MySQL. He started optimizing MySQL performance in 2004 while working in a data center. Soon after, he created HackMySQL.com to share information and tools about MySQL. Daniel is most known for the tools he published during his eight-year tenure at Percona, several of which remain the de-facto standard and in use at the largest tech companies in the world. He is also a MySQL Community Award winner, conference speaker, and wide-ranging open-source contributor. Daniel currently works as a platform engineer at Square, a fintech company with thousands of MySQL servers and hundreds of software engineers.

作者簡介(中文翻譯)

Daniel Nichter是一位擁有超過15年MySQL經驗的資料庫管理員。他在2004年開始優化MySQL性能,當時在一個數據中心工作。不久之後,他創建了HackMySQL.com,以分享關於MySQL的信息和工具。Daniel最著名的是他在Percona工作期間發布的工具,其中一些仍然是世界上最大科技公司使用的事實標準。他還是MySQL社區獎的獲獎者、會議演講者和廣泛的開源貢獻者。Daniel目前在Square擔任平台工程師,該公司擁有數千台MySQL服務器和數百名軟件工程師。