Course details

MySQL Database Development: Query and Performance Optimization

MySQL Database Development: Query and Performance Optimization


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

Indexing and understanding the configuration of MySQL can be key to performance. Explore index types and configuration options that can be set to fine-tune the performance of your MySQL databases to optimal levels



Expected Duration (hours)
1.5

Lesson Objectives

MySQL Database Development: Query and Performance Optimization

  • identify the types of indexes and how they function in queries
  • recognize potential problems affecting query run time and how to eliminate these problems
  • describe the purpose of the EXPLAIN statement and the results it returns
  • work with clustered and secondary indexes on a table
  • recognize general methods for maintaining tables and indexes
  • use the Visual Explain feature to generate a visual representation of a MySQL query
  • use the EXPLAIN statement to analyze query execution in the MySQL client
  • use the query optimizer to control query plan evaluation
  • identify strategies available for optimizing InnoDB storage usage
  • recognize options for optimizing the configuration for the server running MySQL
  • configure MySQL values to fine-tune the instance for optimal performance
  • download and install the MONyog performance monitoring tool for MySQL
  • use MONyog to monitor and configure OS settings to optimize MySQL performance
  • recognize various methods available for optimizing the overall performance of MySQL, including optimizing queries
  • Course Number:
    it_dfmydd_08_enus

    Expertise Level
    Intermediate