MySQL troubleshooting
Stuck with bugs, performance problems, crashes, data corruption, and puzzling output? If you're a database programmer or DBA, they're part of your life. The trick is knowing how to quickly recover from them. This unique, example-packed book shows you how to handle an array of vexing probl...
| Autor principal: | |
|---|---|
| Otros Autores: | , |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
O'Reilly
2012.
|
| Edición: | First edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628681806719 |
Tabla de Contenidos:
- Table of Contents; Foreword; Preface; Audience; How to Solve a Problem; How This Book Is Organized; Some Choices Made in This Book; Conventions Used in This Book; Using Code Examples; Safari® Books Online; How to Contact Us; Acknowledgments; Chapter 1. Basics; Incorrect Syntax; Wrong Results from a SELECT; When the Problem May Have Been a Previous Update; Getting Information About a Query; Tracing Back Errors in Data; Slow Queries; Tuning a Query with Information from EXPLAIN; Table Tuning and Indexes; When to Stop Optimizing; Effects of Options; Queries That Modify Data; No Silver Bullet
- When the Server Does Not AnswerIssues with Solutions Specific to Storage Engines; MyISAM Corruption; Repairing a MyISAM table from SQL; Repairing a MyISAM table using myisamchk; InnoDB Corruption; Permission Issues; Chapter 2. You Are Not Alone: Concurrency Issues; Locks and Transactions; Locks; Table Locks; Row Locks; Transactions; Hidden Queries; Deadlocks; Implicit Commits; Metadata Locking; Metadata Locking Versus the Old Model; How Concurrency Affects Performance; Monitoring InnoDB Transactions for Concurrency Problems; Monitoring Other Resources for Concurrency Problems
- Other Locking IssuesReplication and Concurrency; Statement-Based Replication Issues; Mixing Transactional and Nontransactional Tables; Issues on the Slave; Effectively Using MySQL Troubleshooting Tools; SHOW PROCESSLIST and the INFORMATION_SCHEMA.PROCESSLIST Table; SHOW ENGINE INNODB STATUS and InnoDB Monitors; INFORMATION_SCHEMA Tables; PERFORMANCE_SCHEMA Tables; Log Files; Chapter 3. Effects of Server Options; Service Options; Variables That Are Supposed to Change the Server Behavior; Options That Limit Hardware Resources; Using the
- no-defaults Option; Performance Options
- Haste Makes WasteThe SET Statement; How to Check Whether Changes Had an Effect; Descriptions of Variables; Options That Affect Server and Client Behavior; Server-related options; Replication options; Engine options; InnoDB options; MyISAM options; Connection-related options; Timeouts; Security-related options; Performance-Related Options; Buffers and maximums; Options that control the optimizer; Engine-related options; InnoDB options; MyISAM options; Calculating Safe Values for Options; Options set for the whole server; Thread options; Buffers allocated for a specific operation
- Chapter 4. MySQL's EnvironmentPhysical Hardware Limits; RAM; Processors and Their Cores; Disk I/O; Network Bandwidth; Example of the Effect of Latencies; Operating System Limits; Effects of Other Software; Chapter 5. Troubleshooting Replication; Displaying Slave Status; Problems with the I/O Thread; Problems with the SQL Thread; When Data Is Different on the Master and Slave; Circular Replication and Nonreplication Writes on the Slave; Incomplete or Altered SQL Statements; Different Errors on the Master and Slave; Configuration; When the Slave Lags Far Behind the Master
- Chapter 6. Troubleshooting Techniques and Tools
