高性能MYSQLpdf电子书版本下载

点此进入-本书在线PDF格式电子书下载【推荐-云解压-方便快捷】直接下载PDF格式图书。移动端-PC端通用
下载压缩包 [复制下载地址] 温馨提示：（请使用BT下载软件FDM进行下载）软件下载地址页

高性能MYSQLPDF格式电子书版下载

下载的文件为RAR压缩包。需要使用解压软件进行解压得到PDF格式图书。

建议使用BT下载工具Free Download Manager进行下载,简称FDM(免费,没有广告,支持多平台）。本站资源全部打包为BT种子。所以需要使用专业的BT下载软件进行下载。如 BitComet qBittorrent uTorrent等BT下载工具。迅雷目前由于本站不是热门资源。不推荐使用！后期资源热门了。安装了迅雷也可以迅雷进行下载！

（文件页数 要大于 标注页数，上中下等多册电子书除外）

注意：本站所有压缩包均有解压码： 点击下载压缩包解压工具

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