×

Uh-oh, it looks like your Internet Explorer is out of date.

For a better shopping experience, please upgrade now.

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

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

by Sveta Smirnova
 

See All Formats & Editions

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.

Written by a principal

Overview

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.

Written 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

Product Details

ISBN-13:
9781449330231
Publisher:
O'Reilly Media, Incorporated
Publication date:
02/08/2012
Sold by:
Barnes & Noble
Format:
NOOK Book
Pages:
266
File size:
5 MB

Related Subjects

Meet the Author

Sveta Smirnova is a Principal Technical Support Engineer in the BugsAnalysis Support Group at MySQL at Oracle. She works on trickysupport issues and MySQL software bugs on a daily basis. Before starting at MySQL in 2006, she worked as web developer on severalclosed CRM systems. She is an active participant in the open sourcecommunity. Her main interests in recent years is solving DBA problems and finding ways to semi-automate this process.

Customer Reviews

Average Review:

Post to your social network

     

Most Helpful Customer Reviews

See all customer reviews