MYSQL 5.0考试大纲

Exam Contents - Certified MySQL DBA - I

• MySQL Architecture (10%)
  • Client/Server Overview
  • Communication Protocols
  • The SQL Parser and Storage Engine Tiers
  • How MySQL Uses Disk Space
  • How MySQL Uses Memory
• Starting, Stopping, and Configuring MySQL (20%)
  • 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
  • Loading Time Zone Tables
  • Security-Related Configuration
  • Setting the Default SQL Mode
  • Upgrading MySQL
• Client Programs for DBA Work (5%)
  • Overview of Administrative Clients
  • mysql
  • mysqladmin
  • mysqlimport
  • mysqldump
  • Client Program Limitations
• Character Set Support (5%)
  • Performance Issues
  • Choosing Data Types for Character Columns
• Locking (10%)
  • Locking Concepts
  • Explicit Table Locking
  • Advisory Locking
• Storage Engines (20%)
  • MySQL Storage Engines
  • The MyISAM Engine
  • The MERGE Engine
  • The InnoDB Engine
  • The MEMORY Engine
  • The FEDERATED Engine
  • The Cluster Storage Engine
  • Other Storage Engines
• Data (Table) Maintenance (10%)
  • Types of Table Maintenance Operations
  • SQL Statements for Table Maintenance
  • Client and Utility Programs for Table Maintenance
  • Repairing InnoDB Tables
  • Enabling MyISAM Auto-Repair
• The INFORMATION_SCHEMA Database (5%)
  • INFORMATION_SCHEMA Access Syntax
  • INFORMATION_SCHEMA Versus SHOW
  • Limitations of INFORMATION_SCHEMA
• Data Backup and Recovery Methods (15%)
  • Introduction
  • Binary Versus Textual Backups
  • Making Binary Backups
  • Making Text Backups
  • Backing Up Log and Status Files
  • Replication as an Aid to Backup
  • MySQL Cluster as Disaster Prevention
  • Data Recovery

Exam Contents - Certified MySQL DBA - II

• Stored Routines (5%)
  • Using Stored Routines and Triggers for Security Purposes
  • Using Stored Routines to Enhance Performance
• User Management (20%)
  • User Account Management
  • Client Access Control
• Securing the Server (10%)
  • Security Issues
  • Operating System Security
  • Filesystem Security
  • Log Files and Security
  • Network Security
  • FEDERATED Table Security
• Upgrade-Related Security Issues (5%)
  • Upgrading the Privilege Tables
  • Security-Related SQL Mode Values
• Optimizing Queries (15%)
  • Identifying Candidates for Query Analysis
  • Using EXPLAIN to Analyze Queries
  • Using SHOW WARNINGS for Optimization
  • MyISAM Index Caching
• Optimizing Schemas (15%)
  • General Table Optimizations
  • Normalization
  • MyISAM-Specific Optimizations
  • InnoDB-Specific Optimizations
  • MERGE-Specific Optimizations
  • MEMORY-Specific Optimizations
• Optimizing the Server (10%)
  • Interpreting mysqld Server Information
  • Measuring Server Load
  • Tuning Memory Parameters
  • Using the Query Cache
• Interpreting Error Messages (5%)
  • Sources of Diagnostic Information
  • Using the Error Log for Diagnostic Purposes
  • Using The Slow Query Log for Diagnostic Purposes
• Optimizing the Environment (5%)
  • Choosing Hardware for MySQL Use
  • Configuring Disks for MySQL Use
  • Network Issues
  • Optimizing the Operating System for MySQL Use
• Scaling MySQL (10%)
  • Using Multiple Servers
  • Replication

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/308563/viewspace-598196/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/308563/viewspace-598196/