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.

learn more… | top users | synonyms

0
votes
0answers
4 views

Is it advisable to configure huge pages on SLES for MySQL

What is a general opinion on using huge pages with MySQL server? As described in here: https://dev.mysql.com/doc/refman/5.7/en/large-page-support.html Or is it best to leave things as is and not ...
-1
votes
0answers
19 views

Get results from a query without calculate it [on hold]

i'm working with a big database more than 50 GB and basically the system that is using this database is to generate reports, I want to know if there is a way when I try to generate a report for second ...
0
votes
2answers
22 views

Mysql query larger than tmpfs (ramdisk)

I recently set up a ramdisk tmpfs on our mysql server and the performance improvement has been quite noticeable. I've allocated 24 out of 32 GB's of ram for the ramdisk. My only concern is what ...
7
votes
2answers
257 views

SQL Server not using all memory

I have SQL Server 2014 with max memory set to 6GB (physical memory is 8GB). The Target Server Memory is sometimes 6GB and then drops back to Total Server Memory (approx 5.3GB, never reaches 6GB). I ...
0
votes
0answers
15 views

MongoDB collStats.size compared to collection.totalSize

I have a collection which has the following dimensions: rs0:PRIMARY> db.myCollection.totalSize() 2188206080 rs0:PRIMARY> db.myCollection.stats() { "size" : 5899660704, "avgObjSize" : ...
1
vote
1answer
28 views

no free memory but low total memory

I have SQL Server 2012 SP2 that has a max memory of 25.4GB but SQL Server is only using 15GB. When I check free memory with the PerfMon SQLServer:Memory Manger Free Memory (KB) counter only 40MB is ...
2
votes
1answer
19 views

In [Percona] MySQL, is the Adaptive Hash Index included in the Total memory allocated count?

I'm debugging a memory problem with MySQL 5.6 (I'm using the Percona distribution), but I can't figure out, searching around the web, if the Adaptive Hash Index amount is part of the Total memory ...
2
votes
2answers
25 views

MySQL lock on MEMORY storage engine, when does it apply?

I want to use MySQL MEMORY storage engine to handle my PHP session variables (actually I already implemented it but since all my tests are being done by a single user, me, I am unable to notice this). ...
1
vote
0answers
31 views

Failed to allocate reserved pages: FAIL_RESERVED_PAGE_ALLOCATION

Last night I received the error on one of my servers of: Failed to allocate reserved pages: FAIL_RESERVED_PAGE_ALLOCATION 2047 I know that this has already been discussed on here some but all ...
0
votes
2answers
50 views

Memory leak on MySQL slave?

I have a Percona MySQL master-slave server configuration(5.6.20-68.0). The memory usage by MySQL on the slave server is constantly growing. Now it reached 68G despite on fact that ...
0
votes
1answer
32 views

Memory usage increases whenever I run stored procedures [duplicate]

I want to know why SQL Server memory use increases whenever I run stored procedures. After I stop and restart SQL Server, the memory used is just 1 GB. Each time I run stored procedures, the memory ...
1
vote
1answer
45 views

SSIS Buffer/Memory Failure

I get this error when running SSIS package... A buffer failed while allocating 104857600 bytes. The system reports 31 percent memory load. There are 17179328512 bytes of physical memory with ...
1
vote
0answers
57 views

A significant part of SQL Server process memory has been paged out

Around 7:30pm every evening we receive the following message and the server experiences an outage of 2 minutes. A significant part of sql server process memory has been paged out. This may result ...
1
vote
0answers
43 views

Unexpected Memory Pressure - RESOURCE_SEMAPHORE wait

Introduction I am seeing some odd behaviour on one of my servers. It’s non production server, and is only used for my own testing and data collection, so I wanted to use this as a learning ...
0
votes
0answers
32 views

Is it possible, when using LPIM, for one database to allocate the majority of the memory?

Windows Server 2012 R2 SQL Server 2012 Enterprise (maximum server memory: 200,000MB) 224GB memory LPIM enabled physical_memory_in_use_kb 204703788 large_page_allocations_kb 1128448 ...
0
votes
0answers
26 views

MySQL Storage Engine and Memory

I recently found out that, the databases does not have standard architecture(data model), some of them are, No relationship between tables(entities). No indexes defined. Only integer and varchar ...
1
vote
2answers
53 views

Contiunous rise of mysqld memory consumption

Mysqld memory consumption rises forever and never seems to be freed. It starts out about 6GB but gradually rises to around 10GB in a few weeks, and of the 10GB only 4GB and 50MB is being used by the ...
0
votes
0answers
23 views

