MySQL Database Development: Query & Performance Optimization
MySQL 8.0
| Intermediate
- 14 Videos | 1h 27m 18s
- Includes Assessment
- Earns a Badge
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 queriesrecognize potential problems affecting query run time and how to eliminate these problemsdescribe the purpose of the EXPLAIN statement and the results it returnswork with clustered and secondary indexes on a tablerecognize general methods for maintaining tables and indexesuse the Visual Explain feature to generate a visual representation of a MySQL queryuse the EXPLAIN statement to analyze query execution in the MySQL client
-
use the query optimizer to control query plan evaluationidentify strategies available for optimizing InnoDB storage usagerecognize options for optimizing the configuration for the server running MySQLconfigure MySQL values to fine-tune the instance for optimal performancedownload and install the MONyog performance monitoring tool for MySQLuse MONyog to monitor and configure OS settings to optimize MySQL performancerecognize various methods available for optimizing the overall performance of MySQL, including optimizing queries
IN THIS COURSE
-
1.MySQL Indexes7m 40sUP NEXT
-
2.Understanding Query Optimization5m 44s
-
3.EXPLAIN Statement Fundamentals2m 17s
-
4.Creating Indexes5m 36s
-
5.Maintaining Indexes5m 39s
-
6.Visual Explain Plan7m 17s
-
7.Using the EXPLAIN Statement5m 43s
-
8.The Query Optimizer7m 15s
-
9.Optimizing InnoDB Storage9m 48s
-
10.Optimizing the Server Hardware5m 41s
-
11.Optimizing MySQL4m 51s
-
12.The MONyog Monitoring Tool4m 58s
-
13.Using MONyog10m 4s
-
14.Exercise: Performance Optimization in MySQL4m 45s
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.