MySQL Troubleshooting

MySQL Troubleshooting

O'Reilly Media (Feb2012) | ISBN-13: 978-1449312008

PDF |  264 pages | 7.5 MB

Stuck with bugs, performance problems, crashes, data corruption, and puzzling output? If you are a database programmer or DBA, they are 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

 Chapter 1. Basics

 Chapter 2. You Are Not Alone: Concurrency Issues

 Chapter 3. Effects of Server Options

 Chapter 4. MySQL’s Environment

 Chapter 5. Troubleshooting Replication

 Chapter 6. Troubleshooting Techniques and Tools

 Chapter 7. Best Practices

Download Link

Beginning Database Design

Beginning Database Design
PDF | 496 Pages | 10.65 MB

This book focuses on the relational database model from a beginning perspective. The title is, therefore, Beginning Database Design. A database is a repository for data. In other words, you can store lots of information in a database. A relational database is a special type of database using structures called tables. Tables are linked together using what are called relationships. You can build tables with relationships between those tables, not only to organize your data, but also to allow later retrieval of information from the database.

* The perfect reference for programmers, administrators, or Web designers who are new to database development and are uncertain as to how to design and structure a database efficiently
* Shows how to design and implement robust, scalable databases on any of the major relational database management systems, including Access, SQL Server, IBM DB2, MySQL, and Oracle
* Covers all the key database design steps including modeling, normalization, SQL, denormalization, object-modeling, data warehousing, and performance
* Provides plenty of real-world examples and a complete beginning-to-end case study of creating a database that includes the analysis and planning, tables and data structures, business rules, and hardware requirements


Download Link

Learning SQL

Learning SQL
English | CHM | 601 KB
 

SQL (Structured Query Language) is a standard programming language for generating, manipulating, and retrieving information from a relational database. If you're working with a relational database--whether you're writing applications, performing administrative tasks, or generating reports--you need to know how to interact with your data. Even if you are using a tool that generates SQL for you, such as a reporting tool, there may still be cases where you need to bypass the automatic generation feature and write your own SQL statements.


To help you attain this fundamental SQL knowledge, look to Learning SQL, an introductory guide to SQL, designed primarily for developers just cutting their teeth on the language.


Download Link