How about 'High Performance MySQL'

"High Performance MySQL" is a book that shares practical experience in MySQL. It not only helps MySQL beginners improve their usage skills, but also points out ways for experienced MySQL DBAs to develop high-performance MySQL applications.

"High Performance MySQL (2nd Edition)" contains 14 chapters and 4 appendices, covering MySQL system architecture, design application skills, SQL statement optimization, and server performance tuning. Optimization, system configuration management and security settings, monitoring analysis, as well as topics such as replication, expansion and backup/restore. The content of each chapter is self-contained and suitable for selective reading by technical personnel in various fields.

Won the award

"High Performance MySQL (2nd Edition)" won the 2009 Jolt Book Award

About the author

Baron Schwartz is a software engineer who lives in Charlottesville, Virginia. His common online name is Xaprb, which is the name typed on the Dvorak keyboard in the order of the QWERTY keyboard. When he's not solving fun coding challenges, Baron enjoys his free time with his wife, Lynn, and their dog, Carbon. He has a software engineering blog at http://www.xaprb.com/blog/

Peter Zaitsev was once the manager of the high-performance group of MySQL AB and currently runs mysqlperformance

blog.com website. He specializes in helping administrators of websites with millions of visitors every day, which often require hundreds of machines to handle terabytes of data. He often keeps upgrading hardware and software to solve a problem (such as query optimization). Peter is also a frequent speaker at conferences.

Vadim Tkachenko was a performance engineer at MySQL AB. As an expert in multi-threaded programming and synchronization, his main job is benchmarking, performance profiling, and identifying system performance bottlenecks. He also did some work on performance monitoring and tuning to make MySQL more scalable on multi-core machines.

============================================== ====================

Translator Introduction

Ning Haiyuan has more than ten years of experience in database management Experience, from the beginning to SQL Server 2000 to Oracle to MySQL, good at database high availability architecture, performance optimization and fault diagnosis. He joined Taobao in 2007 and led the Taobao DBA team to support the rapid growth of Taobao's business, completing the vertical split, horizontal split of the database, and migration to the MySQL system. Currently focusing on the field of wireless data. Common Internet name NinGoo, personal blog: http://www.ningoo.net

Zhou Zhenxing graduated from the Department of Mathematics of Beijing Normal University. In 2009, he joined the Taobao database team and was responsible for MySQL operation and maintenance management. He has rich knowledge of MySQL. Experience in performance optimization and troubleshooting, in-depth research on the implementation and principles of MySQL's main modules, experience in the development of Taobao MySQL instances from 30 to 3000, and in-depth understanding of system architecture and high-availability environment planning. Personal blog: http://orczhou.com

Peng Lixun joined Alibaba Operations and Maintenance Department after graduating from university in 2010. As a MySQL DBA, in the process of operating and maintaining MySQL, I have supplemented some functions and defects of MySQL and InnoDB, and written patches for multi-master replication and data flashback. Currently working in the database team of the Core System R&D Department of Alibaba Group, focusing on MySQL database-related development work. Later, some patches were favored by Mony, the father of MySQL, and became a member of the MariaDB submission group (Maria-captains), and merged multi-master replication, thread memory monitoring and other patches into MariaDB version 10.0.

Zhai Weixiang graduated from Wuhan University and engaged in database-related research at the postgraduate stage. After graduation, he has worked in the database technology team of Alibaba Group until now. He is mainly responsible for the maintenance of Alibaba's internal MySQL code branches, including MySQL bug fixes and new feature development. Have some research on the MySQL kernel.

Liu Hui graduated from the Computer Department of Xi'an University of Electronic Science and Technology in 2008 with a master's degree. In 2011, he joined the database technology team of Alibaba Group, named Xiyu, and is a MySQL kernel development engineer.

The above is the detailed content of How about 'High Performance MySQL'. For more information, please follow other related articles on the PHP Chinese website!