MySQL 8.0: Performance Tuning

MySQL is the world’s most popular open source database, and the leading database for web applications. The majority of the largest web properties rely on MySQL to cope with huge numbers of transactions simultaneously, while maintaining the integrity of their data. As users continue to demand better performance and more functionality from web applications, you need to make sure that your database can keep up. The MySQL 8.0 Performance Tuning course will teach you how to use the vast array of configuration options, monitoring tools, and techniques employed by MySQL database professionals to keep your applications fast, efficient, and safe.

STUDENTS WILL LEARN TO

  • Troubleshoot common performance problems
  • Benchmark your MySQL server
  • Tune MySQL server settings
  • Investigate performance metrics with a range of system databases, command-line utilities, and graphical tools
  • Design your databases and queries for optimal performance
  • Diagnose and fix replication lag
Phone
Phone
Product
Oracle
Code
D109197GC10
Duration
4 Days
Price (baht)
57,000

About the course

COURSE TOPICS

Module 1 : Introduction

  • Introduction
  • Deomonstration: Finding information about MySQL courses and certification options
  • Practice 1-0: Practice Overview
  • Practice 1-1: Course Environment Overvie

 Module 2 : Performance Tuning Concepts

  • Performance Tuning Concepts
  • Troubleshooting Performance Issues
  • Practice 2-1: Quiz – Performance Tuning

 Module 3 : Performance Tuning Tools

  • Performance Tuning Tools
  • Community Monitoring Tools
  • Demonstration
  • Practice 3-1: Using MySQL Command-Line Monitoring Tools
  • Practice 3-2: Using MySQL Enterprise Monitor
  • Practice 3-3: Using Benchmark Tools
  • Practice 3-4: Using Linux System Monitoring Tools

 Module 4 : Performance Schema

  • Performance Schema
  • Configuration
  • Querying Event Data
  • Practice 4-1: Examining the Performance Schema Configuration
  • Practice 4-2: Querying the Performance Schema
  • Practice 4-3: Using sys to Work with the Performance Schema
  • Practice 4-4: Using MySQL Workbench for Performance Schema Configuration, Monitoring, and Reporting

 Module 5 : General Server Tuning

  • General Server Tuning
  • Displaying MySQL Memory Usage
  • Practice 5-1: Managing the Number of Client Connections
  • Practice 5-2: Investigating the Effects of Multiple Simultaneous Connections
  • Practice 5-3: Investigating the Effects of Thread Caching

Module 6: Tuning Tables, Files, and Logs

  • Tuning Tables, Files, and Logs
  • Practice 6-1: Sizing the Table Cache
  • Practice 6-2: Sizing the Binary Log Cache
  • Practice 6-3: Identifying l/O Hotspots with MySQL Workbench

Module 7: Tuning InnoDB

  • Tuning InnoDB
  • Measuring InnoDB Performance
  • Practice 7-1: Investigating the Effects of Log Files on Transactions
  • Practice 7-2: Using SHOW ENGINE INNODB STATUS
  • Practice 7-3: Monitoring InnoDB Metrics in the Information Schema
  • Practice 7-4: Evaluating InnoDB Buffer Pool Size

Module 8: Optimizing Your Schema

  • Optimizing Your Schema
  • InnoDB Table compression
  • Practice 8-1: Comparing the Effects of Table Normalization on Query Performance
  • Practice 8-2: Choosing the Correct Data Type
  • Practice 8-3: Compressing Tables
  • Practice 8-4: Partitioning

Module 9: Monitoring Queries

  • Monitoring Queries
  • Statement Status Variables
  • Practice 9-1: Monitoring Statements
  • Practice 9-2: Using the Slow Query Log
  • Practice 9-3: Identifying Slow Queries with MySQL Enterprise Monitor Query Analyzer
  • Practice 9-4: Identifying Slow Queries with sys Views
  • Practice 9-5: Using MySQL Workbench Query Statistics

Module 10: Query Optimization

  • Query Optimization
  • Optimizer Trace
  • Practice 10-1: Understanding the Query Execution Plan with the EXPLAIN Statement
  • Practice 10-2: Improving the Performance of a Query
  • Practice 10-3: Tracing the Optimizer

Module 11: Optimizing Locking Operations

  • Optimizing Locking Operations
  • Practice 11-1: Troubleshooting Blocked Queries
  • Practice 11-2: Investigating Metadata Locks

Module 12: Tuning Replication

  • Tuning Replication
  • Practice 12-1: Diagnosing Replication Lag by Using Binary Log File Name and Position
  • Practice 12-2: Diagnosing Replication Lag by Using GTID Sets

 Module 13: Conclusion

  • Conclusion

Register for Training

Schedule

Start DateEnd DateDuration (days)PriceRegisterCourseCodeProduct

เราใช้คุกกี้เพื่อพัฒนาประสิทธิภาพ และประสบการณ์ที่ดีในการใช้เว็บไซต์ของคุณ คุณสามารถศึกษารายละเอียดได้ที่ นโยบายความเป็นส่วนตัว และสามารถจัดการความเป็นส่วนตัวเองได้ของคุณได้เองโดยคลิกที่ ตั้งค่า

Privacy Preferences

คุณสามารถเลือกการตั้งค่าคุกกี้โดยเปิด/ปิด คุกกี้ในแต่ละประเภทได้ตามความต้องการ ยกเว้น คุกกี้ที่จำเป็น

Allow All
Manage Consent Preferences
  • Always Active

Save