陈老师:1415968548 郑老师:2735197625 乐老师:354331153
客服热线:
19941464235/19906632509(微信同号)

客服微信

MySQL 8.0性能优化实战培训

学习人数:435 课程类型:就业培训 课时长度:4天/24 课时
立即咨询
课程介绍
众多已经学习过MySQL 8.0 OCP认证专家的课程的同学们对 MySQL 8.0 的安装部署、体系结构、配置监控、用户管理、主从复制、系统运维、MGR等基础操作和动手实验有了一定的学习基础.很多学员反馈希望更进一步提升技术能力、解决工作中碰到的性能问题。针对MySQL的数据库性能优化部分,云贝资深数据库老师们推出新的进阶课程《MySQL性能优化》,以MySQL原厂课件作为蓝本,深入背后底层逻辑,理论与实战结合老师的一线大厂的丰富经验,安排预计4天的技术进阶课。

本课程不管是初来乍到的新同学还是面面俱到的老学员,欢迎大家来进修学习,共同交流、一起进步。



课程特点:Oracle原厂最新英文标准教材,理论+实验相结合授课

课程目标
完成本课程后,您应该能够:理解性能调优概念,理解影响性能的因素,
使用一系列性能调优工具,配置和使用性能方案,调整MySQL服务器实例,设计最佳性能方案,
了解MySQL如何优化查询,识别和修复缓慢的查询,诊断和解决常见的性能问题,识别和修复复制延迟。
课程大纲
第一章:Introduction
1.1.Introduction
1.2.Practice 1-1: Course Environment Overvie
第二章:Performance Tuning Concepts
2.1.Overview
2.2.Terminology
2.3.Benchmarking
2.4.Troubleshooting performance issues
2.5.Tuning steps
2.6.Deploying and maintaining MySQL
2.7.Practice 2-1: Quiz–Performance Tuning
第三章:Performance Tuning Tools
3.1.MySQL monitoring tools
3.2.Oracle DB monitoring tools
3.3.Community monitoring tools
3.4.Linux tools
3.5.Benchmarking tools
3.6.Practice 3-1: Using MySQL Command-Line Monitoring Tools
3.7.Practice 3-2: Using MySQL Enterprise Monitor
3.8.Practice 3-3: Using Benchmark Tools
3.9.Practice 3-4: Using Linux System Monitoring Tools
第四章:Performance Schema
4.1.What is Performance Schema
4.2.Schema overview
4.3.Configuration
4.4.The Instance and Connection Tables
4.5.Querying event data
4.6.The sys schema
4.7.MySQL Workbench performance tools
4.8.Practice 4-1: Examining the Performance Schema Configuration
4.9.Practice 4-2: Querying the Performance Schema
4.10.Practice 4-3: Using sys to Work with the Performance Schema
4.11.Practice 4-4: Using MySQL Workbench for Performance Schema Configuration, Monitoring, and Reporting
第五章:General_Server_Tuning
5.1.How MySQL uses memory
5.2.Calculating maximum MySQL memory usage
5.3.Managing connections
5.4.Tuning threads
5.5.Practice 5-1: Calculating Total Thread Memory Usage
5.5.Practice 5-2: Managing the Number of Client Connections
5.6.Practice 5-3: Investigating the Effects of Multiple Simultaneous Connections
5.7.Practice 5-4: Investigating the Effects of Thread Caching
第六章:Tables_Files_Logs
6.1.Sizing the table cache
6.2.Managing tables and files
6.3.Tuning the binary logs
6.4.Practice 6-1: Sizing the Table Cache
6.5.Practice 6-2: Tuning Open Files Limit
6.6.Practice 6-3: Sizing the Binary Log Cache
6.7.Practice 6-4: Identifying I/O Hotspots with MySQL Workbench
第七章:Tuning_InnoDB
7.1.What is InnoDB
7.2.How does InnoDB work
7.3.Tuning InnoDB buffer pool and log files
7.4.Measuring InnoDB performance
7.5.Practice 7-1: Investigating the Effects of Log Files on Transactions
7.6.Practice 7-2: Using SHOW ENGINE INNODB STATUS
7.7.Practice 7-3: Monitoring InnoDB Metrics in the Information Schema
7.8.Practice 7-4: Evaluating InnoDB Buffer Pool Size
第八章:Optimizing_Your_Schema
8.1.Schema design considerations
8.2.Indexes
8.3.InnoDB table compression
8.4.Partitioning tables
8.5.Practice 8-1: Comparing the Effects of Table Normalization on Query Performance
8.6.Practice 8-2: Choosing the Correct Data Type
8.7.Practice 8-3: Compressing Tables
8.8.Practice 8-4: Partitioning
第九章:Monitoring_Queries
9.1.Identifying candidate queries for optimization
9.2.Server logs
9.3.Statement status variables
9.4.Performance Schema and sys
9.5.Graphical tools
9.6.Practice 9-1: Monitoring Statements
9.7.Practice 9-2: Using the Slow Query Log
9.8.Practice 9-3: Identifying Slow Queries with MySQL Enterprise Monitor Query Analyzer
9.9.Practice 9-4: Identifying Slow Queries with sys Views
9.10.Practice 9-5: Using MySQL Workbench Query Statistics
第十章:Optimizing_Queries
10.1.How the optimizer works
10.2.Understanding the query plan
10.3.Optimizing queries
10.4.Practice 10-1: Understanding the Query Execution Plan with the EXPLAIN Statement
10.5.Practice 10-2: Improving the Performance of a Query
10.6.Practice 10-3: Tracing the Optimizer
第十一章:Optimizing_Locking
11.1.How MySQL locking works
11.2.InnoDB lock types
11.3.Metadata locks
11.4.Viewing lock information with SQL statements
11.5.Investigating locks by querying system databases
11.6.Practice 11-1: Troubleshooting Blocked Queries
11.7.Practice 11-2: Investigating Metadata Locks
第十二章:Tuning_Replication
12.1.Replication overview
12.2.Understanding replication lag
12.3.Diagnosing replication lag
12.4.Resolving replication lag
12.5.Practice 12-1: Diagnosing Replication Lag by Using Binary Log File Name and Position
12.6.Practice 12-2: Diagnosing Replication Lag by Using GTID Sets
第十三章:Conclusion
13.1.Conclusion
讲师信息

