Sign in  |  Register
Advanced search
Publication Cover

CITATION

Vaswani, Vikram. MySQL Database Usage & Administration. US: McGraw-Hill Osborne Media, 2009.

MySQL Database Usage & Administration

Authors: Vikram Vaswani

Published:  October 2009

eISBN: 9780071605502 0071605509 | ISBN: 9780071605496
Open eBook
  • Contents
  • Foreword
  • Acknowledgments
  • Introduction
  • Part I: Usage
  • 1 An Introduction to MySQL
  • History
  • Unique Features
  • Product Family
  • Technical Architecture
  • Applications
  • Summary
  • 2 Understanding Basic Commands
  • Understanding Basic Concepts
  • Working with Databases and Tables
  • Working with Records
  • Viewing Database, Table, and Field Information
  • Summary
  • 3 Making Design Decisions
  • Selecting Field Data Types
  • Selecting Table Storage Engines
  • Using Primary and Foreign Keys
  • Using Indexes
  • Summary
  • 4 Using Joins, Subqueries, and Views
  • Using Joins
  • Using Subqueries
  • Using Views
  • Summary
  • 5 Using Transactions
  • Understanding Transactions
  • Controlling Transactional Behavior
  • Pseudo-Transactions
  • Summary
  • 6 Using Stored Procedures and Functions
  • Understanding Stored Routines
  • Doing More with Stored Routines
  • Summary
  • 7 Using Triggers and Scheduled Events
  • Understanding Triggers
  • Understanding Scheduled Events
  • Summary
  • 8 Working with Data in Different Formats
  • Importing Records
  • Exporting Records
  • Working with XML Data
  • Summary
  • 9 Optimizing Performance
  • Optimizing Queries
  • Optimizing Joins and Subqueries
  • Optimizing Transactional Performance
  • Optimizing Stored Routines
  • Optimizing Table Design
  • Optimizing Server Settings
  • Benchmarking
  • Summary
  • Part II: Administration
  • 10 Performing Basic Server Administration
  • Database Administration and MySQL
  • Understanding Basic Server Administration
  • Obtaining Database Meta-Information
  • Summary
  • 11 Managing Users and Controlling Access
  • Understanding the Access Control System
  • Managing User Privileges
  • Working with User Accounts and Passwords
  • Summary
  • 12 Performing Maintenance, Backup, and Recovery
  • Using Database Log Files
  • Checking and Repairing Tables
  • Backing Up and Restoring Data
  • Summary
  • 13 Replicating Data
  • Understanding Replication
  • Configuring Master-Slave Replication
  • Configuring Master-Master Replication
  • Managing the Replication Process
  • Summary
  • A: Installing MySQL and the Sample Database
  • Obtaining MySQL
  • Installing and Configuring MySQL
  • Testing MySQL
  • Performing Post-Installation Steps
  • Setting Up the Example Database
  • Summary
  • Index