All Questions
Tagged with amazon-rds memory
12 questions
0
votes
0
answers
73
views
AWS RDS SQL Server 2019 Standard edition, everyday 3 am getting errors "insufficient system memory in resource pool 'internal' to run this query"
I have AWS RDS SQL Server 2019 Standard edition with 128GB RAM, everyday 3 am getting errors
insufficient system memory in resource pool 'internal' to run this query
There are few jobs that run at a ...
0
votes
1
answer
194
views
Difference between current_allocation s total_allocation in MySQL sys.memory_by_thread_by_current_bytes
I'm trying to debug a memory leak in MySQL 5.7.37 and running the following query gives me insights about the threads running and the memory allocation for each thread.
select * from sys....
- 101
1
vote
1
answer
727
views
How to reduce MySQL performance_schema memory usage caused by thousands of unique hosts?
I have a problem with some performance_schema tables (*_by_host_* and *_by_account_*) taking up too much RAM. It is caused by clients connecting from a /19 subnet (8190 unique addresses). The ...
0
votes
1
answer
132
views
MariaDB (RDS) going temporarily offline (with memory drop)
We have an issue with a database of ours on RDS running MariaDB 10.4.8 on a t3-large instance type.
For the past week or so, it's been sporadically inaccessible with no errors I can find. During the ...
- 113
5
votes
1
answer
2k
views
Swap Usage but high Freeable memory
We have an AWS RDS with a MySQL database. Buffer Pool size is only 144GB out of the total available 244GB RAM. However, even at such a low RAM config, we see Swap Usage happening. Does anyone have any ...
- 223
0
votes
1
answer
120
views
Should Amazon RDS SQL Server 2017 Web Edition Max Memory settings be different from that of a locally installed instance?
We have an Amazon RDS SQL Server Web Edition on Windows Server 2012 with 2 processors and 8GB RAM.
Should I configure the Max Memory similar to that of an instance on a local server i.e keeping back 3-...
- 305
7
votes
0
answers
1k
views
RDS (MySQL): Swap usage growing but plenty of freeable memory? [duplicate]
We run a db.m4.10xlarge instance on Amazon's RDS. It runs 3 fairly busy databases and has a replica instance connected to it.
Over the last few weeks I noticed the swap usage has been steadily rising ...
- 181
15
votes
2
answers
4k
views
Neither DBCC FREEPROCCACHE nor DBCC FREESYSTEMCACHE('SQL Plans') do anything to free CACHESTORE_SQLCP memory
CACHESTORE_SQLCP Sql Plans takes up > 38 GB after a few days.
We are already running with "optimize for ad hoc workloads" option on. (Entity Framework and custom reporting creates a lot of ad hocs!)
...
0
votes
1
answer
36
views
MySQL consumes memory for each portion of read
I'm using MySQL instance for read only operations (data migration to another DB).
I'm reading several dozens of millions rows from one table using limited portions of data (100 000 rows) using select ...
- 557
5
votes
2
answers
20k
views
#1041 - Out of memory issue in mysql
I am using Amazon RDS db.m1.medium instance. It has at least 40-50 database and atleast 10k table. For last one year it was working fine, but today I was altering one table It started giving error. I ...
- 581
5
votes
1
answer
9k
views
MySQL RDS Instance eating up memory and swapping
I have an issue with memory on a RDS instance which is of db.m2.4xlarge class.
Below are the specifications of the RDS instance
Instance Class: db.m2.4xlarge ( 68.4 GB of RAM )
Engine: mysql (5.5.37)
...
- 101
2
votes
0
answers
474
views
MySql Very Slow Writes & Out of memory error
I am having a rds db instance in AWS which is used by Drupal 7 instatllation.
I am getting the below error messages in the log:
> 130912 11:57:39 [ERROR] /rdsdbbin/mysql/bin/mysqld: Out of memory
&...
- 133