Shop now Shop now Shop now  Up to 70% Off Fashion  Shop all Amazon Fashion Cloud Drive Photos Shop now Learn More Shop now Shop now Shop Fire Shop Kindle Shop now Shop now Shop now

Buy Used
Used - Very Good See details
Price: £6.66

or
 
   
Have one to sell? Sell yours here
Tell the Publisher!
Iíd like to read this book on Kindle

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

High Performance MySQL: Optimization, Backups, Replication, and More [Paperback]

Baron Schwartz , Peter Zaitsev , Vadim Tkachenko , Jeremy D. Zawodny , Arjen Lentz , Derek J. Balling
4.8 out of 5 stars  See all reviews (6 customer reviews)

Available from these sellers.


‹  Return to Product Overview

Table of Contents

Foreword; Preface; How This Book Is Organized; Software Versions and Availability; Conventions Used in This Book; Using Code Examples; Safari® Books Online; How to Contact Us; Acknowledgments for the Second Edition; Acknowledgments for the First Edition; Chapter 1: MySQL Architecture; 1.1 MySQL's Logical Architecture; 1.2 Concurrency Control; 1.3 Transactions; 1.4 Multiversion Concurrency Control; 1.5 MySQL's Storage Engines; Chapter 2: Finding Bottlenecks: Benchmarking and Profiling; 2.1 Why Benchmark?; 2.2 Benchmarking Strategies; 2.3 Benchmarking Tactics; 2.4 Benchmarking Tools; 2.5 Benchmarking Examples; 2.6 Profiling; 2.7 Operating System Profiling; Chapter 3: Schema Optimization and Indexing; 3.1 Choosing Optimal Data Types; 3.2 Indexing Basics; 3.3 Indexing Strategies for High Performance; 3.4 An Indexing Case Study; 3.5 Index and Table Maintenance; 3.6 Normalization and Denormalization; 3.7 Speeding Up ALTER TABLE; 3.8 Notes on Storage Engines; Chapter 4: Query Performance Optimization; 4.1 Slow Query Basics: Optimize Data Access; 4.2 Ways to Restructure Queries; 4.3 Query Execution Basics; 4.4 Limitations of the MySQL Query Optimizer; 4.5 Optimizing Specific Types of Queries; 4.6 Query Optimizer Hints; 4.7 User-Defined Variables; Chapter 5: Advanced MySQL Features; 5.1 The MySQL Query Cache; 5.2 Storing Code Inside MySQL; 5.3 Cursors; 5.4 Prepared Statements; 5.5 User-Defined Functions; 5.6 Views; 5.7 Character Sets and Collations; 5.8 Full-Text Searching; 5.9 Foreign Key Constraints; 5.10 Merge Tables and Partitioning; 5.11 Distributed (XA) Transactions; Chapter 6: Optimizing Server Settings; 6.1 Configuration Basics; 6.2 General Tuning; 6.3 Tuning MySQL's I/O Behavior; 6.4 Tuning MySQL Concurrency; 6.5 Workload-Based Tuning; 6.6 Tuning Per-Connection Settings; Chapter 7: Operating System and Hardware Optimization; 7.1 What Limits MySQL's Performance?; 7.2 How to Select CPUs for MySQL; 7.3 Balancing Memory and Disk Resources; 7.4 Choosing Hardware for a Slave; 7.5 RAID Performance Optimization; 7.6 Storage Area Networks and Network-Attached Storage; 7.7 Using Multiple Disk Volumes; 7.8 Network Configuration; 7.9 Choosing an Operating System; 7.10 Choosing a Filesystem; 7.11 Threading; 7.12 Swapping; 7.13 Operating System Status; Chapter 8: Replication; 8.1 Replication Overview; 8.2 Setting Up Replication; 8.3 Replication Under the Hood; 8.4 Replication Topologies; 8.5 Replication and Capacity Planning; 8.6 Replication Administration and Maintenance; 8.7 Replication Problems and Solutions; 8.8 How Fast Is Replication?; 8.9 The Future of MySQL Replication; Chapter 9: Scaling and High Availability; 9.1 Terminology; 9.2 Scaling MySQL; 9.3 Load Balancing; 9.4 High Availability; Chapter 10: Application-Level Optimization; 10.1 Application Performance Overview; 10.2 Web Server Issues; 10.3 Caching; 10.4 Extending MySQL; 10.5 Alternatives to MySQL; Chapter 11: Backup and Recovery; 11.1 Overview; 11.2 Considerations and Tradeoffs; 11.3 Managing and Backing Up Binary Logs; 11.4 Backing Up Data; 11.5 Recovering from a Backup; 11.6 Backup and Recovery Speed; 11.7 Backup Tools; 11.8 Scripting Backups; Chapter 12: Security; 12.1 Terminology; 12.2 Account Basics; 12.3 Operating System Security; 12.4 Network Security; 12.5 Data Encryption; 12.6 MySQL in a chrooted Environment; Chapter 13: MySQL Server Status; 13.1 System Variables; 13.2 SHOW STATUS; 13.3 SHOW INNODB STATUS; 13.4 SHOW PROCESSLIST; 13.5 SHOW MUTEX STATUS; 13.6 Replication Status; 13.7 INFORMATION_SCHEMA; Chapter 14: Tools for High Performance; 14.1 Interface Tools; 14.2 Monitoring Tools; 14.3 Analysis Tools; 14.4 MySQL Utilities; 14.5 Sources of Further Information; Transferring Large Files; Copying Files; File Copy Benchmarks; Using EXPLAIN; Invoking EXPLAIN; The Columns in EXPLAIN; Visual EXPLAIN; Using Sphinx with MySQL; Overview: A Typical Sphinx Search; Why Use Sphinx?; Architectural Overview; Special Features; Practical Implementation Examples; Conclusion; Debugging Locks; Lock Waits at the Server Level; Lock Waits in Storage Engines; Colophon;|

  • Foreword
  • Preface
  • Chapter 1: MySQL Architecture
  • Chapter 2: Finding Bottlenecks: Benchmarking and Profiling
  • Chapter 3: Schema Optimization and Indexing
  • Chapter 4: Query Performance Optimization
  • Chapter 5: Advanced MySQL Features
  • Chapter 6: Optimizing Server Settings
  • Chapter 7: Operating System and Hardware Optimization
  • Chapter 8: Replication
  • Chapter 9: Scaling and High Availability
  • Chapter 10: Application-Level Optimization
  • Chapter 11: Backup and Recovery
  • Chapter 12: Security
  • Chapter 13: MySQL Server Status
  • Chapter 14: Tools for High Performance
  • Transferring Large Files
  • Using EXPLAIN
  • Using Sphinx with MySQL
  • Debugging Locks
  • Colophon

‹  Return to Product Overview