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