MySQL Performance Tuning Ed 3

RM4,960.00 RM5,257.60 (after 6% SST)

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 Duration: 4 Days
Categories: , Tag:



The MySQL Fundamentals training is the first step in mastering MySQL, the world’s most popular open source database. Develop solid understanding and practical experience using relational databases, SQL and the MySQL Server and tools.In this course, you will be introduced to the MySQL Cloud Service.

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


  • 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


  • Describe the features and benefits of MySQL
  • Explain the basics of relational databases
  • Design an effective database
  • Issue MySQL statements from the mysql command-line client
  • Perform database operations by using MySQL Workbench
  • Select appropriate data types for your database
  • Build a database and tables by using SQL
  • Modify the structure of your database
  • Create indexes and keys
  • Add or update database data
  • Query data with SELECT statements
  • Join data from multiple tables
  • Use built-in MySQL functions
  • Export and import database data
  • Explain database transactions
  • Gain an understanding on the MySQL Cloud Service




  • 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