[접수중] 메이커들의 DIY 축제! Maker Faire Seoul 2014 (9월20일~21일)


> > MySQL Troubleshooting
MySQL Troubleshooting

크게보기 미리보기

MySQL Troubleshooting

Sveta Smirnova 지음 | 원서 | 2012년 02월 | OReilly Media

정가
36,000원
판매가
32,400원 (10% off)
이코인
1,620원 (5%)
배송비
무료 배송비란
상태
절판
독자리뷰
총 리뷰 0개 , 평균별점
블로거리뷰
총 리뷰 0
트랙백주소
http://www.hanbit.co.kr/trackback/9781449312008

페이지 : 264쪽 | ISBN : 9781449312008 | 난이도 : 중/고급 | 변환코드 : 8200

부록 : 없음

페이스북 트위터 미투데이 e메일
리뷰쓰기
  • 책소개
  • 저자소개
  • 목차
  • 독자리뷰
  • 블로거리뷰
  • 오탈자보기
  • 예제소스
  • 추천서적

책소개

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
맨위로

저자소개

Sveta Smirnova
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.


맨위로

목차

Chapter 1 : Basics 
    Incorrect Syntax
    Wrong Results from a SELECT
    When the Problem May Have Been a Previous Update
    Getting Information About a Query
    Tracing Back Errors in Data
    Slow Queries
    When the Server Does Not Answer
    Issues with Solutions Specific to Storage Engines
    Permission Issues

Chapter 2 : You Are Not Alone: Concurrency Issues 
    Locks and Transactions
    Locks
    Transactions
    Metadata Locking
    How Concurrency Affects Performance
    Other Locking Issues
    Replication and Concurrency
    Effectively Using MySQL Troubleshooting Tools

Chapter 3 : Effects of Server Options 
    Service Options
    Variables That Are Supposed to Change the Server Behavior
    Options That Limit Hardware Resources
    Using the --no-defaults Option
    Performance Options
    Haste Makes Waste
    The SET Statement
    How to Check Whether Changes Had an Effect
    Descriptions of Variables

Chapter 4 : MySQL’s Environment 
    Physical Hardware Limits
    Operating System Limits
    Effects of Other Software

Chapter 5 : Troubleshooting Replication 
    Displaying Slave Status
    Problems with the I/O Thread
    Problems with the SQL Thread

Chapter 6 : Troubleshooting Techniques and Tools 
    The Query
    Effects of the Environment
    Sandboxes
    Errors and Logs
    Information-Gathering Tools
    Localizing the Problem (Minimizing the Test Case)
    General Steps to Take in Troubleshooting
    Testing Methods
    Special Testing Tools
    Maintenance Tools

Chapter 7 : Best Practices 
    Backups
    Gathering the Information You Need
    Testing
    Prevention
    Think About It!

Appendix : Information Resources 
    Resources Containing Information That Is Usually Useful
    Bug and Knowledge Databases
    Expert Knowledge Online
    Places Where You Can Ask for Help
    Books

Colophon 
맨위로
독자리뷰
(총 리뷰 0개 , 평균별점 )   
리뷰쓰기
맨위로
블로거리뷰
(총 리뷰 0개)
 
맨위로

예제소스

등록된 예제소스가 없습니다.
맨위로

  • 회사소개
  • 인재채용
  • 기획 및 원고 모집
  • 이용약관
  • 개인정보취급방침
  • 고객센터
  • 사이트맵
Copyrightⓒ1993-2010 Hanbit Media, Inc. All rights reserved.

경영혁신형 중소기업 인증 소비자피해보상보험 가입사실확인 애니서트 인증마크