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