客服微信
学习人数：435
课程类型：就业培训
课时长度：4天/24 课时
【云贝独家】MySQL 性能优化进阶课程，引领你的职业巅峰！
同学们，你们是否被各种工作中的性能问题困扰？是否渴望提升自己在MySQL数据库方面的技术能力，掌握最新最前沿的技术知识呢？
我们讲师为你带来了云贝独家的专业进阶课程——《MySQL性能优化》，这门课程将与Oracle原厂的最新英文标准教程同步，运用理论加实践的教学方式，激发你内心的无限潜能！
无论是刚刚接触这份领域的新同学，还是经验充足的老学员，都能在这里找到属于自己的位置和提升空间。让我们一同携手追寻技术之美，探寻优化之道。
别再犹豫！快来加入我们吧！四天热血沸腾的技术进阶课程，期待你的加入！
学习完这门课程之后，你将会有以下收获：
1. 全面掌握性能优化的核心概念；
2.深刻洞察影响性能的诸多因素；
3.熟练运用一系列实用且强大的性能调优工具去优化你的数据库；
4.准确地配置并采用最适合实际需要的性能方案来提升数据库效率；
5.精通如何调整你的MySQL服务器实例，从而获得最高性能的结果；
6.具备精妙绝伦的设计能力，可以搭建出堪称完美的性能方案；
7.充分了解MySQL如何优化查询语句，精准地定位和修复那些拖慢查询速度的问题；
8.可迅速诊断并解决日常运行中常常出现的各种性能问题；
9.有惊人的识别力和工具化修复能力，轻松修正复制过程中的任何链路延迟。
这是一次难忘的学习之旅，也是您通往职场巅峰的必经之路。云贝全体教师，热切期盼着你的到来，我们等你一起来探索MySQL性能优化世界！
课程特点：Oracle原厂最新英文标准教材，理论+实验相结合授课
第一章：Introduction
1.1.Introduction
1.2.Practice 1-1: Course Environment Overvie
第二章：Performance Tuning Concepts2.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 Tools3.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 Schema4.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_Tuning5.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_Logs6.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_InnoDB7.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_Schema8.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_Queries9.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_Queries10.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_Locking11.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_Replication12.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第十三章：Conclusion13.1.Conclusion
郭一军
云贝教育创始人 腾讯云TVP PostgreSQL ACED
