Smirnova S. MySQL Troubleshooting: What To Do When Queries Don't Work

O’Reilly Media, 2012. - 244 p. - ISBN: 1449312004Written by a principal technical support engineer at Oracle, MySQL Troubleshooting provides the background, tools, and expert steps for solving problems from simple to complex—whether data you thought you inserted doesn’t turn up in a query, or the entire database is corrupt because of a server failure. With this book in hand, you’ll work with more confidence.Understand the source of a problem, even when the solution is simple
Handle problems that occur when applications run in multiple threads
Debug and fix problems caused by configuration options
Discover how operating system tuning can affect your server
Use troubleshooting techniques specific to replication issues
Get a reference to additional troubleshooting techniques and tools, including third-party solutions
Learn best practices for safe and effective troubleshooting—and for preventing problems