MySQL Query Optimization and Performance Tuning

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.

Introduction	00:01:59
Introduction	01:59
Optimizing Data Access	00:12:28
Introduction	01:10
Prerequisite	00:55
Overheard	01:15
Understanding Data Needs	02:03
Demo: Setup	00:33
Demo: Best Practices for Data Access	02:15
Demo: Why SELECT Star (*) is Bad Idea	03:53
Summary in Sixty Seconds	00:24
Understanding MySQL Query Optimization	00:26:07
Introduction	00:57
Execution Path of a Query	00:36
Client Protocols	02:15
Query Cache	01:04
Parser	00:47
Preprocessor	00:39
Query Optimizer	01:29
Query Optimizer Responsibilities	01:31
Query Optimizer Limitations	02:29
Query Execution Engine and Storage	01:31
Returning Result to Client	00:53
Additional Notes on Query Optimizer	00:55
Maximizing Query Optimizer Performance	00:40
Understanding Query States	02:02
Demo: Show Full Processlist	02:03
Understanding Explain Command	00:37
Demo: Explain Command	03:24
Demo: Explain Extended Command	01:49
Summary in Sixty Seconds	00:26
Performance Optimization by Practical Query Tuning	01:06:22
Introduction	01:35
Demo: Index Used for SELECT clause	08:02
Demo: One Complex Query vs Multiple Simple Queries	04:15
Demo: One Complex Query vs Multiple Simple Queries - Part 2	04:20
Demo: One Complex Query vs Multiple Simple Queries with Index	05:47
Demo: Table Order in Join Clause - INNER JOIN	05:53
Demo: Table Order in Join Clause - OUTER JOIN	03:31
Demo: Most Optimal Choice - Subquery vs Exists vs Joins	08:49
Demo: Most Optimal Choice - Subquery vs Exists vs Joins - Part 2	03:50
Demo: Tuning Aggregate Function	05:03
Demo: Optimizing Group By Clause	05:45
Demo: Optimizing Paging with LIMIT Clause	02:43
Demo: Impact on Performance of UNION and UNION ALL	03:55
Demo: Index and Not Equal to Operator	02:18
Summary in Sixty Seconds	00:36
Best Practices	00:03:50
Best Practices	03:50