Monitoring MySQL with Performance Schema
Performance schema is an extremely powerful instrument to collect various performance related data on MySQL, and presents upon executing queries on performance schema. In this course, you'll develop an understanding and use of performance schema.
What you'll learn
The latest version of MySQL has introduced a new feature of MySQL Performance Schema, which monitors MySQL server execution at a low level. The performance schema provides internal execution details of MySQL queries at run time, and it's minimum impact on the performance of MySQL resources. In this course, Monitoring MySQL with Performance Schema, you'll learn how to maximize your data-based performance with the use of performance schema. First, you'll dive into getting started with performance schema. The most important part of the performance schema is that it provides answers to many of the pressing performance issues, which MySQL developers and DBAs face with a "slow application" situation. Next, you'll cover how to identify resource bottlenecks, and develop an understanding for resource utilization. Finally, you'll explore how to address common monitoring real world scenarios. By the end of this course, you'll have the knowledge and fundamentals to monitor MySQL with performance schema.
Table of contents
- Introduction 1m
- Lessons for the Real World 3m
- Demo: Find User with Maximum I/O Time 3m
- Demo: Find File with Maximum I/O Size 2m
- Demo: Frequently Executed Queries 3m
- Demo: Longest Running Queries 3m
- Demo: Queries Using Temp Tables 3m
- Demo: Queries Sorting Entire Table 3m
- Demo: Index Usage Statistics 4m
- Summary 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.