How to add an index to attributes sorted on in mongodb

Before you find another reason for changing the category of this question, it was on Stack Overflow and it was described as a DB Admin question, so here goes: I am running a reporting app with ...
-7
votes
2answers
133 views

Why over 1.3TB desired memory for this query, it should have no memory grant? [closed]

SQL Server version is 2014 Developer SP1. Trace Flags 272, 610, 1118, 1206, 1222, 8048, 9481 are globally turned on. We had to turn on flag 9481 since the new cardinality estimator badly effected ...
0
votes
1answer
89 views

SQL Server 2012 doesn't use enough memory

Under heavy Load, my SQL Server database is executing queries really slowly. I have 96 GB of RAM and my CPU is high (100%) but my physical memory usage is at 9%. I looked at the SQL Server memory ...
0
votes
1answer
32 views

Maximum Server Memory adjust in blocks of 1024MB?

Our protocol is to set Maximum Server Memory at about 75% of RAM. For a 4GB RAM, sometimes it gets set at 3000MB and sometimes to 3072MB. There is a 2 or 3 percent difference in these values. Is ...
0
votes
0answers
28 views

Unexplained MariaDB/MySQL memory jump

All of a sudden the memory usage of my MariaDB instance has jumped from around 1.5GB to 6GB. A restart briefly solves the issue, but slowly creeps back to the peak value. Stopping all processes that ...
1
vote
1answer
77 views

MySQL difficulty with optimizing slow query with index but without improvement. Explains tells otherwise

I've a slow query (~11 seconds) that I'm trying to optimize. But the use of indexes seems to not make any difference even thou Explain indicates otherwise. Let me walk you through my problem. So this ...
2
votes
0answers
184 views

MySQL 5.7 + Ubuntu 14.04 eating up my RAM

I've recently installed MySQL 5.7.11 in my Ubuntu 14.04.3 system following these instructions: http://dev.mysql.com/doc/mysql-apt-repo-quick-guide/en/ Being totally empty and not being called by any ...
1
vote
1answer
105 views

The database manager failed to allocate shared memory because an operating system kernel memory limit has been reached

I have installed IBM DB2 10.5.5 and I want to create a new database there. When I entered command db2 create database test1 I am getting a error saying SQL1084C The database manager failed to ...
0
votes
1answer
135 views

SGA size not decreasing after reducing memory_target (Oracle 11.2.0.1)

I have an Oracle 11.2.0.1 database using dynamic memory allocation with parameter MEMORY_TARGET. When I decrease it with SCOPE=BOTH, the size of the SGA doesn't seem to decrease along with it. I have ...
1
vote
1answer
85 views

Maximum possible memory usage over 100%

During these days I experienced several problems (delay and failed restart) on my database MySQL, so I tried with some help here around (and using Percona service too) to optimize my /etc/mysql/my.cnf ...
5
votes
2answers
791 views

Maximum SQL Server memory set to 12 GB, but it still goes over 12 GB. How do I prevent SQL Server going over max memory limit?

User 'mrdenny' wrote that after you set SQL Server maximum memory... Now this isn't going to limit all aspects of SQL Server to that amount of memory. This only controls the buffer pool and the ...
5
votes
1answer
179 views

There is insufficient system memory in resource pool to run this query

Over the past year we have been suffering a situation where many different queries at the same time will fail with the following error (or a variation in a different resource Governor group): There is ...
0
votes
2answers
40 views

MySql not using Buffer Pool

I'm checking into a buffer pool issue on a MySql database. According to the query to get database size shown here, the total database size is about 11GB. Unfortunately I know I have much less RAM than ...
3
votes
0answers
36 views

High paging and memory consumption in SQL Server [duplicate]

This is my first question about SQL Server, I'm new to SQL Server and I don't understand few things, so hope you can help me. We got a SQL Server 2008 with 2 instances and also with Analysys Services ...
1
vote
1answer
116 views

Don't preallocate many gigs of ram in Oracle Database 12c?

I've just installed Oracle Database 12c Enterprise for Windows. The first thing I've noticed is it preallocates almost 10GB ram. How can I configure Oracle to only allocate and deallocate ram as ...
4
votes
2answers
228 views

SQLServer:Buffer Cache Hit ratio is a good indication of POSSIBLE memory bottleneck?

I am looking for an indication (if any) that would either disregard the memory bottleneck option, or accept it, or make me investigate further. for instance: page life expectancy: SELECT ...
2
votes
2answers
135 views

