- 积分
- 6147
- UID
- 2
- 阅读权限
- 200
- 注册时间
- 2007-3-19
- 精华
- 在线时间
- 小时
- 最后登录
- 1970-1-1
- 职业
- 1
|
课程名称: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
|
|