How can I troubleshoot low freeable memory in an Amazon RDS for MySQL database?

Опубликовано 12 декабря 2023, 14:12

Skip directly to the demo: 2:03

For more details on this topic, see the Knowledge Center article associated with this video: (Article url.com).

Usha shows you how you can troubleshoot low freeable memory in an Amazon RDS for MySQL database.

0:00 Introduction
2:03 How to monitor memory usage on the RDS for MySQL instance
3:29 Check SwapUsage in the Amazon CloudWatch Logs
4:07 Use AWS Enhanced Monitoring to monitor resource utilization on a DB instance
5:53 List threads for your DB instance to monitor CPR and memory usage
6:20 View all active connections and queries in your database
6:55 View long-running transactions, memory utilization statistics, and locks
7:57 Turn on Performance Insights
9:44 Set a CloudWatch alarm for the FreeableMemory metric
11:59 Upgrade your instance to a more recent minor version of MySQL
12:45 If your freeable memory remains consistently low
13:18 Closing

Subscribe:
More AWS videos: go.aws/3m5yEMW
More AWS events videos: go.aws/3ZHq4BK

Do you have technical AWS questions?
Ask the community of experts on AWS re:Post: go.aws/3lPaoPb

ABOUT AWS
Amazon Web Services (AWS) is the world’s most comprehensive and broadly adopted cloud platform, offering over 200 fully featured services from data centers globally. Millions of customers — including the fastest-growing startups, largest enterprises, and leading government agencies — are using AWS to lower costs, become more agile, and innovate faster.

#AWS #AmazonWebServices #CloudComputing