High Performance MySQL: Optimization, Backups, Replication, and More - page 1
- Main Page
- Main Page
- Table of content
- Copyright
- About the Author
- About the Technical Reviewers
- Acknowledgments
- First Edition
- Second Edition
- Tell Us What You Think
- Introduction
- Why Choose MySQL?
- Already Running Another RDBMS?
- Tools Provided with MySQL
- What You Can Expect from This Book
- Road Map to This Book
- How to Read This Book
- Versions of Software Covered in This Book
- Conventions Used in This Book
- Additional Resources
- Part I: General MySQL Use
- Chapter 1. Getting Started with MySQL and SQL
- How MySQL Can Help You
- A Sample Database
- Basic Database Terminology
- A MySQL Tutorial
- Tips for Interacting with mysql
- Where to Now?
- Chapter 2. Working with Data in MySQL
- MySQL Data Types
- MySQL Column Types
- Working with Sequences
- Character Set Support
- Choosing Column Types
- Expression Evaluation and Type Conversion
- Chapter 3. MySQL SQL Syntax and Use
- MySQL Naming Rules
- Selecting, Creating, Dropping, and Altering Databases
- Creating, Dropping, Indexing, and Altering Tables
- Getting Information about Databases and Tables
- Retrieving Records from Multiple Tables
- Multiple-Table Deletes and Updates
- Performing Transactions
- Foreign Keys and Referential Integrity
- Using FULLTEXT Searches
- Writing Comments
- Features That MySQL Does Not Support
- Chapter 4. Query Optimization
- Using Indexing
- The MySQL Query Optimizer
- Column Type Choices and Query Efficiency
- Loading Data Efficiently
- Scheduling and Locking Issues
- Optimization for Administrators
- Part II: Using MySQL Programming Interfaces
- Chapter 5. Introduction to MySQL Programming
- Why Write Your Own MySQL Programs?
- APIs Available for MySQL
- Choosing an API
- Chapter 6. The MySQL C API
- General Procedure for Building Client Programs
- Client 1Connecting to the Server
- Client 2Adding Error Checking
- Client 3Getting Connection Parameters at Runtime
- Processing Queries
- Client 4An Interactive Query Program
- Writing Clients That Include SSL Support
- Using the Embedded Server Library
- Miscellaneous Topics
- Chapter 7. The Perl DBI API
- Perl Script Characteristics
- Perl DBI Overview
- Putting DBI to Work
- Using DBI in Web Applications
- Chapter 8. The PHP API
- PHP Overview
- Putting PHP to Work
- Part III: MySQL Administration
- Chapter 9. Introduction to MySQL Administration
- Overview of Administrative Duties
