E03: Troubleshooting high CPU utilization | Azure Database for MySQL - Troubleshooting Series скачать в хорошем качестве

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 AskAzureDBforMySQL@service.microsoft.com. 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