ITPub博客

首页 > Linux操作系统 > Linux操作系统 > MYSQL 5.0考试大纲

MYSQL 5.0考试大纲

原创 Linux操作系统 作者:xhailiang 时间:2009-05-15 08:43:19 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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-02-17

  • 博文量
    270
  • 访问量
    422393