Why is Amazon RDS thrushold monitoring memory showing me in RED?

Question

Today I noticed that my Amazon RDS memory monitor threshold is showing me a red line. Here I added a screenshot for this.

So my question is, what is a memory threshold and why does it cross a limit? Is something wrong with my copy? What is the decision to reduce / control this trip?

Answer 1

The red line that you see is the threshold set by AWS, if RDS calls this threshold many times, then there may be a performance problem that you should look at.

MySQL tries to use all available memory as needed. However, the restrictions are determined by the settings of the RDS server, which you can change, and you may not need to scale your server.

RDS instances are created with default values ​​for these parameters (the most appropriate of these are innodb_buffer_pool_size) to optimize memory usage. To see which server variables apply to your instance, connect to it and run the show global variables command.

For this number it’s normal to go up and down, as a matter of course.

If you see performance issues and you don't have more free memory, you should look for reasons or updates for a larger instance.

These values ​​may not be correct for all workloads, but you can adjust them using parameter groups. This document explains how you can use parameter groups:

http://docs.amazonwebservices.com/AmazonRDS/latest/UserGuide/USER_WorkingWithParamGroups.html