Monitoring MySQL with Performance Schema from Pluralsight

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.

What's inside

Syllabus

Course Overview

Introduction

Getting Started with Performance Schema

Identifying Resource Bottlenecks by Wait Events

Understanding Resource Utilization with Performance Reports

Addressing Common Monitoring Real World Scenarios

Summary

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Fits experienced database administrators and developers facing complex performance issues

Develops core performance monitoring skills for database administrators and developers

Utilizes the highly relevant MySQL's Performance Schema feature

Led by Pinal Dave, known for his MySQL expertise

Suitable for intermediate learners with a foundation in MySQL database administration and development

May require additional resources for students with limited exposure to MySQL performance monitoring

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Monitoring MySQL with Performance Schema with these activities:

Connect with Performance Schema experts

Show steps

Provides access to valuable guidance and insights from experienced professionals in the field of Performance Schema.

Show steps

Identify and reach out to individuals who have expertise in Performance Schema
Request mentorship or guidance on specific Performance Schema topics

Review the fundamentals of MySQL

Show steps

Refreshes knowledge of MySQL fundamentals, ensuring a solid foundation for the Performance Schema course.

Browse courses on Database Management Systems

Show steps

Review the SQL syntax and commands
Practice creating and managing databases, tables, and indexes
Understand concepts like data types, constraints, and transactions

Follow tutorials on Performance Schema

Show steps

Familiarizes learners with the functionality and usage of the MySQL Performance Schema through guided examples.

Show steps

Locate and access relevant Performance Schema tutorials
Follow the steps in the tutorials to enable and configure Performance Schema
Execute queries and interpret the results to gain insights into MySQL performance

Five other activities

Expand to see all activities and additional details

Show all eight activities

Discuss Performance Schema scenarios with peers

Show steps

Encourages collaboration, knowledge sharing, and different perspectives on Performance Schema through peer discussions.

Show steps

Engage in online forums or meet with peers to discuss Performance Schema concepts
Present and analyze real-world scenarios related to database performance
Share and learn from experiences and best practices in using Performance Schema

Analyze Performance Schema tables and reports

Show steps

Develops proficiency in analyzing Performance Schema data to identify and address performance bottlenecks.

Show steps

Query and examine tables like performance_schema.events_statements_summary
Interpret reports such as Performance Schema's summary report
Correlate performance data with MySQL server metrics to pinpoint performance issues
Use Performance Schema data to optimize queries and improve database efficiency

Read High-Performance MySQL by Baron Schwartz

Show steps

Provides a comprehensive guide to MySQL performance tuning, including Performance Schema usage and optimization techniques.

View High Performance MySQL: Optimization, Backups,... on Amazon

Show steps

Obtain the book and allocate time for reading
Read and comprehend the chapters covering Performance Schema
Apply the concepts and techniques learned to enhance MySQL performance

Create a Performance Schema dashboard

Show steps

Allows learners to apply their understanding by visualizing and presenting key performance metrics using a Performance Schema dashboard.

Show steps

Design and create a dashboard using tools like Grafana or MySQL Workbench
Configure widgets to display metrics like query latency, wait events, and buffer pool usage
Share the dashboard with relevant stakeholders for monitoring and analysis

Contribute to Performance Schema on GitHub

Show steps

Encourages engagement with the Performance Schema community and provides practical experience in contributing to open-source projects.

Show steps

Fork the MySQL Performance Schema repository on GitHub
Identify areas for improvement or bug fixes
Write code changes and submit a pull request

Career center

Learners who complete Monitoring MySQL with Performance Schema will develop knowledge and skills that may be useful to these careers:

Database Administrator

A Database Administrator, also known as a DBA, implements and manages databases, ensuring their performance. They are responsible for the security, backup, storage, and overall health of all databases within their care. This course will help Database Administrators to maximize the performance of their databases by using performance schema to address resource bottlenecks and real-world scenarios.

See salaries and explore the career path for Database Administrator

Data Analyst

A Data Analyst gathers, interprets, and presents data in a way that allows others to make informed decisions. They use statistical analysis and data mining techniques to identify trends and patterns, and then develop visualizations to communicate their findings.

See salaries and explore the career path for Data Analyst

Business Intelligence Analyst

A Business Intelligence Analyst collects, analyzes, and interprets data to help businesses make more informed decisions. They use data mining, statistical analysis, and machine learning techniques to identify trends and patterns in data, and then develop visualizations and reports to communicate their findings.

See salaries and explore the career path for Business Intelligence Analyst

Data Scientist

A Data Scientist develops and maintains databases, using statistical analysis and data mining techniques to identify trends and patterns in data. They then build models to predict future trends and outcomes, and use these models to make recommendations for business decisions.

See salaries and explore the career path for Data Scientist

Software Engineer

A Software Engineer designs, develops, and maintains software applications. They use programming languages and tools to create software that meets the needs of users, and they work with other engineers to ensure that software is efficient, reliable, and secure.

See salaries and explore the career path for Software Engineer

Web Developer

A Web Developer designs and develops websites and web applications. They use programming languages and tools to create websites that are visually appealing, functional, and responsive across different devices.

See salaries and explore the career path for Web Developer

Information Security Analyst

An Information Security Analyst protects an organization's computer systems and networks from unauthorized access, use, disclosure, disruption, modification, or destruction.

See salaries and explore the career path for Information Security Analyst

Network Engineer

A Network Engineer designs, installs, and maintains computer networks. They use networking equipment and software to ensure that networks are reliable, secure, and efficient.

See salaries and explore the career path for Network Engineer

Cloud Engineer

A Cloud Engineer designs, builds, and maintains cloud-based applications and infrastructure. They use cloud computing platforms and tools to create scalable, reliable, and secure cloud solutions.

See salaries and explore the career path for Cloud Engineer

Data Engineer

A Data Engineer designs, develops, and maintains data pipelines and data warehouses. They use data engineering tools and techniques to collect, clean, transform, and analyze data.

See salaries and explore the career path for Data Engineer

IT Manager

An IT Manager plans, directs, and coordinates an organization's information technology resources. They are responsible for the overall health and performance of an organization's IT infrastructure.

See salaries and explore the career path for IT Manager

Database Designer

A Database Designer designs and implements databases. They use data modeling techniques to create databases that are efficient, reliable, and secure.

See salaries and explore the career path for Database Designer

Systems Administrator

A Systems Administrator installs, maintains, and repairs computer systems and networks. They use operating systems, software, and hardware to ensure that systems are reliable, secure, and efficient.

See salaries and explore the career path for Systems Administrator

IT Consultant

An IT Consultant provides advice and guidance to organizations on how to use information technology to achieve their business goals. They may also design, develop, and implement IT solutions.

See salaries and explore the career path for IT Consultant

IT Auditor

An IT Auditor reviews and evaluates an organization's IT systems and processes to ensure that they are compliant with regulations and standards.

See salaries and explore the career path for IT Auditor