MySQL Troubleshooting
What To Do When Queries Don't Work
Publisher: O'Reilly Media
Final Release Date: February 2012
Pages: 266

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
Table of Contents
Product Details
About the Author
Colophon
Recommended for You
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreillyMySQL Troubleshooting
 
4.0

(based on 1 review)

Ratings Distribution

  • 5 Stars

     

    (0)

  • 4 Stars

     

    (1)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

Reviewed by 1 customer

Displaying review 1

Back to top

(1 of 4 customers found this review helpful)

 
4.0

Good Stuff for MySQL Troubleshooting

By surachart

from Bangkok, Thailand

About Me DBA, Educator, Sys Admin

Verified Reviewer

Pros

  • Accurate
  • Easy to understand
  • Helpful examples
  • Well-written

Cons

  • Too basic

Best Uses

  • Intermediate
  • Novice
  • Student

Comments about oreilly MySQL Troubleshooting:

This book has 7 chapters. On the chapter one, It's explained the simplest about something what I should know before; SQL syntax, MySQL command, some variables and etc. On the chapter two, "You are Not Alone: Concurrency Issues" – Concurrency is important for Database. This chapter is helpful for it. What I learn? For example: Lock and Transactions, Matadata Locking, Monitoring InnoDB Transaction and Concurrency Problems, etc. I believe a lot of DBAs see the lock/concurrency problem. It's good chapter, that's helpful. Anyway, MySQL has a lot of options/variables, So It's necessary to learn about them. The chapter three, I learned about some options/variables, that effect with database. Good!

That was a little from this book. I rather believe this book is useful for someone who works with MySQL as DBA or Developer.

In this book, it has a good paragraph arrangement. It helps readers easy for reading. It has a lot of examples. It's easy-understand. I think readers can read and practice in the same time. Anyway, I still believe this book be able to figure readers out for MySQL Troubleshooting idea.

Just some point, I think On the Chapter 4. It can add more examples. For example, OS command to help for troubleshooting.

By the way, this book is a good stuff for someone who need to troubleshoot MySQL.

Displaying review 1

Back to top

 
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook: $24.99
Formats:  ePub, Mobi, PDF
Print & Ebook: $32.99
Print: $29.99