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.
Course info
Level
Intermediate
Updated
April 28, 2017
Duration
1h 59m
Table of contents
Description
Course info
Level
Intermediate
Updated
April 28, 2017
Duration
1h 59m
Description

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.

About the author
About the author

Pinal Dave is a Pluralsight Developer Evangelist.

More from the author
PostgreSQL: Advanced Server Programming
Intermediate
2h 14m
21 Mar 2016
PostgreSQL: Advanced SQL Queries
Advanced
1h 41m
13 Aug 2015
More courses by Pinal Dave
Transcript
Transcript

Hi Everyone,

My Name is Pinal Dave, welcome to my course, Monitoring MySQL with Performance Schema.

I am a Database Tuning Expert at SQLAuthority.com

Data is very important for any application but database performance is even more important. Everybody wants maximum performance for their application.

Monitoring database for resource consumption and bottleneck is very important task for any DBA. Once we know how each of the resources are consumed we can come up with tricks to optimize the consumption of the same.

Some of the major topics in this course we will cover include:

  • Getting Started with performance schema
  • Identifying Resource Bottlenecks
  • Understanding Resource Utilization and finally,
  • Addressing Common Monitoring Real World Scenarios
By the end of this course, you will know how to monitor your MySQL with the help of Performance Schema.

I hope you'll join me on this journey to learn Monitoring MySQL with Performance Schema.