High Performance MySQL (3rd Edition)

Name: High Performance MySQL (3rd Edition)
ISBN: 9787121198854

Baron Schwartz / Peter Zaitsev / Vadim TkachenkoPublishing House of Electronics Industry2013

Rating 4.6

Word count: 1K words
Chapters: 23
ISBN: 9787121198854

Summary

High Performance MySQL (3rd Edition) is a classic technical work in the MySQL field. The original English edition was co-authored by Percona founders Baron Schwartz, Peter Zaitsev, and Vadim Tkachenko; the Chinese edition was translated by Ning Haiyuan, Zhou Zhenxing, Peng Lixun, and Zhai Weixiang, and published by Publishing House of Electronics Industry in 2013. Compared with the first two editions, the third edition was substantially rewritten around the new features of MySQL 5.5 and added coverage of solid-state drives (SSDs), highly scalable design, and running databases in cloud environments; the existing sections on benchmarking and performance optimization were also greatly expanded and supplemented. The book has 16 chapters and 6 appendices, covering MySQL architecture and history, benchmarking, server performance profiling, schema and data type optimization, indexing and query optimization, the query cache, replication, backup and recovery, high availability and high scalability, MySQL in the cloud, and the common toolchain. Each chapter stands relatively independent, so readers can either read it through or consult selected chapters according to the bottlenecks they encounter at work. The methodology emphasizes "measure first, optimize second": first use benchmarking and profiling to find the real bottleneck, then decide whether to work at the level of hardware, operating system, server configuration, schema, indexes, SQL, or application architecture. The book is aimed at an advanced audience: readers who can already write working SQL but want to systematically master MySQL performance issues. It has long served DBAs, backend developers, and system operations staff as a desk reference.

Editor's review

如果只能推荐一本 MySQL 性能方面的书，这本大概会是很多 DBA 的答案。《高性能MySQL》系列之所以长期占据口碑榜，是因为它讲的不是零散“调参技巧”，而是一套可复用的性能分析方法论：先弄清楚系统在做什么，再判断问题在哪一层，最后才谈优化手段。第3版的价值尤其体现在“跨层”视野上。它从 MySQL 逻辑架构、存储引擎和事务与锁讲起，再延伸到基准测试、性能剖析、Schema 与索引设计、SQL 优化、服务器与操作系统参数、复制与高可用、云计算环境，几乎覆盖了线上数据库会出问题的地方。很多读者反馈，书里的案例、图与实验思路上手做一遍，比背参数表有用得多。需要提醒的是：第3版以 MySQL 5.5 为主要基准，部分版本细节（如 8.0 相关特性）已不适用。它最适合作为“原理与方法”的基础读物，再配合新版官方文档、第4版以及自己所在生产环境实践来补足版本差异。中译本行文清晰，术语翻译较为一致，整体阅读体验良好。

Who it's for

A good fit for

已会写基础 MySQL SQL、准备正面解决慢查询与高并发问题的后端开发人员
负责线上 MySQL 实例稳定性、扩容、备份恢复与高可用的 DBA 与系统运维工程师
需要做数据库选型、架构设计与容量评估的技术负责人和架构师
计算机相关专业、希望从课程知识过渡到生产级数据库能力的学生

Not a good fit for

完全没有 SQL 与数据库基础的入门者，建议先读入门教材再上手本书
只想查找零散参数或命令的读者，工具书式的即时查询更适合官方文档与手册
仅使用云托管数据库、不接触底层运维的产品或非技术岗位读者

Reading tips

第1—3章先完整读一遍，建立架构与“先测量再优化”的方法框架，再按需跳读后面章节。
阅读时在本地或测试环境搭建 MySQL 5.5/5.7 实例，对照书中实验复现基准测试、执行计划与锁案例。
把索引、查询优化、复制与高可用几章当作长期参考，遇到线上问题回查对应章节而非通读。
注意书中版本基准为 MySQL 5.5，涉及 8.0 的 JSON、数据字典、原子 DDL 等内容需配合新版官方文档补充。

About the publisher

Publishing House of Electronics Industry China · Founded in 1982

The Publishing House of Electronics Industry is a comprehensive publisher distinguished by its focus on electronic information and related fields. Judging from the more than 3,000 titles in its catalogue, its publishing covers programming and design, artificial intelligence, computer science, finance and economics, photography, and social sciences, attending both to cutting-edge technology and to general readers. Representative titles include Factor Investing: Methods and Practice, x86 Assembly Language: From Real Mode to Protected Mode, The RISC-V Reader, Artificial Intelligence: Speech Recognition, Understanding and Practice, Phased Array Radar Technology, Radar Target Characteristics, and 100 Go Mistakes and How to Avoid Them, most of which centre on technical methods and engineering practice. Its authors include Shi Chuan, Li Zhong, Wang Xiaobo, David Patterson, Andrew Waterman, and Yu Zihao, among others from China and abroad. Owing to limited public information, no further publishing features are elaborated here.

