• Online, Self-Paced
Course 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

Learning 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

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.