高性能MySQL（影印版）

定　價：￥86.00

作　者：	（美）施瓦茨（Schwartz,B.）等著
出版社：	英偉出版社
叢編項：
標　簽：	SQL

購買這本書可以去

ISBN：	9787802057326	出版時間：	2009-04-01	包裝：	平裝
開本：	16開	頁數：	684	字數：

內容簡介

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

作者簡介

暫缺《高性能MySQL（影印版）》作者簡介

圖書目錄

Foreword.
Preface
1. MySQL Architecture
MySQLs Logical Architecture
Concurrency Control
Transactions
Multiversion Concurrency Control
MySQLs Storage Engines
2. Finding Bottlenecks: Benchmarking and Profiling
Why Benchmark?
Benchmarking Strategies
Benchmarking Tactics
Benchmarking Tools
Benchmarking Examples
Profiling
Operating System Profiling
3. Schema Optimization and Indexing
Choosing Optimal Data Types
Indexing Basics
Indexing Strategies for High Performance
An Indexing Case Study
Index and Table Maintenance
Normalization and Denormalization
Speeding Up ALTER TABLE
Notes on Storage Engines
4. Query Performance Optimization
Slow Query Basics: Optimize Data Access
Ways to Restructure Queries
Query Execution Basics
Limitations of the MySQL Query Optimizer
Optimizing Specific Types of Queries
Query Optimizer Hints
User-Defined Variables
5. Advanced MySQL Features
The MySQL Query Cache
Storing Code Inside MySQL
Cursors
Prepared Statements
User-Defined Functions
Views
Character Sets and Collations
Full-Text Searching
Foreign Key Constraints
Merge Tables and Partitioning
Distributed (XA) Transactions
6. Optimizing Server Settings
Configuration Basics
General Tuning
Tuning MySQLs I/O Behavior
Tuning MySQL Concurrency
Workload-Based Tuning
Tuning Per-Connection Settings
7. Operating System and Hardware Optimization
What Limits MySQLs Performance?
How to Select CPUs for MySQL
Balancing Memory and Disk Resources
Choosing Hardware for a Slave
RAID Performance Optimization
Storage Area Networks and Network-Attached Storage
Using Multiple Disk Volumes
Network Configuration
Choosing an Operating System
Choosing a Filesystem
Threading
Swapping
Operating System Status..
8. Replication
Replication Overview
Setting Up Replication
Replication Under the Hood
Replication Topologies
Replication and Capacity Planning
Replication Administration and Maintenance
Replication Problems and Solutions
How Fast Is Replication?
The Future of MySQL Replication
9. Scaling and High Availability
Terminology
Scaling MySQL
Load Balancing
High Availability
10. Application-Level Optimization
Application Performance Overview
Web Server Issues
Caching
Extending MySQL
Alternatives to MySQL
11. Backupand Recovery
Overview
Considerations and Tradeoffs
Managing and Backing Up Binary Logs
Backing Up Data
Recovering from a Backup
Backup and Recovery Speed
Backup Tools
Scripting Backups
12. Security
Terminology
Account Basics
Operating System Security
Network Security
Data Encryption
MySQL in a chrooted Environment
13. MySQL Server Status
System Variables
SHOW STATUS
SHOW INNODB STATUS
SHOW PROCESSLIST
SHOW MUTEX STATUS
Replication Status
INFORMATION_SCHEMA
14. Tools for High Performance
Interface Tools
Monitoring Tools
Analysis Tools
MySQL Utilities
Sources of Further Information
A. Transferring Large Files
B. Using EXPLAIN
C. Using Sphinx with MySQL
D. Debugging Locks
Index