郭一军

云贝教育创始人  腾讯云TVP  PostgreSQL ACED

腾讯云TDSQL首席讲师,ITPUB论坛社区资深版主,有丰富的IT领域知识经验。阿里云官方授权讲师,腾讯云官方授权讲师,Oracle 官方授权讲师,中国PostgreSQL分会官方授权讲师,北京吉利大学企业导师。历任过连连支付首席DBA、唯品会高级数据库专家、吉利汽车研究院云计算平台技术负责人。负责连连支付核心交易库的开发与运维、经历唯品会大规模(5000+个实例)MySQL数据库的架构设计和运维,主导吉利汽车上亿级的私有云项目及智能驾驶200Pb数据存储架构设计。有10+年的数据库授课经验,曾给中国人民银行、中国银行、中国农行、中国建行、中国银联、中国邮政、平安银行、招商银行、上海银行、上海农商行、昆山农商行、重庆农商行、浙农信、兴业银行、菲律宾银行、浦发硅谷银行、秦皇岛银行、湖州银行、东莞银行、海峡银行、中泰证券、太平洋保险、太平保险等企业开展内训。后来创建云贝教育,言传身教,亲自讲授云计算、大数据、数据库等方面的几十门课程。为中国IT业特别是数据库行业输送了大量人才,引领无数弟子进入业界,广受尊重。
推荐课程

MySQL 8.0 OCP专家认证课程

数据库交付运维工程师-腾讯云TDSQL(MySQL版)

数据库交付运维高级工程师-腾讯云TDSQL(MySQL版)

数据库交付运维专家-腾讯云TDSQL(MySQL版)