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