| 词条 | 高性能MySQL(影印版) |
| 释义 | 《高性能MySQL》深入讲解高级技巧从而让你能够受益于MySQL的全部威力。你将学到如何设计模板、索引、查询和令性能最大化的高级MySQL特性。另外，你将获得详细的指导来为你的MySQL服务器、操作系统和硬件进行性能调优以便发挥它们的全部潜能。同时还包括运用实用、安全和高性能的方法来扩展你的应用，使其具有副本保存、负载均衡、高可用和失败自动切换的功能。本书的内容还包括基准分析、评测报告、备份、安全性以及帮你测量、监控并管理所安装的MySQL的工具和技巧。 作者：（美国）Baron Scbwartz （美国）Peter Zaitsev （美国）Vadim Tkacbenko 等 ISBN：9787802057326 页数：684 页 出版社：开明出版社 出版时间：2009年 开本：16 目录Foreword. Preface1. MySQL Architecture MySQL's Logical Architecture Concurrency Control Transactions Multiversion Concurrency Control MySQL's 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 MySQL's I/O Behavior Tuning MySQL Concurrency Workload-Based Tuning Tuning Per-Connection Settings 7. Operating System and Hardware Optimization What Limits MySQL's 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.. |
| 随便看 |
|
百科全书收录4421916条中文百科知识，基本涵盖了大多数领域的百科知识，是一部内容开放、自由的电子版百科全书。