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 [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