Peter Zaitsev (Percona) delivers the talk, "MySQL Performance Optimization and Troubleshooting with Percona Monitoring and Management", on DAY 1 of the Percona Live Open Source Database Conference 2019, 5/29, at Austin, TX.
Optimizing MySQL performance and troubleshooting MySQL problems are two of the most critical and challenging tasks for MySQL DBA's. The databases powering your applications need to be able to handle heavy traffic loads while remaining responsive and stable so that you can deliver an excellent user experience. Further, DBA's are also expected to find cost-efficient means of solving these issues.In this presentation, we will discuss how you can optimize and troubleshoot MySQL performance and demonstrate how Percona Monitoring and Management (PMM) enables you to solve these challenges using free and open source software. We will look at specific, common MySQL problems and review the essential components in PMM that allow you to diagnose and resolve them.
Optimize and Troubleshoot MySQL using PMM
Introduction to pg_stat_monitor
Kubernetes: The Path to Open Source DBaaS
PostgreSQL High-Performance Tuning and Optimization
Using PMM to Identify and Troubleshoot Problematic MySQL Queries
How to Maximize the Benefits of Using Open Source MongoDB with Percona Distribution for MongoDB