MySQL Query Optimization and Performance Tuning
This course focuses on Query Optimization and Performance Tuning of MySQL.
What you'll learn
Performance is one of the most essential aspects of any application. Everyone wants their server to perform optimally and at the best efficiency. In this course we will understand the basics of query optimization and look at practical tips and tricks for performance tuning.
Table of contents
- Introduction 1m
- Execution Path of a Query 1m
- Client Protocols 2m
- Query Cache 1m
- Parser 1m
- Preprocessor 1m
- Query Optimizer 1m
- Query Optimizer Responsibilities 2m
- Query Optimizer Limitations 2m
- Query Execution Engine and Storage 2m
- Returning Result to Client 1m
- Additional Notes on Query Optimizer 1m
- Maximizing Query Optimizer Performance 1m
- Understanding Query States 2m
- Demo: Show Full Processlist 2m
- Understanding Explain Command 1m
- Demo: Explain Command 3m
- Demo: Explain Extended Command 2m
- Summary in Sixty Seconds 0m
- Introduction 2m
- Demo: Index Used for SELECT clause 8m
- Demo: One Complex Query vs Multiple Simple Queries 4m
- Demo: One Complex Query vs Multiple Simple Queries - Part 2 4m
- Demo: One Complex Query vs Multiple Simple Queries with Index 6m
- Demo: Table Order in Join Clause - INNER JOIN 6m
- Demo: Table Order in Join Clause - OUTER JOIN 4m
- Demo: Most Optimal Choice - Subquery vs Exists vs Joins 9m
- Demo: Most Optimal Choice - Subquery vs Exists vs Joins - Part 2 4m
- Demo: Tuning Aggregate Function 5m
- Demo: Optimizing Group By Clause 6m
- Demo: Optimizing Paging with LIMIT Clause 3m
- Demo: Impact on Performance of UNION and UNION ALL 4m
- Demo: Index and Not Equal to Operator 2m
- Summary in Sixty Seconds 1m
About the author
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 21 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 61 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,700 database tech articles on his blog at https://blog.sqlauthority.com.