CODEWITHSUNDEEP
mysqlamazon-web-servicesamazon-rds
SamBremner
SamBremner

Reputation: 823

AWS RDS Memory Issue

I have a database running on Amazons RDS platform and it does not seem to be using the full amount of memory available.

The instance type is db.m4.xlarge, this should give me 16 GiB of memory but when i look at the monitoring page it shows I am reaching the threshold with a current value of 2460 MB.

Screenshot of AWS RDS monitoring page

When I look at the db-parameter-group it shows that the innodb_buffer_pool_size should be the 3/4 of the DBinstanceClassMemory however when i check the actual value set (by logging into the db and running show global variables) is it set as 12465471488 (i assume this is bytes?)

Does anyone know why this is and what options I should set to make the RDS instance take full advantage of the memory that is available?

Upvotes: 1

Views: 1322

Answers (1)

Michael - sqlbot
Michael - sqlbot

Reputation: 179374

The number shown in the console is free memory -- not used memory. It's arguably counter-intuitive, but that's what's being shown, here. Note that the small bar graph adjacent to the number is mostly full, not mostly empty.

Upvotes: 3

Related Questions