Query & Performance Optimization

MySQL 8.0
  • 14 Videos | 1h 33m 48s
  • Includes Assessment
  • Earns a Badge
Likes 9 Likes 9
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

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 38 Likes 38  
Likes 49 Likes 49  
Likes 16 Likes 16  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 61 Likes 61  
COURSE SQL Developer
Likes 152 Likes 152  
Likes 25 Likes 25