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:
Follow Azure Database for MySQL on:

Series Overview:

#AzureDBforMySQL #FlexibleServer #MySQL #Performance