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

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

<div><p>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 problems when working with MySQL.</p><p>Written by a principal technical support engineer at Oracle, <i>MySQL Troubleshooting</i> 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.</p><ul><li>Understand the source of a problem, even when the solution is simple</li><li>Handle problems that occur when applications run in multiple threads</li><li>Debug and fix problems caused by configuration options</li><li>Discover how operating system tuning can affect your server</li><li>Use troubleshooting techniques specific to replication issues</li><li>Get a reference to additional troubleshooting techniques and tools, including third-party solutions</li><li>Learn best practices for safe and effective troubleshooting—and for preventing problems</li></ul></div>