Foreword / Preface
Chapter 1 MySQL Architecture and History
Chapter 2 Benchmarking MySQL
Chapter 3 Profiling Server Performance
Chapter 4 Optimizing Schema and Data Types
Chapter 5 Creating High-Performance Indexes
Chapter 6 Optimizing Query Performance
Chapter 7 Advanced MySQL Features
Chapter 8 Optimizing Server Settings
Chapter 9 Operating System and Hardware Optimization
Chapter 10 Replication
Chapter 11 Scaling MySQL
Chapter 12 High Availability
Chapter 13 MySQL in the Cloud
Chapter 14 Application-Level Optimization
Chapter 15 Backup and Recovery
Chapter 16 User Tools
Appendix A Common Tools for MySQL
Appendix B Using Sphinx with MySQL for Full-Text Search
Appendix C Using Flexy with MySQL for Sharding
Appendix D Additional Information in Execution Plans
Appendix E Locking in MySQL and InnoDB
Appendix F Optimizer Hints and Options

FAQ

第3版和市面上的“第4版”是同一本书吗？

不是。第3版原著由 Baron Schwartz、Peter Zaitsev、Vadim Tkachenko 撰写，对应 MySQL 5.5，2013 年电子工业出版社出版，ISBN 9787121198854。2022 年出版的第4版原著作者已换为 Silvia Botros 与 Jeremy Tinley，内容围绕 MySQL 5.7 与 8.0 重写，ISBN 9787121442575，购买时请核对。

这本书适合零基础学 MySQL 吗？

不太适合。本书默认读者已掌握 SQL 基本语法和数据库日常操作，重点讲性能原理与大规模运维。零基础读者可先读 MySQL 入门教程或《MySQL 必知必会》，再进入本书。

书里讲的 MySQL 版本现在还有效吗？

书中的架构原理、事务与锁、索引设计、查询优化思路、复制与备份方法依然适用，是最有价值的部分。但具体参数名、默认值和部分特性在 5.7、8.0 中已有变化，应以当前官方文档为准。

读完能立刻解决线上慢查询吗？

书提供的是诊断与优化方法，例如性能剖析、执行计划解读、索引选择、慢日志分析，但能否解决问题取决于对业务与数据的理解。建议一边读书一边在自己环境复现实验，把方法落到实际案例上。

This site is an index: you start “Search all sources” in your browser, and the entries it lists all point to third-party sites; please judge their availability yourself.

About the author

Baron Schwartz Author

Baron Schwartz is a computer author who has long focused on databases and system performance. Publicly available information about him is limited, and details such as his nationality, birth and death dates, and personal background are not clearly documented, so his personal history can only be left aside here. Judging from the works included in the collection, he is best known to Chinese readers for High Performance MySQL (3rd Edition), a theoretical and practical work in the fields of computing and databases. His writing centers on the core theme of database performance, emphasizing principles and methods grounded in engineering practice, with an emphasis on operability and systematicity. The book is suitable for technical readers who wish to gain a deeper understanding of how databases work and how performance can be optimized. Overall, Schwartz's writing is pragmatic and highly technical, and his work offers reference value in the database field, though given the limited material, his personal profile remains relatively unclear.

Peter Zaitsev Author

Peter Zaitsev is an influential author in the field of database technology. Publicly available information is limited, and details such as his nationality and dates of birth and death remain unclear. Judging from the works held in the library, he contributed to High Performance MySQL (3rd Edition), a theoretical work in computer science and databases intended for readers who need a deeper understanding of MySQL performance optimization. His subject matter centers on database principles and practical experience, and his writing style tends toward technical explanation and problem analysis with an emphasis on applicability. Both works in the library share the same title, High Performance MySQL (3rd Edition), indicating that his contribution focuses mainly on this topic. For readers seeking to systematically study MySQL performance tuning, this work offers a practical reference and has had a certain influence among Chinese-language technical readers.

Vadim Tkachenko Author

Vadim Tkachenko is an author associated with database technology writing, though publicly available personal information about him is currently limited. Among the works recorded in the library, he co-authored High Performance MySQL (3rd Edition), a book categorized under computing, databases, and theoretical knowledge, and positioned as a technical reference for database practice. Since the existing material provides no information about his nationality, dates of birth and death, educational background, or professional career, no further account of his life can be given. What can be confirmed is that his writing centers on MySQL performance optimization and database principles, with an emphasis on practical utility and technical depth, making it suitable for developers, database administrators, and system architects with some prior experience. For readers seeking a deeper understanding of MySQL's internal workings and tuning methods, such works offer useful reference value and reflect the author's sustained attention to the field of database performance.