search for books and compare prices
Tables of Contents for High Performance Mysql
Chapter/Section Title
Page #
Page Count
Preface ix
1. Back To Basics
1
15
Binary Versus Compiled-From-Source Installations
2
2
Configuration Files
4
7
The SHOW Commands
11
5
2. Storage Engines (Table Types)
16
29
MySQL Architecture
16
2
Locking and Concurrency
18
4
Transactions
22
7
Selecting the Right Engine
29
6
The Storage Engines
35
10
3. Benchmarking
45
16
The Importance of Benchmarking
46
1
Benchmarking Strategies
46
3
Benchmarking Tools
49
12
4. Indexes
61
18
Indexing Basics
61
7
Index Structures
68
4
Indexes and Table Types
72
4
Index Maintenance
76
3
5. Query Performance
79
24
Query Processing Basics
79
13
Optimizer Features and Oddities
92
3
Identifying Slow Queries
95
1
Influencing MySQL with Hints
96
2
Stupid Query Tricks
98
5
6. Server Performance Tuning
103
26
Performance-Limiting Factors
103
6
RAID
109
4
Operating System
113
6
Techniques
119
10
7. Replication
129
40
Replication Overview
129
5
Configuring Replication
134
6
Under the Hood
140
4
Replication Architectures
144
4
Administration and Maintenance
148
12
Common Problems
160
4
The Future of Replication
164
5
8. Load Balancing and High Availability
169
18
Load Balancing Basics
169
5
Configuration Issues
174
5
Cluster Partitioning
179
3
High Availability
182
5
9. Backup and Recovery
187
16
Why Backups?
187
2
Considerations and Tradeoffs
189
4
Tools and Techniques
193
6
Rolling Your Own Backup Script
199
4
10. Security
203
34
Account Basics
203
4
The Grant Tables
207
8
Grant and Revoke
215
7
Operating System Security
222
1
Network Security
223
8
Data Encryption
231
4
MySQL in a chrooted Environment
235
2
A. The SHOW STATUS and SHOW INNODB STATUS Commands
237
11
B. mytop
248
9
C. phpMyAdmin
257
10
Index
267