Download Safari Books Online apps: Apple iOS | Android

Entire Site

Safari Books Online

    Free Trial

    Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

    Start ReadingShare
    MySQL Troubleshooting

    • MySQL Troubleshooting

    • By:

    • Publisher: O'Reilly Media, Inc.

    • Pub. Date:

    • Print ISBN-13: 978-1-4493-1200-8

    • Pages in Print Edition: 264

    • Subscriber Rating: 0 out of 5 rating0 [0 Ratings]

    1ebooken
    Subscriber Reviews • Browse Similar Topics

    Overview

    Sometimes applications can go mad: tables contain wrong data, users get random replies, server stop working, and so on. Several easy methods allow users to often find the problems quickly. This book, based on successful conference presentations by the author, cover SQL problems, memory and other server problems, replication, and problems related to particular storage engines.

    Subscriber Reviews

    Average Rating: 0 out of 5 rating Based on 0 Ratings

    No Subscribers have provided a review for this book.

    Table of Contents

     

    View Sample

    MySQL Troubleshooting

    View Sample

    Foreword

    View Sample
    Preface
    View Sample

    Audience

    View Sample

    How to Solve a Problem

    View Sample

    How This Book Is Organized

    View Sample

    Some Choices Made in This Book

    View Sample

    Conventions Used in This Book

    View Sample

    Using Code Examples

    View Sample

    Safari® Books Online

    View Sample

    How to Contact Us

    View Sample

    Acknowledgments

    View Sample
    Download ChapterDownload Chapter
    1 Token    1. Basics
    View Sample

    Incorrect Syntax

    View Sample

    Wrong Results from a SELECT

    View Sample

    When the Problem May Have Been a Previous Update

    View Sample

    Getting Information About a Query

    View Sample

    Tracing Back Errors in Data

    View Sample
    Slow Queries
    View Sample

    Tuning a Query with Information from EXPLAIN

    View Sample

    Table Tuning and Indexes

    View Sample

    When to Stop Optimizing

    View Sample

    Effects of Options

    View Sample

    Queries That Modify Data

    View Sample

    No Silver Bullet

    View Sample

    When the Server Does Not Answer

    View Sample
    Issues with Solutions Specific to Storage Engines
    View Sample

    MyISAM Corruption

    View Sample

    InnoDB Corruption

    View Sample

    Permission Issues

    View Sample
    Download ChapterDownload Chapter
    1 Token    2. You Are Not Alone: Concurrency Issues
    View Sample

    Locks and Transactions

    View Sample
    Locks
    View Sample

    Table Locks

    View Sample

    Row Locks

    View Sample
    Transactions
    View Sample

    Hidden Queries

    View Sample

    Deadlocks

    View Sample

    Implicit Commits

    View Sample
    Metadata Locking
    View Sample

    Metadata Locking Versus the Old Model

    View Sample
    How Concurrency Affects Performance
    View Sample

    Monitoring InnoDB Transactions for Concurrency Problems

    View Sample

    Monitoring Other Resources for Concurrency Problems

    View Sample

    Other Locking Issues

    View Sample
    Replication and Concurrency
    View Sample

    Statement-Based Replication Issues

    View Sample

    Mixing Transactional and Nontransactional Tables

    View Sample

    Issues on the Slave

    View Sample
    Effectively Using MySQL Troubleshooting Tools
    View Sample

    SHOW PROCESSLIST and the INFORMATION_SCHEMA.PROCESSLIST Table

    View Sample

    SHOW ENGINE INNODB STATUS and InnoDB Monitors

    View Sample

    INFORMATION_SCHEMA Tables

    View Sample

    PERFORMANCE_SCHEMA Tables

    View Sample

    Log Files

    View Sample
    Download ChapterDownload Chapter
    1 Token    3. Effects of Server Options
    View Sample

    Service Options

    View Sample

    Variables That Are Supposed to Change the Server Behavior

    View Sample

    Options That Limit Hardware Resources

    View Sample

    Using the --no-defaults Option

    View Sample

    Performance Options

    View Sample

    Haste Makes Waste

    View Sample

    The SET Statement

    View Sample

    How to Check Whether Changes Had an Effect

    View Sample
    Descriptions of Variables
    View Sample

    Options That Affect Server and Client Behavior

    View Sample

    Performance-Related Options

    View Sample

    Calculating Safe Values for Options

    View Sample

    4. MySQL’s Environment

    View Sample
    Physical Hardware Limits
    View Sample

    RAM

    View Sample

    Processors and Their Cores

    View Sample

    Disk I/O

    View Sample

    Network Bandwidth

    View Sample

    Example of the Effect of Latencies

    View Sample

    Operating System Limits

    View Sample

    Effects of Other Software

    View Sample
    Download ChapterDownload Chapter
    1 Token    5. Troubleshooting Replication
    View Sample

    Displaying Slave Status

    View Sample

    Problems with the I/O Thread

    View Sample
    Problems with the SQL Thread
    View Sample

    When Data Is Different on the Master and Slave

    View Sample

    Circular Replication and Nonreplication Writes on the Slave

    View Sample

    Incomplete or Altered SQL Statements

    View Sample

    Different Errors on the Master and Slave

    View Sample

    Configuration

    View Sample

    When the Slave Lags Far Behind the Master

    View Sample

    Download ChapterDownload Chapter
    1 Token    6. Troubleshooting Techniques and Tools

    View Sample
    The Query
    View Sample

    Slow Query Log

    View Sample

    Tools That Can Be Customized

    View Sample

    The MySQL Command-Line Interface

    View Sample

    Effects of the Environment

    View Sample

    Sandboxes

    View Sample
    Errors and Logs
    View Sample

    Error Information, Again

    View Sample

    Crashes

    View Sample
    Information-Gathering Tools
    View Sample

    Information Schema

    View Sample

    InnoDB Information Schema Tables

    View Sample

    InnoDB Monitors

    View Sample

    Performance Schema

    View Sample

    SHOW [GLOBAL] STATUS

    View Sample

    Localizing the Problem (Minimizing the Test Case)

    View Sample

    General Steps to Take in Troubleshooting

    View Sample
    Testing Methods
    View Sample

    Try the Query in a Newer Version

    View Sample

    Check for Known Bugs

    View Sample

    Workarounds

    View Sample
    Special Testing Tools
    View Sample

    Benchmarking Tools

    View Sample

    Gypsy

    View Sample

    MySQL Test Framework

    View Sample

    Maintenance Tools

    View Sample

    Download ChapterDownload Chapter
    1 Token    7. Best Practices

    View Sample
    Backups
    View Sample

    Planning Backups

    View Sample

    Types of Backups

    View Sample

    Tools

    View Sample
    Gathering the Information You Need
    View Sample

    What Does It All Mean?

    View Sample

    Testing

    View Sample
    Prevention
    View Sample

    Privileges

    View Sample

    Environment

    View Sample

    Think About It!

    View Sample
    Download ChapterDownload Chapter
    1 Token    A. Information Resources
    View Sample

    Resources Containing Information That Is Usually Useful

    View Sample

    Bug and Knowledge Databases

    View Sample

    Expert Knowledge Online

    View Sample

    Places Where You Can Ask for Help

    View Sample

    Books

    View Sample

    Index

    View Sample

    About the Author

    View Sample

    Colophon

    Extras

    The publisher has provided additional content related to this title.


    Description
    Content

    Visit the catalog page for MySQL Troubleshooting

    • Catalog Page

    Visit the errata page for MySQL Troubleshooting

    • Errata