E03: Troubleshooting high CPU utilization | Azure Database for MySQL - Troubleshooting Series

Описание: Is your Azure Database for MySQL flexible server encountering low performance due to high CPU utilization issues?
In this third episode of the Azure Database for MySQL - Troubleshooting Series (https://aka.ms/mysql-troubleshooting-..., we walk you through the methods and metrics you can use to identify CPU resource bottlenecks as well as the importance of tracing a workload to identify any queries that might be causing spikes. The episode also explores the best practices you use to avoid these types of issues.

00:00 Introduction and Episode Overview
01:36 High CPU usage - Symptoms and Common Causes
03:23 Methods to Identify Resource Bottlenecks
04:53 Top 7 Best Practices
07:23 Demo - Monitor Crucial Metrics
11:12 Demo - Enable Slow Query Logs
11:50 Demo - Configure Diagnostic Settings
12:44 Demo - Query and Analyse Logs
14:14 Demo - Server Logs
14:49 Demo - Workbooks
17:38 Demo - Run diagnostics using MySQL CLI
26:35 Resources

Upcoming episode: Troubleshooting low memory issues (By Deepthi Prasad)

Resources:
Microsoft Learn documentation - https://learn.microsoft.com/azure/mys...
Get started for free with an Azure free account! - https://aka.ms/try-mysql-free
Follow Azure Database for MySQL on:
YouTube -    / @azuredbmysql  
Twitter -   / azuredbmysql  
LinkedIn - https://aka.ms/azuremysql-li
Email us at [email protected].

Series Overview:
The Azure Database for MySQL - Troubleshooting Video Series (https://aka.ms/mysql-troubleshooting-..., with new episodes released every couple of weeks, provides troubleshooting tips and tricks for potential problem areas, such as low performance, connectivity issues, replication latency, and database corruption.

#AzureDBforMySQL #FlexibleServer #MySQL #Performance