高性能MySQL

前言

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

內(nèi)容概要

　　《高性能MySQL（影印版）（第2版）》教你如何使用MySQL構(gòu)建快速、可靠的系統(tǒng)。本書的作者都是知名專家，具有多年構(gòu)建大型系統(tǒng)的實際經(jīng)驗。本書第二版涵蓋了MySQL性能細(xì)節(jié)并且專注于健壯性、安全性和數(shù)據(jù)完整性?！　　陡咝阅躆ySQL（影印版）（第2版）》深入講解高級技巧從而讓你能夠受益于MySQL的全部威力。你將學(xué)到如何設(shè)計模板、索引、查詢和令性能最大化的高級MySQL特性。另外，你將獲得詳細(xì)的指導(dǎo)來為你的MySQL服務(wù)器、操作系統(tǒng)和硬件進行性能調(diào)優(yōu)以便發(fā)揮它們的全部潛能。同時還包括運用實用、安全和高性能的方法來擴展你的應(yīng)用，使其具有副本保存、負(fù)載均衡、高可用和失敗自動切換的功能?！　”緯诙孢M行了全面修改以及很大程度地擴展，對所有專題都進行了更有深度的覆蓋。主要的新增內(nèi)容包括：　　* 強調(diào)性能和可靠性的每一方面　　* 詳細(xì)涵蓋搜索引擎，包括深度調(diào)優(yōu)和InnoDB存儲引擎的優(yōu)化　　* MySQL5.0和5.1新功能的效用，包括存儲過程、數(shù)據(jù)庫分區(qū)、觸發(fā)器和視圖　　* 對如何使用MySQL構(gòu)建大型、高可擴展系統(tǒng)進行了詳細(xì)的討論　　* 備份和副本的新選項　　* 高級查詢功能的優(yōu)化，例如全文檢索　　* 四個全新的附錄　　《高性能MySQL（影印版）（第2版）》的內(nèi)容還包括基準(zhǔn)分析、評測報告、備份、安全性以及幫你測量、監(jiān)控并管理所安裝的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

章節(jié)摘錄

插圖：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.

媒體關(guān)注與評論

“我向那些初涉MySQL并且現(xiàn)在正準(zhǔn)備編寫第一個實際應(yīng)用的新手、和那些已經(jīng)把基于MySQL的應(yīng)用優(yōu)化得不錯但還需再上一層樓的有經(jīng)驗用戶推薦此書?！?   ——Michael Widenius，MySQL的初始開發(fā)人員

編輯推薦

《高性能MYSQL》:O'Reilly Media,Inc.是世界上在UNIX、X、Internet和其他開放系統(tǒng)圖書領(lǐng)域具有領(lǐng)導(dǎo)地位的出版公司，同時是聯(lián)機出版的先鋒。從最暢銷的《The Whole Internet User's Guide & Catalog》（被紐約公共圖書館評為二十世紀(jì)最重要的50本書之一）到GNN（最早的Internet門戶和商業(yè)網(wǎng)站），再到WebSite（第一個桌面PC的Web服務(wù)器軟件），O'Reilly Meida,Inc.一直處于Internet發(fā)展的最前沿。O'Reilly已經(jīng)出版了200多種圖書，200多位員工分布在世界各地，O'Reilly是最穩(wěn)定的計算機圖書出版商——每一本書都一版再版。與大多數(shù)計算機圖書出版商相比，我們在計算機專業(yè)方面具有強烈的背景，這使O'Reilly形成了一個非常不同于其他出版商的出版方針。O'Reilly所有的編輯人員以前都是程序員，或者是頂尖級的技術(shù)專家，O'Reilly還有許多固定的作者群體——他們曾是咨詢專家，而現(xiàn)在編寫著作，我們依靠他們準(zhǔn)時地推出圖書。因為我們緊密地與計算機業(yè)界聯(lián)系著，所以O(shè)'Reilly知道市場上真正需要什么圖書。 O'Reilly是全世界有名的計算機圖書出版公司，圖書通俗易懂，影印版沒有改動任何原書中的內(nèi)容，將O'Reilly圖書最真實的放在讀者面前，相信對于需要的人來說這是一個至寶。我想推薦這本書，因為它對ASP.NET最常用的知識和技能進行了很棒的講解。讀者通讀全書，將會碰到他們在創(chuàng)建小型動態(tài)網(wǎng)站時可能面臨的所有任務(wù)?！?                                        ——Mike Pope，微軟用戶教育

圖書封面

圖書標(biāo)簽Tags

無

評論、評分、閱讀與下載

---

    高性能MySQL PDF格式下載

---