TRENDS is authorized to promote and deliver Oracle courses in partnership with TechEdge Solutions. EZY Corporation logo and Oracle logo are registered trademarks of EZY Corporation and Oracle respectively. All rights reserved.

MySQL Performance Tuning Ed 4

Schedule

Start End Duration Location Details

Course Details

MySQL Performance Tuning Ed 4

Course code: MSQLPT4

Duration: 4 Days

Prerequisite:

Suggested Prerequisite

•    Familiarity with the Performance Schema
•    Experience of MySQL Enterprise Monitor

Required Prerequisite

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

Course Description:

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.

Course Objectives:

After taking this course, you should be able to:

•    Identify and fix replication lag
•    Understand performance tuning concepts
•    List factors that affect performance
•    Use a range of performance tuning tools
•    Configure and use the Performance Schema
•    Tune the MySQL server instance
•    Design a schema for optimal performance
•    Understand how MySQL optimizes queries
•    Identify and fix slow queries,
•    Diagnose and resolve common performance issues

Intended Audience:

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

Course Outlines:

•    Introduction
•    Performance Tuning Concepts
•    Performance Tuning 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
•    Conclusion