PostgreSQL is using more memory than I'd expect

I have PostgreSQL configured mostly how pgtune recommended, and the settings are supposedly conservative. PostgreSQL is using more memory for a single connection than the settings would suggest is ...
5
votes
2answers
95 views

Can SQL Server (2012-2014) be configured to run “on-demand?”

I am very, very new to SQL, and am having difficulty configuring the server appropriately. All I have to work with for now is a small copy of the database schema of the company I work for, with ...
0
votes
0answers
225 views

MySQL Tuner script to optimise MariaDB 10.1 install on 512MB VPS - MySQL's maximum memory usage is dangerously high

I have installed MariaDB 10.1 onto a 512MB CentOS 7 x64 VPS & enabled InnoDB. On this machine, I am also running NginX (1 worker process) & PHP-FPM (2 child, 2 spare) with php.ini memory limit ...
4
votes
1answer
221 views

SQL Server 2012 Express high Commit (KB) (low virtual memory condition)

I have a customer running SQL Server 2012 Express Edition: Microsoft SQL Server 2012 - 11.0.2100.60 (X64) Feb 10 2012 19:39:15 Copyright (c) Microsoft Corporation Express Edition (64-bit) on ...
0
votes
2answers
52 views

Disable MEMORY_TARGET after being locked out of database?

I'm setting up a local development environment in a virtual machine in which I installed Oracle XE among other software. When I initially set up the virtual machine, the RAM was set to 4Gb. In this ...
0
votes
0answers
19 views

T-SQL script to analyse recent changes in SQL Server configuration?

Last week suddenly one of our VMs running SQL Server slowed down considerably and its performance dropped to the level where some of us cannot work on it any more. Just to give you an idea about the ...
1
vote
1answer
44 views

On an idle instance, why does setting max memory to 256mb cause %CPU to jump

Five 2012 instances on a 2-node cluster using AVGs. Two of them doing nothing yet, no user databases or users. Customer insists on specific max mem settings while waiting for additional memory ...
0
votes
1answer
263 views

memory usage oracle query

We see Direct path read temp frequently in the database. It started with one query and later followed up to all the queries running in database at that moment. I understand that data is read from ...
3
votes
2answers
137 views

Release MySQL Memory and Performance Tunning

I am new to the MySQL database. I have recently installed MySQL 5.7 and configured the my.ini file. Please find the below copy of the file. The server is a dedicated server for MySQL database and the ...
2
votes
1answer
64 views

Using an index on a Postgresql integer range causing trouble

Unfortunately I was not able to create a usable example / fiddle. But I am using a Postgresql 9.4 table that looks somewhat like this: CREATE TABLE table1 (id INT PRIMARY KEY NOT NULL, dtype TEXT, ...
1
vote
3answers
370 views

How to decrease RAM usage of SQL Server 2012 without restarting Service

Is there a way of decreasing RAM usage of SQL Server 2012 without restarting it? Setting up MAX Memory usage is not an option as it's quickly building up to limit I have set and then app based on ...
4
votes
1answer
78 views

SQL Server Memory Shrinking

I had a strange issue today on a 3rd party vendor's SQL Server. This is a VM running SQL Server 2012 SP1. The min and max memory settings are set to 9GB. Task manager showed SQL Server was getting the ...
0
votes
1answer
474 views

#1041 - Out of memory issue in mysql [closed]

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 ...
2
votes
1answer
129 views

Unable to turn off automatic memory management (AMM)

i am running oracle 11.2.0.4 SE RAC on Red Hat linux 6, the database is using ASM for datafile management i have been experimenting with turning on AMM and set the following parameters alter system ...
1
vote
1answer
299 views

Mysql Tuning for a small server

I have a small Cloud Server running under Ubuntu 2 core, 2GB ram and 2GB swap, with Plesk Panel, Apache, Nginx as reverse proxy and Mysql 5.5. I have about 18 domains hosted here and each domain has ...
1
vote
2answers
101 views

Would SQL Server in a Cluster failover if it is running out of RAM

I have a SQL Server 2008 R2 in a Cluster in an active-passive mode. The server is running out of RAM (both physical and pagefile). In the instance level settings there is not Max RAM set (set to the ...
1
vote
2answers
41 views

I changed the max memory setting but I don't see memory usage rise at OS level

We have increased the RAM capacity on the OS to 40G and I have changed the max memory parameter to 36G in SSMS. When I select "current value", it shows 36G. However, monitoring memory usage at OS ...