Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Monitoring MySQL with Performance Schema

via Pluralsight

Overview

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.

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.

Syllabus

  • Course Overview 1min
  • Introduction 5mins
  • Getting Started with Performance Schema 20mins
  • Identifying Resource Bottlenecks by Wait Events 27mins
  • Understanding Resource Utilization with Performance Reports 34mins
  • Addressing Common Monitoring Real World Scenarios 27mins
  • Summary 2mins

Taught by

Pinal Dave

Reviews

3.7 rating at Pluralsight based on 15 ratings

Start your review of Monitoring MySQL with Performance Schema

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.