图书介绍

高性能MYSQLPDF|Epub|txt|kindle电子书版本下载

高性能MYSQL
  • （美）BARON SCBWARTZ等著 著
  • 出版社： 北京：开明出版社
  • ISBN：9787802057326
  • 出版时间：2009
  • 标注页数：687页
  • 文件大小：48MB
  • 文件页数：709页
  • 主题词：关系数据库－数据库管理系统－英文

PDF下载


点此进入-本书在线PDF格式电子书下载【推荐-云解压-方便快捷】直接下载PDF格式图书。移动端-PC端通用
种子下载[BT下载速度快]温馨提示：（请使用BT下载软件FDM进行下载）软件下载地址页直链下载[便捷但速度慢]  [在线试读本书]   [在线获取解压码]
点击复制MD5值：12b1514e69c33547be713a7ee716956f

下载说明

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

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

点击复制85GB完整离线版磁力链接到迅雷FDM等BT下载工具进行下载  详情点击-查看共享计划
建议使用BT下载工具Free Download Manager进行下载,简称FDM(免费,没有广告,支持多平台）。本站资源全部打包为BT种子。所以需要使用专业的BT下载软件进行下载。如BitComet qBittorrent uTorrent等BT下载工具。迅雷目前由于本站不是热门资源。不推荐使用！后期资源热门了。安装了迅雷也可以迅雷进行下载！

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

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

图书目录

1．MySQL Architecture1

MySQL's Logical Architecture1

Concurrency Control3

Transactions6

Multiversion Concurrency Control12

MySQL's Storage Engines14

2．Finding Bottlenecks:Benchmarking and Profiling32

Why Benchmark?33

Benchmarking Strategies33

Benchmarking Tactics37

Benchmarking Tools　42

Benchmarking Examples　44

Profiling54

Operating System Profiling76

3．Schema Optimization and Indexing80

Choosing Optimal Data Types　80

Indexing Basics95

Indexing Strategies for High Performance106

An Indexing Case Study131

Index and Table Maintenance136

Normalization and Denormalization139

Speeding Up ALTER TABLE145

Notes on Storage Engines149

4．Query Performance Optimization152

Slow Query Basics:Optimize Data Access152

Ways to Restructure Queries157

Query Execution Basics160

Limitations of the MySQL Query Optimizer179

Optimizing Specific Types of Queries188

Query Optimizer Hints195

User-Defined Variables198

5．Advanced MySQL Features204

The MySQL Query Cache204

Storing Code Inside MySQL217

Cursors224

Prepared Statements225

User-Defined Functions230

Views231

Character Sets and Collations237

Full-Text Searching244

Foreign Key Constraints252

Merge Tables and Partitioning253

Distributed(XA)Transactions262

6．Optimizing Server Settings265

Configuration Basics266

General Tuning271

Tuning MySQL's I/O Behavior281

Tuning MySQL Concurrency295

Workload-Based Tuning298

Tuning Per-Connection Settings304

7．Operating System and Hardware Optimization305

What Limits MySQL's Performance?306

How to Select CPUs for MySQL306

Balancing Memory and Disk Resources309

Choosing Hardware for a Slave317

RAID Performance Optimization317

Storage Area Networks and Network-Attached Storage325

Using Multiple Disk Volumes326

Network Configuration328

Choosing an Operating System330

Choosing a Filesystem331

Threading334

Swapping334

Operating System Status336

8．Replication343

Replication Overview343

Setting Up Replication347

Replication Under the Hood355

Replication Topologies362

Replication and Capacity Planning376

Replication Administration and Maintenance378

Replication Problems and Solutions388

How Fast Is Replication?　405

The Future of MySQL Replication　407

9．Scaling and High Availability409

Terminology　410

Scaling MySQL　412

Load Balancing　436

High Availability　447

10．Application-Level Optimization457

Application Performance Overview　457

Web Server Issues 　460

Caching　463

Extending MySQL　470

Alternatives to MySQL 　471

11．Backup and Recovery472

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 Speed510

Backup Tools511

Scripting Backups518

12．Security521

Terminology521

Account Basics522

Operating System Security541

Network Security542

Data Encryption550

MySQL in a chrooted Environment554

13．MySQL Server Status557

System Variables557

SHOW STATUS558

SHOW INNODB STATUS565

SHOW PROCESSLIST578

SHOW MUTEX STATUS579

Replication Status580

INFORMATION_SCHEMA581

14．Tools for High Performance583

Interface Tools583

Monitoring Tools585

Analysis Tools595

MySQL Utilities598

Sources of Further Information601

A．Transferring Large Files603

B．Using EXPLAIN607

C．Using Sphinx with MySQL623

D．Debugging Locks650

Index659

热门推荐