高性能MySQL

出版时间：2009-4  出版社：开明出版社  作者：(美)施瓦茨  页数：684  
Tag标签：无  

前言

I have known Peter, Vadim, and Arjen a long time and have witnessed their long history of both using MySQL for their own projects and tuning it for a lot of different high-profile customers. On his side, Baron has written client software that enhances the usability of MySQL.The authors' backgrounds are clearly reflected in their complete reworking in this second edition of High Performance MySQL: Optimizations, Replication, Backups, and More. It's not just a book that tells you how to optimize your work to use MySQL better than ever before. The authors have done considerable extra work, carrying out and publishing benchmark results to prove their points. This will give you the reader, a lot of valuable insight into MySQL's inner workings that you can't easily find in any other book. In turn, that will allow you to avoid a lot of mistakes in the future that can lead to suboptimal performance.I recommend this book both to new users of MySQL who have played with the server a little and now are ready to write their first real applications, and to experienced users who already have well-tuned MySQL-based applications but need to get "a little more" out of them.——Michael Widenius

内容概要

　　《高性能MySQL（影印版）（第2版）》教你如何使用MySQL构建快速、可靠的系统。本书的作者都是知名专家，具有多年构建大型系统的实际经验。本书第二版涵盖了MySQL性能细节并且专注于健壮性、安全性和数据完整性。　　《高性能MySQL（影印版）（第2版）》深入讲解高级技巧从而让你能够受益于MySQL的全部威力。你将学到如何设计模板、索引、查询和令性能最大化的高级MySQL特性。另外，你将获得详细的指导来为你的MySQL服务器、操作系统和硬件进行性能调优以便发挥它们的全部潜能。同时还包括运用实用、安全和高性能的方法来扩展你的应用，使其具有副本保存、负载均衡、高可用和失败自动切换的功能。　　本书第二版进行了全面修改以及很大程度地扩展，对所有专题都进行了更有深度的覆盖。主要的新增内容包括：　　* 强调性能和可靠性的每一方面　　* 详细涵盖搜索引擎，包括深度调优和InnoDB存储引擎的优化　　* MySQL5.0和5.1新功能的效用，包括存储过程、数据库分区、触发器和视图　　* 对如何使用MySQL构建大型、高可扩展系统进行了详细的讨论　　* 备份和副本的新选项　　* 高级查询功能的优化，例如全文检索　　* 四个全新的附录　　《高性能MySQL（影印版）（第2版）》的内容还包括基准分析、评测报告、备份、安全性以及帮你测量、监控并管理所安装的MySQL的工具和技巧。

作者简介

作者：(美国)Baron Scbwartz (美国)Peter Zaitsev (美国)Vadim Tkacbenko 等

书籍目录

Foreword.Preface1. MySQL ArchitectureMySQL's Logical ArchitectureConcurrency ControlTransactionsMultiversion Concurrency ControlMySQL's Storage Engines2. Finding Bottlenecks: Benchmarking and ProfilingWhy Benchmark?Benchmarking StrategiesBenchmarking TacticsBenchmarking ToolsBenchmarking ExamplesProfilingOperating System Profiling3. Schema Optimization and IndexingChoosing Optimal Data TypesIndexing BasicsIndexing Strategies for High PerformanceAn Indexing Case StudyIndex and Table MaintenanceNormalization and DenormalizationSpeeding Up ALTER TABLENotes on Storage Engines4. Query Performance OptimizationSlow Query Basics: Optimize Data AccessWays to Restructure QueriesQuery Execution BasicsLimitations of the MySQL Query OptimizerOptimizing Specific Types of QueriesQuery Optimizer HintsUser-Defined Variables5. Advanced MySQL FeaturesThe MySQL Query CacheStoring Code Inside MySQLCursorsPrepared StatementsUser-Defined FunctionsViewsCharacter Sets and CollationsFull-Text SearchingForeign Key ConstraintsMerge Tables and PartitioningDistributed (XA) Transactions6. Optimizing Server SettingsConfiguration BasicsGeneral TuningTuning MySQL's I/O BehaviorTuning MySQL ConcurrencyWorkload-Based TuningTuning Per-Connection Settings7. Operating System and Hardware OptimizationWhat Limits MySQL's Performance?How to Select CPUs for MySQLBalancing Memory and Disk ResourcesChoosing Hardware for a SlaveRAID Performance OptimizationStorage Area Networks and Network-Attached StorageUsing Multiple Disk VolumesNetwork ConfigurationChoosing an Operating SystemChoosing a FilesystemThreadingSwappingOperating System Status..8. ReplicationReplication OverviewSetting Up ReplicationReplication Under the HoodReplication TopologiesReplication and Capacity PlanningReplication Administration and MaintenanceReplication Problems and SolutionsHow Fast Is Replication?The Future of MySQL Replication9. Scaling and High AvailabilityTerminologyScaling MySQLLoad BalancingHigh Availability10. Application-Level OptimizationApplication Performance OverviewWeb Server IssuesCachingExtending MySQLAlternatives to MySQL11. Backupand RecoveryOverviewConsiderations and TradeoffsManaging and Backing Up Binary LogsBacking Up DataRecovering from a BackupBackup and Recovery SpeedBackup ToolsScripting Backups12. SecurityTerminologyAccount BasicsOperating System SecurityNetwork SecurityData EncryptionMySQL in a chrooted Environment13. MySQL Server StatusSystem VariablesSHOW STATUSSHOW INNODB STATUSSHOW PROCESSLISTSHOW MUTEX STATUSReplication StatusINFORMATION_SCHEMA14. Tools for High PerformanceInterface ToolsMonitoring ToolsAnalysis ToolsMySQL UtilitiesSources of Further InformationA. Transferring Large FilesB. Using EXPLAINC. Using Sphinx with MySQLD. Debugging LocksIndex

