countdown boutiques-francophones Learn more scflyout Furniture All-New Kindle Music Deals Store sports Tools
High Performance MySQL: Optimization, Backups, Replicatio... and over one million other books are available for Amazon Kindle. Learn more

Vous voulez voir cette page en français ? Cliquez ici.

Have one to sell? Sell yours here
Start reading High Performance MySQL on your Kindle in under a minute.

Don't have a Kindle? Get your Kindle here, or download a FREE Kindle Reading App.

High Performance MySQL: Optimization, Backups, Replication, Load Balancing & More [Paperback]

Jeremy D. Zawodny , Derek J. Balling
4.8 out of 5 stars  See all reviews (10 customer reviews)

Available from these sellers.

‹  Return to Product Overview

Table of Contents

Preface; The Basic Layout of This Book; Software Versions and Availability; Conventions Used in This Book; Using Code Examples; How to Contact Us; Acknowledgments; Chapter 1: Back To Basics; 1.1 Binary Versus Compiled-From-Source Installations; 1.2 Configuration Files; 1.3 The SHOW Commands; Chapter 2: Storage Engines (Table Types); 2.1 MySQL Architecture; 2.2 Locking and Concurrency; 2.3 Transactions; 2.4 Selecting the Right Engine; 2.5 The Storage Engines; Chapter 3: Benchmarking; 3.1 The Importance of Benchmarking; 3.2 Benchmarking Strategies; 3.3 Benchmarking Tools; Chapter 4: Indexes; 4.1 Indexing Basics; 4.2 Index Structures; 4.3 Indexes and Table Types; 4.4 Index Maintenance; Chapter 5: Query Performance; 5.1 Query Processing Basics; 5.2 Optimizer Features and Oddities; 5.3 Identifying Slow Queries; 5.4 Influencing MySQL with Hints; 5.5 Stupid Query Tricks; Chapter 6: Server Performance Tuning; 6.1 Performance-Limiting Factors; 6.2 RAID; 6.3 Operating System; 6.4 Techniques; Chapter 7: Replication; 7.1 Replication Overview; 7.2 Configuring Replication; 7.3 Under the Hood; 7.4 Replication Architectures; 7.5 Administration and Maintenance; 7.6 Common Problems; 7.7 The Future of Replication; Chapter 8: Load Balancing and High Availability; 8.1 Load Balancing Basics; 8.2 Configuration Issues; 8.3 Cluster Partitioning; 8.4 High Availability; Chapter 9: Backup and Recovery; 9.1 Why Backups?; 9.2 Considerations and Tradeoffs; 9.3 Tools and Techniques; 9.4 Rolling Your Own Backup Script; Chapter 10: Security; 10.1 Account Basics; 10.2 The Grant Tables; 10.3 Grant and Revoke; 10.4 Operating System Security; 10.5 Network Security; 10.6 Data Encryption; 10.7 MySQL in a chrooted Environment; Appendix A: The SHOW STATUS and SHOW INNODB STATUS Commands; A.1 SHOW STATUS; A.2 SHOW INNODB STATUS; Appendix B: mytop; B.1 Overview; B.2 Getting mytop; B.3 Configuration and Usage; B.4 Common Tasks; Appendix C: phpMyAdmin; C.1 The Basics; C.2 Practical Examples; Colophon;|Preface Chapter 1: Back To Basics Chapter 2: Storage Engines (Table Types) Chapter 3: Benchmarking Chapter 4: Indexes Chapter 5: Query Performance Chapter 6: Server Performance Tuning Chapter 7: Replication Chapter 8: Load Balancing and High Availability Chapter 9: Backup and Recovery Chapter 10: Security Appendix A: The SHOW STATUS and SHOW INNODB STATUS Commands Appendix B: mytop Appendix C: phpMyAdmin Colophon

‹  Return to Product Overview