High Performance MySQL is the definitive guide to building fast, reliable systems with MySQL. Written by noted experts with years of real-world experience building very large systems, this book covers every aspect of MySQL performance in detail, and focuses on robustness, security, and data integrity. High Performance MySQL teaches you advanced techniques in depth so you can b...
High Performance MySQL is the definitive guide to building fast, reliable systems with MySQL. Written by noted experts with years of real-world experience building very large systems, this book covers every aspect of MySQL performance in detail, and focuses on robustness, security, and data integrity. High Performance MySQL teaches you advanced techniques in depth so you can bring out MySQL's full power. Learn how to design schemas, indexes, queries and advanced MySQL features for maximum performance, and get detailed guidance for tuning your MySQL server, operating system, and hardware to their fullest potential. You'll also learn practical, safe, high-performance ways to scale your applications with replication, load balancing, high availability, and failover. This second edition is completely revised and greatly expanded, with deeper coverage in all areas. Major additions include: * Emphasis throughout on both performance and reliability * Thorough coverage of storage engines, including in-depth tuning and optimizations for the InnoDB storage engine * Effects of new features in MySQL 5.0 and 5.1 , including stored procedures, partitioned databases, triggers, and views * A detailed discussion on how to build very large, highly scalable systems with MySQL * New options for backups and replication * Optimization of advanced querying features, such as full-text searches * Four new appendices The book also includes chapters on benchmarking, profiling, backups, security, and tools and techniques to help you measure, monitor, and manage your MySQL installations.
宁海元 有超过十年的数据库管理经验,从最初到SQL Server 2000到Oracle到MySQL,擅长数据库高可用架构,性能优化和故障诊断。2007年加入淘宝,带领淘宝DBA团队支撑了淘宝业务的快速增长,完成了数据库的垂直拆分、水平拆分,迁移到MySQL体系等主要工作。目前专注于无线数据领域。网络常用名NinGoo,个人博客:http://www.ningoo.net
Sometimes people protest that they just don’t have time to benchmark the server for 8 or 12 hours at 10 different levels of concurrency on two or three server versions. If you don’t have the time to do the benchmarks right, any time you do spend is wasted; it is better to trust other people’s results, instead of doing an incomplete benchmark and getting the wrong answers. (查看原文)
The Cisco server has lower per-CPU performance than the EC2 servers. Surprised? We were a bit surprised ourselves.。。。Thus, the explanation for our results is probably as follows: the Cisco
server’s CPUs are a couple of years old, and are slower than the EC2 servers. But for
more complex tasks such as running a database server, the overhead of virtualization
places the EC2 servers at a disadvantage. It’s not always easy to distinguish between
slow CPUs, slow memory access, and virtualization overhead, but in this instance the
differences seem a bit clearer. (查看原文)
前一阵选择性的读了可能大概十来章,获益匪浅。对很多db领域的常识的了解程度深了一层。isolation level, locks, transaction, index, mvcc... to name a few. 很多细节没有深究了,一是这书是08年出的,有些老了,二是觉得没必要在这种基础设施上花太多时间,直接花钱买就好了。优化运维什么的,leave these nasty to the re...前一阵选择性的读了可能大概十来章,获益匪浅。对很多db领域的常识的了解程度深了一层。isolation level, locks, transaction, index, mvcc... to name a few. 很多细节没有深究了,一是这书是08年出的,有些老了,二是觉得没必要在这种基础设施上花太多时间,直接花钱买就好了。优化运维什么的,leave these nasty to the real experts,you just pay, and it does not cost much. 譬如阿里云上要配个master-slave,只要随便点两下就好了。一直有个观点: 工具以后肯定是越来越好用,越来越易用,死抠细节并不明智(展开)
前一阵选择性的读了可能大概十来章,获益匪浅。对很多db领域的常识的了解程度深了一层。isolation level, locks, transaction, index, mvcc... to name a few. 很多细节没有深究了,一是这书是08年出的,有些老了,二是觉得没必要在这种基础设施上花太多时间,直接花钱买就好了。优化运维什么的,leave these nasty to the re...前一阵选择性的读了可能大概十来章,获益匪浅。对很多db领域的常识的了解程度深了一层。isolation level, locks, transaction, index, mvcc... to name a few. 很多细节没有深究了,一是这书是08年出的,有些老了,二是觉得没必要在这种基础设施上花太多时间,直接花钱买就好了。优化运维什么的,leave these nasty to the real experts,you just pay, and it does not cost much. 譬如阿里云上要配个master-slave,只要随便点两下就好了。一直有个观点: 工具以后肯定是越来越好用,越来越易用,死抠细节并不明智(展开)
0 有用 vinceguo 2018-09-16 23:09:10
前一阵选择性的读了可能大概十来章,获益匪浅。对很多db领域的常识的了解程度深了一层。isolation level, locks, transaction, index, mvcc... to name a few. 很多细节没有深究了,一是这书是08年出的,有些老了,二是觉得没必要在这种基础设施上花太多时间,直接花钱买就好了。优化运维什么的,leave these nasty to the re... 前一阵选择性的读了可能大概十来章,获益匪浅。对很多db领域的常识的了解程度深了一层。isolation level, locks, transaction, index, mvcc... to name a few. 很多细节没有深究了,一是这书是08年出的,有些老了,二是觉得没必要在这种基础设施上花太多时间,直接花钱买就好了。优化运维什么的,leave these nasty to the real experts,you just pay, and it does not cost much. 譬如阿里云上要配个master-slave,只要随便点两下就好了。一直有个观点: 工具以后肯定是越来越好用,越来越易用,死抠细节并不明智 (展开)
0 有用 王晓辰 2014-11-19 11:11:36
附录里貌似还有一些有趣的东西,抽空看
1 有用 init.d 2010-05-28 11:54:02
看了几章电子版,还是决定买一本; 电子版读完,等拿到影印本再好好研读; 常读常新,每次翻到需要的章节都会有惊喜!
0 有用 玄武湖海盗头目 2011-11-17 18:49:11
神书,基本上MySQL的各种东西都很深入的说明了,大流量网站估计必备吧。
0 有用 Ryen 2011-09-23 20:43:11
有点纠缠细节,不够精炼。大而全
0 有用 asumi 2020-06-07 20:33:53
partition/replication/high availability on mysql
0 有用 vinceguo 2018-09-16 23:09:10
前一阵选择性的读了可能大概十来章,获益匪浅。对很多db领域的常识的了解程度深了一层。isolation level, locks, transaction, index, mvcc... to name a few. 很多细节没有深究了,一是这书是08年出的,有些老了,二是觉得没必要在这种基础设施上花太多时间,直接花钱买就好了。优化运维什么的,leave these nasty to the re... 前一阵选择性的读了可能大概十来章,获益匪浅。对很多db领域的常识的了解程度深了一层。isolation level, locks, transaction, index, mvcc... to name a few. 很多细节没有深究了,一是这书是08年出的,有些老了,二是觉得没必要在这种基础设施上花太多时间,直接花钱买就好了。优化运维什么的,leave these nasty to the real experts,you just pay, and it does not cost much. 譬如阿里云上要配个master-slave,只要随便点两下就好了。一直有个观点: 工具以后肯定是越来越好用,越来越易用,死抠细节并不明智 (展开)
0 有用 xiongxoy 2018-07-22 14:21:21
看了无法理解,中文的翻译很晦涩,适合进阶阅读吧,公司内部培训见过Peter,讲MySQL 8,现场听果然听懂的多一些
0 有用 yujinyan 2018-02-08 20:30:14
MySQL 应用方面找不到更深入细致的书了
0 有用 王晓辰 2014-11-19 11:11:36
附录里貌似还有一些有趣的东西,抽空看