FORGOT YOUR DETAILS?

eluide9eb7f5d

MySQL 8.0 Performance Tuning

Cost
$3200 USD
Course Code
D109195GC10
Duration
4 Days
Format
Live Virtual Class

Course Schedule

MySQL 8.0 Performance Tuning

$3,200.00

SCHEDULED, 02-Jan-2024 - 05-Jan-2024, 09:00 AM - 05:00 PM US Pacific
SCHEDULED, 24-Jun-2024 - 27-Jun-2024, 09:00 AM - 05:00 PM US Pacific
Choose an option
MySQL 8.0 Performance Tuning – SCHEDULED, 02-Jan-2024 - 05-Jan-2024, 09:00 AM - 05:00 PM US Pacific
$3,200.00
MySQL 8.0 Performance Tuning – SCHEDULED, 24-Jun-2024 - 27-Jun-2024, 09:00 AM - 05:00 PM US Pacific
$3,200.00
SKU: D109195GC10 Categories: , ,

Overview

This course provides experienced MySQL DBAs with knowledge of how and why server settings affect performance, and when and how to tune them. It teaches students how to monitor their MySQL server and identify areas that impact performance, such as slow queries and replication lag, and how to diagnose and fix these issues.

Audience

  • Administrator
  • Architect
  • Database Administrator
  • Developer
  • Systems Administrator

Suggested Prerequisites

  • Familiarity with the Performance Schema
  • Experience of MySQL Enterprise Monitor
  • MySQL for Database Administrators Ed 4
  • DBA experience
  • Knowledge of Linux
  • Familiarity with the mysql command-line client and tools

Topics

  • Performance Tuning Concepts and Tools
  • Performance Schema
  • General Server Tuning, Tuning Tables, Files, and Logs
  • Tuning InnoDB
  • Optimizing Your Schema
  • Monitoring Queries
  • Query Optimization
  • Optimizing Locking Operations
  • Tuning Replication

Overview

This course provides experienced MySQL DBAs with knowledge of how and why server settings affect performance, and when and how to tune them. It teaches students how to monitor their MySQL server and identify areas that impact performance, such as slow queries and replication lag, and how to diagnose and fix these issues.

Audience

  • Administrator
  • Architect
  • Database Administrator
  • Developer
  • Systems Administrator

Suggested Prerequisites

  • Familiarity with the Performance Schema
  • Experience of MySQL Enterprise Monitor
  • MySQL for Database Administrators Ed 4
  • DBA experience
  • Knowledge of Linux
  • Familiarity with the mysql command-line client and tools

Topics

  • Performance Tuning Concepts and Tools
  • Performance Schema
  • General Server Tuning, Tuning Tables, Files, and Logs
  • Tuning InnoDB
  • Optimizing Your Schema
  • Monitoring Queries
  • Query Optimization
  • Optimizing Locking Operations
  • Tuning Replication

Related Courses…

TOP
0