章节摘录

插图：At some point, you're bound to need more performance from MySQL. But what should you try to improve？ A particular query？ Your schema？ Your hardware？ The only way to know is to measure what your system is doing, and test its performance under various conditions. That's why we put this chapter early in the book.The best strategy is to find and strengthen the weakest link in your application's chain of components. This is especially useful if you don't know what prevents bet ter performance——or what will prevent better performance in the future.Benchmarking and profiling are two essential practices for finding bottlenecks. They are related, hut they're not the same. A benchmark measures your system's performance. This can help determine a system's capacity, show you which changes mat ter and which don't, or show how your application performs with different data. In contrast, profiling helps you find where your application spends the most time or consumes the most resources. In other words, benchmarking answers the question "How well does this perform？" and profiling answers the question "Why does it perform the way it does？"We've arranged this chapter in two parts, the first about bencbmarking and the second about profiling. We begin with a discussion of reasons and strategies for benchmarking, then move on to specific benchmarking tactics. We show you how to plan and design benchmarks, design for accurate results, run benchmarks, and analyze the results. We end the first part with a look at benchmarking tools and examples of how to use several of them.The rest of the chapter shows how to profile both applications and MySQL. We show detailed examples of real-life profiling code we've used in production to help analyze application performance. We also show you how to log MySQL's queries, analyze the logs, and use MySQL's status counters and other tools to see what MySQL and your queries are doing.

媒体关注与评论

“我向那些初涉MySQL并且现在正准备编写第一个实际应用的新手、和那些已经把基于MySQL的应用优化得不错但还需再上一层楼的有经验用户推荐此书。”    ——Michael Widenius，MySQL的初始开发人员

编辑推荐

《高性能MYSQL》:O'Reilly Media,Inc.是世界上在UNIX、X、Internet和其他开放系统图书领域具有领导地位的出版公司，同时是联机出版的先锋。从最畅销的《The Whole Internet User's Guide & Catalog》（被纽约公共图书馆评为二十世纪最重要的50本书之一）到GNN（最早的Internet门户和商业网站），再到WebSite（第一个桌面PC的Web服务器软件），O'Reilly Meida,Inc.一直处于Internet发展的最前沿。O'Reilly已经出版了200多种图书，200多位员工分布在世界各地，O'Reilly是最稳定的计算机图书出版商——每一本书都一版再版。与大多数计算机图书出版商相比，我们在计算机专业方面具有强烈的背景，这使O'Reilly形成了一个非常不同于其他出版商的出版方针。O'Reilly所有的编辑人员以前都是程序员，或者是顶尖级的技术专家，O'Reilly还有许多固定的作者群体——他们曾是咨询专家，而现在编写著作，我们依靠他们准时地推出图书。因为我们紧密地与计算机业界联系着，所以O'Reilly知道市场上真正需要什么图书。 O'Reilly是全世界有名的计算机图书出版公司，图书通俗易懂，影印版没有改动任何原书中的内容，将O'Reilly图书最真实的放在读者面前，相信对于需要的人来说这是一个至宝。我想推荐这本书，因为它对ASP.NET最常用的知识和技能进行了很棒的讲解。读者通读全书，将会碰到他们在创建小型动态网站时可能面临的所有任务。”                                         ——Mike Pope，微软用户教育

用户评论 (总计14条)

•   mysql数据库的好书，只是还没有仔细的阅读。
•   便宜是比其他网站便宜些，但是书怎么跟旧的一样，侧边明显有折过的痕迹，肯定是有人翻过书！
•   书本身不错，但joyo给送来本稍旧有伤的书。买书人一般都想买个没残缺崭新的。
•   书的内容没的说，但是书的质量不怎么样
•   书是当天就发出来的，但是当天居然就显示已经配送成功，我却是在第二天才收到书的。书的封皮有一点点的划痕，没有影响。书的质量非常好，纸张和印刷都是一流的。总的来说我很满意。
•   此书中文版的什么时候出阿，只听说正在翻译，马上要出了，能给个具体时间吗
•   恩，一直想买，终于到手了。
•   MySQL技能提高篇
•   巨牛的一本书
•   书崭新，包装很好，物流也很快
•   书的不错！
•   非常經典
•   英文的原来是
•   Mysql学习必须精读的一本书