E04: Troubleshooting low memory issues | Azure Database for MySQL - Troubleshooting Series скачать в хорошем качестве

E04: Troubleshooting low memory issues | Azure Database for MySQL - Troubleshooting Series

To help ensure that a MySQL database server performs optimally, it's very important to have the appropriate memory allocation and utilization. In this episode of the troubleshooting series, we walk you through the common symptoms and causes for Out Of Memory (OOM) issues, and the troubleshooting approach to follow to mitigate these issues. 0:00 Introduction and episode overview 1:33 Overview of MySQL memory distribution 4:31 Azure Database for MySQL memory metrics 6:01 Troubleshooting approach 7:14 MySQL memory issues - major buckets 9:09 Cause #1 - Increase in temporary tables 15:02 Cause #2 - Table cache 18:28 Cause #3 - Buffers 21:29 Cause #4 - Buffer cache hit ratio 25:29 Top 6 Best Practices 26:32 Summary and links to resources Upcoming episode: Troubleshooting query performance (By Rahul Saha) 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