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

Sveta Smirnova

買這商品的人也買了...

商品描述

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

商品描述(中文翻譯)

被困在錯誤、性能問題、崩潰、數據損壞和令人困惑的輸出中嗎?如果你是一個數據庫程序員或數據庫管理員,這些問題是你生活的一部分。關鍵是知道如何快速從這些問題中恢復。這本獨特的書籍充滿了實例,向你展示了如何處理與MySQL一起工作時的各種棘手問題。

《MySQL故障排除》是由Oracle的首席技術支援工程師撰寫的,提供了解決從簡單到複雜的問題所需的背景、工具和專家步驟,無論是你認為已經插入的數據在查詢中找不到,還是整個數據庫因服務器故障而損壞。有了這本書在手,你將更有信心地工作。

本書內容包括:
- 瞭解問題的來源,即使解決方案很簡單
- 處理應用程序在多個線程運行時出現的問題
- 調試和修復由配置選項引起的問題
- 發現操作系統調優如何影響你的服務器
- 使用特定於複製問題的故障排除技術
- 獲取其他故障排除技術和工具的參考,包括第三方解決方案
- 學習安全有效的故障排除和預防問題的最佳實踐