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

客服微信

MySQL 8.0性能优化实战培训

学习人数:435 课程类型:就业培训 课时长度:4天/24 课时
立即咨询
课程介绍

【云贝独家】MySQL 性能优化进阶课程,引领你的职业巅峰!
同学们,你们是否被各种工作中的性能问题困扰?是否渴望提升自己在MySQL数据库方面的技术能力,掌握最新最前沿的技术知识呢?
我们讲师为你带来了云贝独家的专业进阶课程——《MySQL性能优化》,这门课程将与Oracle原厂的最新英文标准教程同步,运用理论加实践的教学方式,激发你内心的无限潜能!
无论是刚刚接触这份领域的新同学,还是经验充足的老学员,都能在这里找到属于自己的位置和提升空间。让我们一同携手追寻技术之美,探寻优化之道。
别再犹豫!快来加入我们吧!四天热血沸腾的技术进阶课程,期待你的加入!


学习完这门课程之后,你将会有以下收获:
1. 全面掌握性能优化的核心概念;

2.深刻洞察影响性能的诸多因素;

3.熟练运用一系列实用且强大的性能调优工具去优化你的数据库;

4.准确地配置并采用最适合实际需要的性能方案来提升数据库效率;

5.精通如何调整你的MySQL服务器实例,从而获得最高性能的结果;

6.具备精妙绝伦的设计能力,可以搭建出堪称完美的性能方案;

7.充分了解MySQL如何优化查询语句,精准地定位和修复那些拖慢查询速度的问题;

8.可迅速诊断并解决日常运行中常常出现的各种性能问题;

9.有惊人的识别力和工具化修复能力,轻松修正复制过程中的任何链路延迟。


这是一次难忘的学习之旅,也是您通往职场巅峰的必经之路。云贝全体教师,热切期盼着你的到来,我们等你一起来探索MySQL性能优化世界!

试听课链接:https://www.bilibili.com/video/BV1YW421A719/?spm_id_from=333.788&vd_source=5dc541b1371cd9f79ef4d5d95ae0ec6d


课程特点: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.6.Practice 5-2: Managing the Number of Client Connections
5.7.Practice 5-3: Investigating the Effects of Multiple Simultaneous Connections
5.8.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 ACE总监

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

MySQL 8.0 OCP专家认证课程

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

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

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