|
MySQL 5 Database Administrator Certified Professional Exam, Part I:
MySQL Architecture
- Communication Protocols
- The SQL Parser and Storage Engine Tiers
- How MySQL Uses Disk Space and Memory
Starting, Stopping, and Configuring MySQL
- Types of MySQL Distributions
- Starting and Stopping MySQL Server on Windows
- Starting and Stopping MySQL Server on Unix
- Runtime MySQL Configuration
- Log and Status Files
- Setting the Default SQL Mode
Client Programs for DBA Work
- Overview of Administrative Clients
- mysql
- mysqladmin
- mysqlimport
- mysqldump
- Client Program Limitations
Character Set Support
- Performance Issues
- Choosing Data Types for Character Columns
Locking
- Locking Concepts
- Explicit Table Locking
Storage Engines
- The MyISAM Engine
- The MERGE Engine
- The InnoDB Engine
- The MEMORY Engine
- The FEDERATED Engine
Data (Table) Maintenance
- Types of Table Maintenance Operations
- SQL Statements for Table Maintenance
- Client and Utility Programs for Table Maintenance
The INFORMATION_SCHEMA Database
Data Backup and Recovery Methods
- Making Binary Backups
- Making Text Backups
- Backing Up Log and Status Files
- Replication as an Aid to Backup
- Data Recovery
MySQL 5 Database Administrator Certified Professional Exam, Part II:
Stored Routines
User Management
- User Account Management
- Client Access Control
Securing the Server
- Security Issues
- Operating System Security
- Filesystem Security
- Log Files and Security
- Network Security
- FEDERATED Table Security
Upgrade-Related Security Issues
- Upgrading the Privilege Tables
- Security-Related SQL Mode Values
Optimizing Queries
- Identifying Candidates for Query Analysis
- Using EXPLAIN to Analyze Queries
- MyISAM Index Caching
Optimizing Schemas
- General Table Optimizations
- Normalization
- MyISAM-Specific Optimizations
- InnoDB-Specific Optimizations
Optimizing the Server
- Tuning Memory Parameters
- Using the Query Cache
Interpreting Error Messages
- Sources of Diagnostic Information
- Using the Error Log for Diagnostic Purposes
- Using The Slow Query Log for Diagnostic Purposes
Optimizing the Environment
- Configuring Disks for MySQL Use
- Network Issues
- Optimizing the Operating System for MySQL Use
Scaling MySQL
- Using Multiple Servers
- Replication
|
