高性能MYSQLPDF电子书下载

1．MySQL Architecture 1

MySQL's Logical Architecture 1

Concurrency Control 3

Transactions 6

Multiversion Concurrency Control 12

MySQL's Storage Engines 14

2．Finding Bottlenecks:Benchmarking and Profiling 32

Why Benchmark? 33

Benchmarking Strategies 33

Benchmarking Tactics 37

Benchmarking Tools　 42

Benchmarking Examples　 44

Profiling 54

Operating System Profiling 76

3．Schema Optimization and Indexing 80

Choosing Optimal Data Types　 80

Indexing Basics 95

Indexing Strategies for High Performance 106

An Indexing Case Study 131

Index and Table Maintenance 136

Normalization and Denormalization 139

Speeding Up ALTER TABLE 145

Notes on Storage Engines 149

4．Query Performance Optimization 152

Slow Query Basics:Optimize Data Access 152

Ways to Restructure Queries 157

Query Execution Basics 160

Limitations of the MySQL Query Optimizer 179

Optimizing Specific Types of Queries 188

Query Optimizer Hints 195

User-Defined Variables 198

5．Advanced MySQL Features 204

The MySQL Query Cache 204

Storing Code Inside MySQL 217

Cursors 224

Prepared Statements 225

User-Defined Functions 230

Views 231

Character Sets and Collations 237

Full-Text Searching 244

Foreign Key Constraints 252

Merge Tables and Partitioning 253

Distributed(XA)Transactions 262

6．Optimizing Server Settings 265

Configuration Basics 266

General Tuning 271

Tuning MySQL's I/O Behavior 281

Tuning MySQL Concurrency 295

Workload-Based Tuning 298

Tuning Per-Connection Settings 304

7．Operating System and Hardware Optimization 305

What Limits MySQL's Performance? 306

How to Select CPUs for MySQL 306

Balancing Memory and Disk Resources 309

Choosing Hardware for a Slave 317

RAID Performance Optimization 317

Storage Area Networks and Network-Attached Storage 325

Using Multiple Disk Volumes 326

Network Configuration 328

Choosing an Operating System 330

Choosing a Filesystem 331

Threading 334

Swapping 334

Operating System Status 336

8．Replication 343

Replication Overview 343

Setting Up Replication 347

Replication Under the Hood 355

Replication Topologies 362

Replication and Capacity Planning 376

Replication Administration and Maintenance 378

Replication Problems and Solutions 388

How Fast Is Replication?　 405

The Future of MySQL Replication　 407

9．Scaling and High Availability 409

Terminology　 410

Scaling MySQL　 412

Load Balancing　 436

High Availability　 447

10．Application-Level Optimization 457

Application Performance Overview　 457

Web Server Issues 　 460

Caching　 463

Extending MySQL　 470

Alternatives to MySQL 　 471

11．Backup and Recovery 472

Overview　 473

Considerations and Tradeoffs　 477

Managing and Backing Up Binary Logs　 486

Backing Up Data　 488

Recovering from a Backup　 499

Backup and Recovery Speed 510

Backup Tools 511

Scripting Backups 518

12．Security 521

Terminology 521

Account Basics 522

Operating System Security 541

Network Security 542

Data Encryption 550

MySQL in a chrooted Environment 554

13．MySQL Server Status 557

System Variables 557

SHOW STATUS 558

SHOW INNODB STATUS 565

SHOW PROCESSLIST 578

SHOW MUTEX STATUS 579

Replication Status 580

INFORMATION_SCHEMA 581

14．Tools for High Performance 583

Interface Tools 583

Monitoring Tools 585

Analysis Tools 595

MySQL Utilities 598

Sources of Further Information 601

A．Transferring Large Files 603

B．Using EXPLAIN 607

C．Using Sphinx with MySQL 623

D．Debugging Locks 650

Index 659