MySQL性能调优
课程名称：MySQL 5.0 Performance Tuning适用对象：负责MySQL服务器日常维护的数据库管理员；数据库开发设计或与MySQL数据库相关的开发人员；其系统与MySQL服务器相关或与MySQL管理员合作的系统管理员；能够熟练阅读英文原版教材课时：3-5天
相关证书：CMDBA/CMDEV认证
授课教师：MySQL社区认证教师
价格：RMB___（人多价格更低）
授课形式：讲解，练习，考试
学习完成该课程，你将能够：
[*]描述 MySQL 体系结构，一般操作特性及运行中的资源利用
[*]利用 MySQL 应用中包含的多种程序完成数据库管理任务
[*]利用 MySQL 管理员图形用户界面管理 MySQL 服务器
[*]利用 INFORMATION_SCHEMA 数据库访问元数据
[*]为最常用的操作系统安装及更新 MySQL 5.0
[*]完成 MySQL 启动和关闭操作
[*]在运行时间配置 MySQL 服务器选项
[*]激活和管理众多的服务器日志
[*]为解决性能问题评估数据类型及字符集
[*]了解数据锁定概念以及在 MySQL 中不同级别的锁定
[*]MySQL 中多种存储引擎的区别
[*]建立、维护和管理 MySQL 表
[*]利用多种 MySQL 工具完成备份及恢复操作
[*]管理访问 MySQL 服务器的用户
[*]提升 MySQL 服务器的安全性
[*]采用存储事务及触发器执行管理任务
[*]管理，应用及了解使用视图的理由
[*]查询优化以改善性能
[*]利用多重技巧优化Schemas （数据库）
[*]利用 MySQL 监视工具分析服务器性能问题
[*]选择合适的启动选项以改善服务器性能
培训提纲：
Introduction
[*]MySQL Overview
[*]MySQL Products and Tools
[*]MySQL Services and Support
[*]MySQL Web Pages
[*]MySQL Courses
[*]MySQL Certification
[*]MySQL Documentation
Performance Tuning Basics
[*]Thinking About Performance
[*]Areas to Tune
[*]Performance Tuning Terminology
[*]Benchmark Planning
[*]Benchmark Errors
[*]Tuning Steps
[*]General Tuning Session
[*]Deploying MySQL and Benchmarking
Performance Tuning Tools
[*]MySQL Monitoring Tools
[*]Open Source Community Monitoring Tools
[*]Benchmark Tools
[*]Stress Tools
MySQL Server Tuning
[*]Major Components of the MySQL Server
[*]MySQL Thread Handling
[*]MySQL Memory Usage
[*]Simultaneous Connections in MySQL
[*]Reusing Threads
[*]Effects of Thread Caching
[*]Reusing Tables
[*]Setting table_open_cache
MySQL Query Cache
[*]MySQL Query Cache
[*]When to Use the MySQL Query Cache
[*]When NOT to Use the MySQL Query Cache
[*]MySQL Query Cache Settings
[*]MySQL Query Cache Status Variables
[*]Improve Query Cache Results
InnoDB
[*]InnoDB Storage Engine
[*]InnoDB Storage Engine Uses
[*]Using the InnoDB Storage Engine
[*]InnoDB Log Files and Buffers
[*]Committing Transactions
[*]InnoDB Table Design
[*]SHOW ENGINE INNODB STATUS
[*]InnoDB Monitors and Settings
MyISAM
[*]MyISAM Storage Engine Uses
[*]MyISAM Table Design
[*]Optimizing MyISAM
[*]MyISAM Table Locks
[*]MyISAM Settings
[*]MyISAM Key Cache
[*]MyISAM Full-Text Search
Other MySQL Storage Engines and Issues
[*]Large Objects
[*]MEMORY Storage Engine Uses
[*]MEMORY Storage Engine Performance
[*]Multiple Storage Engine Advantages
[*]Single Storage Engine Advantages
Schema Design and Performance
[*]Schema Design Considerations
[*]Normalization and Performance
[*]Schema Design
[*]Data Types
[*]Indexes
[*]Partitioning
MySQL Query Performance
[*]General SQL Tuning Best Practices
[*]EXPLAIN
[*]MySQL Optimizer
[*]Finding Problematic Queries
[*]Improve Query Executions
[*]Locate and Correct Problematic Queries
Performance Tuning Extras
[*]Configuring Hardware
[*]Considering Operating Systems
[*]Operating Systems Configurations
[*]Logging
[*]Backup and Recovery
Conclusion
[*]Course Overview
[*]Training and Certification Website
[*]Course Evaluation
[*]Thank You!
[*]Q&A Session
怎么报名呀？有没有具体的联系方式。 这个是哪里的 看起来很专业的样子，还是先把manual手册认真看一看再说。 更新
http://www.mysqlpub.com/portal.php?mod=topic&topicid=17
页:
[1]