Questions tagged [memory]

When used in the context of databases, memory refers to RAM directly addressable by the CPU as opposed to going through the I/O subsystem.

Filter by
Sorted by
Tagged with
0
votes
0answers
39 views

SQL Server Numa config - Why is VAS reservered memory different on each numa mode?

I have a virtual machine running on hyper-V. The VM has 26 processors assigned to it and 300 GB of RAM. The underlying physical server has 2 CPU sockets, both with 8 cores each. Looking at the NUMA ...
0
votes
1answer
24 views

High memory usage in Masters with MariaDB and Vitess

I'm running a Kubernetes Cluster with MariaDB 10.3.20 and Vitess 6. Everything is running fine, but the memory usage in the Master nodes is always around 90%. I don't have OOM right now, but I was ...
-1
votes
2answers
59 views

SQL used memory exceed to its max memory [duplicate]

I have 32GB server running a SQL Server instance and I have set the max server memory to 22 GB which is 75% of the total memory. What is the reason for SQL Server to exceed its allocated max server ...
1
vote
2answers
31 views

Is it possible to have a temporary, on-the-fly PostgreSQL table which only ever lives in RAM?

I know that PostgreSQL automatically uses RAM only for tables that are small enough. But I'm not just talking about the data inside the table, but about the entire table itself. Basically, I've (...
2
votes
0answers
67 views

Some SQL Server memory consumers keep stealing memory from “Total Server Memory” ? It keep decreasing without any external memory pressure

Problem Description : SQL Server Memory Usage keep increasing while Total Server Memory keep decreasing till ERROR: fail_page_allocation accoured and instance crash Version : SQL Server 2017(RTM-CU21) ...
0
votes
0answers
11 views

MySQL Performance schema : CURRENT_NUMBER_OF_BYTES_USED high for disconnected user

I'm investigating memory usage on one of my MySQL servers. I can see a continually increasing memory usage according to the stats in performance_schema when looking at the data in the ...
2
votes
2answers
56 views

How memory limit for backup process is calculated?

How "memory limit" for backup process is actually calculated?
2
votes
1answer
53 views

SQL Server 2014 only using 10 percent of its available memory? [duplicate]

Hoping someone can weigh in here. I have a 2014 developer edition box that doesn't seem to be performing well. I currently have 128 GBs of RAM allocated to the box and 120 GBs maximum allocated inside ...
1
vote
4answers
94 views

Mysql 8.0.21 long lived prepared statements have a memory leak ? or are we doing something weird

-- updated the question because it was easy to initially assume I was asking for mysql tuning tips, although some of the tips did help me narrow down the problem -- -- further update. After doing ...
0
votes
3answers
76 views

High CPU and plan cache instability

In the past couple of months my SQL Server instance has been experiencing higher than usual CPU usage than before, at times hitting 100% and affecting an application. There have been no recent changes ...
3
votes
0answers
47 views

Mysql memory usage increasing after upgrading to 8 and converting some tables from MyISAM to InnoDB

I am having an issue with MySQL gradually consuming more memory every day which seems to have coincided with converting some tables from MyISAM to InnoDB two weeks ago. You can see the trend in memory ...
1
vote
1answer
58 views

SSIS installation on the same server as SQL Server

We currently have an SSIS installation on the same server as SQL Server. This SQL Server installation is strictly to run SQL Server Agent to schedule the jobs that execute the SSIS packages deployed ...
0
votes
1answer
20 views

MariaDB RAM usage does not reflect configuration

I've got 256GB RAM. InnoDB pool buffer size is 128GB, and InnoDB data + indexes in all databases are about 105GB. Most of that data is frequently queried so, correct me if I am wrong, it should reside ...
1
vote
2answers
138 views

MariaDB 10.5.8 memory leak (MyISAM) on master but not slave

We've recently migrated a legacy application from MySQL 5.5 on Amazon Linux to MariaDB 10.5.8 (latest, from the official repos) on Amazon Linux 2. The "hardware" went from an m3.large ...
0
votes
1answer
227 views

Oracle 12cR2 / ORA-04031 - Unable to allocate xx bytes of shared memory (Shared Pool) (Hard Parse & Parallel Queries)

Sometimes I'm getting ORA-04031 error on my DWH database. The last one like this: "ORA-04031: unable to allocate 56 bytes of shared memory ("shared pool", "unknown object", &...
0
votes
1answer
67 views

PostgreSQL database with 9000 tables continuously grow in memory usage

I have a PostgreSQL database that I use to store time-series (finance) data. each table contains the same table schema but has a different name based on the market pair and timeframe. Ex. I have ...
4
votes
1answer
235 views

Why is my SQL Server giving out of memory errors when there should be plenty?

I have a production system running SQL Server 2019 Standard edition. It recently had a problem 3 times in 1 day where it became unresponsive until a reboot. Errors seem to point to memory limitations. ...
0
votes
1answer
56 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 ...
0
votes
0answers
18 views

MongoDB too many forked processes

We are having an issue with the MongoDB high usage memory, this is an AWS EC2 server running only MongoDB on docker container. total used free shared buff/cache ...
1
vote
2answers
151 views

Troubleshooting high memory usage on MariaDB 10.5.4

I am experiencing very high memory usage on MariaDB server. I am not sure if it is due to misconfiguration or a bug. Server: MariaDB Server version: 10.5.4-MariaDB MariaDB ...
0
votes
1answer
64 views

MongoDB high usage WiredTiger

We are having difficulty with MongoDB high RAM usage in AWS EC2 Instance ubuntu with 30GB RAM. In our server, there are over 3K databases and It's out of memory from time to time. I read a lot about ...
1
vote
1answer
98 views

SQL server memory pressure

First observed few months ago at end-user's laptop (rather slow i3 CPU, 4GB RAM, SSD) with SQL 2014 Express. The problem persists with SQL 2019, even with clean Windows 10 1903 installation. The ...
-1
votes
1answer
35 views

How can I figure out what the minimum MaxMem value could be without causing issues. MSSQL 2017 Enterprise CU18

I am running several 2017 CU18 instances in failover clusters with "standby" instances for planned growth. I want to configure those standby instances with the least amount of RAM (lowest ...
3
votes
4answers
124 views

SQL Server memory

It's regarding the SQL Server memory. When the server is running out of memory, we recommend adding additional memory to the hardware to overcome CPU utilization issues. But before proceeding to the ...
0
votes
1answer
48 views

In Memory OLTP causing OOM Issue in SQL Server even though no data in In Memory OLTP Table

We have only 1 memory optimized table in each database and there are total 10 databases as such. This table is completely empty. But still we can see in DBCC MEMORYSTATUS Output that In memory OLTP is ...
1
vote
2answers
29 views

Why MySQL tends to use more and more swap while there is enough RAM?

I have a server with 64GB RAM and 64 GB swap. It's running MySQL 8.0.19 and few php scripts. Here is my config: innodb_buffer_pool_size=40G innodb_buffer_pool_instances=4 innodb_buffer_pool_chunk_size=...
3
votes
2answers
234 views

MS SQL Server - Increase allocated memory

My problem is that SQL Server takes a long time to ramp up it's memory usage for instances with TB worth of RAM, all the while we get intermittent waits of MEMORY_ALLOCATION_EXT that slow down our ...
0
votes
1answer
45 views

What parameters should be modified after upgrading RAM memory in Oracle server

I have a linux server (rhel4) with oracle 9i (9.2.0.8) to which we have recently upgraded the RAM memory from 4G to 16G. I would like to know what server parameters I should modify and even more what ...
2
votes
2answers
80 views

What is the best configuration for a MySQL instance with a lot of databases and lot of tables?

I have a MySQL database instance with more than 3000 databases in it. Each database contains more than 200 tables. Total data of all theses database comes around 100 GB. I am using Windows Server ...
1
vote
1answer
21 views

mysql percona 5.7 not releasing memory

we are using percona mysql 5.7 version. MySQL not releasing the memory after operation complete. we are very much grateful if anyone can guide us to resolve issue. Thanks
0
votes
1answer
52 views

MySQL Client out of memory when running a simple select query from MSSQL ODBC

Table has a total of 1,120,000 rows and 20 columns. When I run a select query on mysql directly like: select * from <tablename> where UpdatedOn > '2020-10-05' it gives the results which is ...
0
votes
0answers
65 views

MongoDB MongoError: Out of memory

I have a newly installed MongoDB server running on an AWS Ubuntu EC2. The server has nothing else installed on it. The DB currently contains 35 documents of 3 MB each, meaning less than 110 MB of data....
0
votes
1answer
181 views

How is the “Adjust memory quotas for a process” user right assignment used in SQL Server 2019?

I am looking at the Configure Windows Service Accounts and Permissions doc (https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-windows-service-accounts-and-permissions?...
2
votes
0answers
279 views

MongoDump Failed: error writing data for collection `collection` to disk: error reading collection: EOF

[BACKUP COMMAND] mongodump --host 127.0.0.1 -d database --port 27017 --username username --password password --out /output/path/mongodump_DATE_12_00_AM [ISSUE] Failed: error writing data for ...
0
votes
0answers
93 views

MySQL: Configuring the right innodb_buffer_pool_instances and innodb_buffer_pool_chunk_size on RDS with huge RAM

We are on a db.r4.8xlarge MySQL (version 5.7.23) AWS RDS instance with 16 cores, 32 vCPUs, and 244GB RAM. We set the Buffer Pool Size to around 144GB at the default innodb_buffer_pool_chunk_size and ...
0
votes
0answers
33 views

Enable jemalloc for MySQL 5.7 WHM Server

i want to enable jemalloc on MySQL 5.7 on cPanel/WHM server on Centos 7. i install jemalloc: yum list jemalloc yum install jemalloc.x86_64 after that edit /etc/my.cnf and add: [mysqld_safe] malloc-...
2
votes
1answer
257 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 ...
1
vote
0answers
69 views

High CPU on Unloaded Server — Performance Monitor

We recently upgraded a very lightly used SQL server (running < 5% CPU 99% of the time) from 2012 to 2016. In conjunction, we moved the server from an AWS t2 to a t3 instance and installed the new ...
-1
votes
2answers
75 views

How can Postgresql use more of the total RAM?

I'm trying to undertstand how Postgresql's (v9.1) memory usage relate to the overall Linux memory. When I look at htop, I see that the system is using about 60GB out of a total of 256GB RAM. That ...
4
votes
2answers
143 views

Cannot reclaim Index Unused Memory in In-Memory OLTP

Steps to reproduce the problem Create a database with memory-optimized filegroup and container Create schema only in-memory table with nonclustered pk Simulate insert and delete activity. My result is ...
0
votes
1answer
174 views

MySQL 5.7 High Memory usage Killed by OOM

i upgrade my WHM server / Cent-OS 7 from MySQL 5.6 to 5.7. after that upgrade every few hours my server memory full by MySQL which after hours of MySQL restart it exceed 80% of whole memory. i ...
0
votes
1answer
27 views

How much memory does the MySQL server variable table_open_cache cause the DBMS to use?

Simple question, but I have been unable to find simple answers. So the default value for the table_open_cache server variable is 2000. Which means 2000 slots for 2000 files. We can assume each slot ...
0
votes
1answer
36 views

Wrong Memory is displaying in task manager for Default and Named instance in Sqlserver

I have installed 2 instances on a Sqlserver 2016.When the Performance of the server is degrading , i could see huge transactions are happening on the Default instance and there were no connections ...
2
votes
1answer
80 views

Reason why SQL Max memory expansion seems slow when migrated to newer version of SQL server

We are trying to understand below behavior happening in SQL Server and need some guidance:- After migrating from older version SQL2012 (running on bare metal P Server) to newer SQL2017 running inside ...
1
vote
0answers
70 views

MySQL router on server with tomcat memory leak

Memory is slowly used by mysql router. I am running mysql router version 8.0.20 (I found there was a memory leak on mysql router 2.1.2 but mysql router 8.x is newer) I have a 3 node single-primary ...
0
votes
2answers
187 views

varchar(n) size?

When I use varchar(5) in a INSERT query it means that the attribute in the table will take exactly 5 bytes in memory? (Given that one printable character takes one byte)?
0
votes
1answer
27 views

How to determine actual memory occupied by Query Cache in MySQL?

How can we check if the MySQL server is utilizing high memory/RAM ? How much memory is occupied in total by query cache ? How much memory is fragmented ? Basically what is occupying xGB off memory by ...
0
votes
1answer
381 views

Greenplum ERROR: Canceling query because of high VMEM usage

We have a GreenPlum Cluster which we have set up recently and getting this error on a single query run: current group id is 140611, group memory usage 40720 MB, group shared memory quota is 31320 MB, ...
0
votes
2answers
49 views

Does large text datatypes reserves storage on disk?

I'm design an DB for an app, in a table there is a column MEDIUMTEXT which according to mysql doc can storage on disk upto 16MB. So my question is if I'm storing a text of 1Mb in this column, will it ...
1
vote
2answers
52 views

Why does TempDB spill happen even though statistics are correct?

I read a great article published by Brent Ozar and came up with some questions related to memory grant. I am unable to address my questions in the comment section of his article, so I thought to get ...

1
2 3 4 5
14