High Performance MySQL, 4th Edition

by Silvia Botros, Jeremy Tinley

Programming

Book Details

Book Title

High Performance MySQL, 4th Edition

Author

Silvia Botros; Jeremy Tinley

Publisher

.O'Reilly Media, Inc

Publication Date

2021

ISBN

9781492080510

Number of Pages

389

Language

English

Format

PDF

File Size

2.38MB

Subject

Database > MySQL

Table of Contents

  • Copyright
  • Table of Contents
  • Foreword
  • Preface
  • Chapter 1: MySQL Architecture
  • MySQL’s Logical Architecture
  • Concurrency Control
  • Transactions
  • Multiversion Concurrency Control
  • Replication
  • Datafiles Structure
  • The InnoDB Engine
  • Summary
  • Chapter 2: Monitoring in a Reliability Engineering World
  • The Impact of Reliability Engineering on DBA Teams
  • Defining Service Level Goals
  • What to Measure
  • Measuring Long-Term Performance
  • Summary
  • Chapter 3: Performance Schema
  • Introduction to Performance Schema
  • Configuration
  • Using Performance Schema
  • Summary
  • Chapter 4: Operating System and Hardware Optimization
  • What Limits MySQL’s Performance?
  • How to Select CPUs for MySQL
  • Balancing Memory and Disk Resources
  • Solid-State Storage
  • RAID Performance Optimization
  • Network Configuration
  • Choosing a Filesystem
  • Summary
  • Chapter 5: Optimizing Server Settings
  • How MySQL’s Configuration Works
  • What Not to Do
  • Creating a MySQL Configuration File
  • Configuring Memory Usage
  • Configuring MySQL’s I/O Behavior
  • Configuring MySQL Concurrency
  • Safety Settings
  • Advanced InnoDB Settings
  • Summary
  • Chapter 6: Schema Design and Management
  • Choosing Optimal Data Types
  • Schema Design Gotchas in MySQL
  • Schema Management
  • Summary
  • Chapter 7: Indexing for High Performance
  • Indexing Basics
  • Indexing Strategies for High Performance
  • Index and Table Maintenance
  • Summary
  • Chapter 8: Query Performance Optimization
  • Why Are Queries Slow?
  • Slow Query Basics: Optimize Data Access
  • Ways to Restructure Queries
  • Query Execution Basics
  • Limitations of the MySQL Query Optimizer
  • Optimizing Specific Types of Queries
  • Summary
  • Chapter 9: Replication
  • Replication Overview
  • Replication Under the Hood
  • Replication Failover
  • Replication Topologies
  • Replication Administration and Maintenance
  • Replication Problems and Solutions
  • Summary
  • Chapter 10: Backup and Recovery
  • Why Backups?
  • Defining Recovery Requirements
  • Designing a MySQL Backup Solution
  • Managing and Backing Up Binary Logs
  • Backup and Recovery Tools
  • Backing Up Data
  • Recovering from a Backup
  • Summary
  • Chapter 11: Scaling MySQL
  • What Is Scaling?
  • Read- Versus Write-Bound Workloads
  • Functional Sharding
  • Scaling Reads with Read Pools
  • Queuing
  • Scaling Writes with Sharding
  • Summary
  • Chapter 12: MySQL in the Cloud
  • Managed MySQL
  • MySQL on Virtual Machines
  • Summary
  • Chapter 13: Compliance with MySQL
  • What Is Compliance?
  • Building for Compliance Controls
  • Summary
  • Appendix A: Upgrading MySQL
  • Appendix B: MySQL on Kubernetes
  • Index
  • About the Authors
  • Colophon