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

2
votes
2answers
407 views

Limit the RAM memory usage in MongoDB

I am using MongoDB-2.6.1. Is there any way to limit the RAM memory usage? For example: Out of 4 GB RAM, let MongoDB use till 3 GB (<= 3 GB).
0
votes
2answers
91 views

mysql uses too much memory

Current configuration: +------------------------------------------+--------------------+ | key_buffer_size | 64.000 MB | | query_cache_size | ...
4
votes
1answer
73 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 ...
2
votes
1answer
71 views

MySQL Memory & max_connections Performance Tuning

So, our site runs WordPress and in the past few days we have been getting tons of spam comments etc. I believe that we are becoming the victims of some kind of bot army that has been crashing our ...
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 ...
1
vote
1answer
126 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 ...
0
votes
1answer
79 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 ...
0
votes
1answer
72 views

SQL Server Memory Cap reached its maximum state and threw an Out Of Memory Exception

We have set a memory cap limit of 43GB in SQL server instance, so thereafter it keeps 42 GB near about and keeps near about 1 GB for its processing operations. But then we received near about 500,000 ...
0
votes
1answer
263 views

MySQL on Ubuntu consuming almost all RAM

I've been having an issue with MySQL crashing randomly, apparently as a result of not having enough available memory (as discussed here: ...
0
votes
1answer
81 views

Performance of MySQL BLOB fields processing

Suppose, I have large (about 1 GB) strings in ASCII encoding. I have to choose whether to store them as separate blob fields or split each one of them into smaller pieces and then store them as ...
0
votes
1answer
93 views

InnoDB compression: memory usage

InnoDB offers table compression for Barracuda-type tables and the recommendation seems to be to "adjust" buffer_pool_size. The documentation is rather vague about the definite impact of compression on ...
0
votes
1answer
518 views

Does MySQL load the entire row into memory, or just the columns used in WHERE, ORDER BY and GROUP BY?

I have a table that isn't very large row wise (in the 100ks range), but that contains a lot of raw data that is very large in size. Despite having a relatively little number of rows, it's around ...
4
votes
0answers
122 views

Find out why SQL Server released memory

I have a SQL Server 2008 R2 used for sharepoint and ssrs. The SQL Server hosts two instances. For a few minutes both instances were timing out, not responding. CPU slowly rose to 100%, 30% from ...
3
votes
0answers
283 views

What are reasonable options for an in-memory multi-core database?

I'm going to preface this with pointing out that I only need somewhat persistent data. The purpose of this database platform would be to support statistical analysis in R. I usually build my tables ...
2
votes
0answers
122 views

MEMORYCLERK_SQLOPTIMIZER in SQL 2012 Memory usage extremely high and causes server to crash

I have been having issues with our SQL server for a while now. It seems to run out of memory every few days and when I look at the memory dump, the MEMORYCLERK_SQLOPTIMIZER seem to take over memory ...
2
votes
0answers
333 views

Multi-Instance Windows Failover Cluster - Min / Max Memory Allocation Dilemma

We run numerous 2 node SQL Server 2008 R2 Failover Clusters in Windows Server 2008 R2 on a VMWare eSXi virtual platform. Each cluster hosts 3-4 SQL instances with varying degrees of memory ...
2
votes
0answers
538 views

How to raise Procedure Cache Hit Ratio?

I have a SQL Server 2012 instance with 96 GB of RAM that has the Buffer Cache Hit Ratio consistently at 100% and the PLE consistently over 500,000, so memory is obviously not a problem. However, my ...
2
votes
0answers
569 views

mariadb out of memory crash

I have recently migrated from mysql (5.5.36 MySQL Community Server (GPL)) to MariaDB (10.0.10-MariaDB-1~wheezy), along with switching my cloud hosting provider. Both machines have 2GB RAM and 1GB ...
2
votes
0answers
1k views

“custom archiver out of memory” error when restoring large DB using pg_restore

I'm trying to a restore a local copy of a 30GB DB (with only one table) dumped using the Heroku wrappers (described here) using pg_restore. The Heroku DB is using 9.1.7 and I have had the same result ...
1
vote
0answers
23 views

SSAS - what could I monitor in SSAS to fine tune its memory settings?

This question is a follow up from the SSAS - what could be a good starting point for memory settings? What and how can I monitor the server resources in order to best identify the settings that I ...
1
vote
0answers
16 views

Access algorithms in Partial Index implementation of PostgreSQL 9.4?

I am studying big-O time-space complexities of different algorithms with the partial index of PostgreSQL 9.4: introsort (O(n log n)-time, O(log n)-space) and heapsort (O(n log(n))-time ...
1
vote
0answers
82 views

Improve postgreql insert performance when compared to Oracle. Low memory utilization by Postgresql threads

I am trying to improve the performance of Postgresql (version 9.2.3) inserts for a simple table with 1 bigint, 1 varchar, 1 float and 2 time stamps. A simple replication of my JDBC program is ...
1
vote
0answers
105 views

A significant part of sql server process memory has been paged out. Lots of free memory though

Having a problem where my SQL Server 2012 SP2 Enterprise server says that most of SQL Server's memory has been paged out to disk but there's over 100GB free (of 256GB). From there system performance ...
1
vote
0answers
56 views

MySQL Cluster 7.4.6 - Analyze table failure on 15m reference table

I'm running MySQL Cluster 7.4.6 on Azure VM's with the following infrastructure: 2 x Mgmt Nodes: Ubuntu 14.10LTS, 2 cores, 3.5GB ram 2 x MySQL API Nodes: Ubuntu 14.10LTS, 2 cores, 3.5GB ram 2 x Data ...
1
vote
0answers
881 views

What to do with unused RAM on a MySQL database server?

For years I have been running dedicated servers with more or less limited ressources, resulting in unsatisfying performance of the web application (Drupal). Tools like Matthew Montgomery's MySQL ...
1
vote
0answers
701 views

pgAdmin goes “out of memory” with large queries

I am trying to run query with results stored in file from PostgreSQL. Now I am trying to use pgAdmin for this task: running query to file option. Problem starts with large queries. When I try running ...
1
vote
0answers
8k views

MySQL server taking up 100% CPU

I'm managing a site that does streaming video, the site is running off: Intel(R) Xeon(R) CPU E31220 @ 3.10GHz 16 GB RAM 2 x 2TB RAID1 1gbit unmetered bandwidth is not an issue as the ...
1
vote
0answers
222 views

Advice to set minimum preferable value for MEMORY_TARGET

I have a server having 90GB of RAM. I have set MEMORY_TARGET to 60GB, because OEM showed me the following graph: Which tells that, if you set the parameter to the value of 60GB, the performance ...
1
vote
0answers
304 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 ...
1
vote
0answers
58 views

memcached+mysql cluster maximum memory

I'm deploying a system with memcached and mysql cluster. The command line is: memcached -E lib/ndb_engine.so -e "connectstring=maddy:1186;role=dev" I can't specify the -m argument since I used -E ...
0
votes
0answers
59 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 ...
0
votes
0answers
13 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 ...
0
votes
0answers
48 views

Memory usage still growing

I have problem with my production mysql server. The memory usage is still growing and I don't know why. Trouble started when we changed the server. My mysql version: 5.5.44-0+deb8u1-log - (Debian). ...
0
votes
0answers
26 views

Enormous MySQL 5.5 Handler_read_rnd_next

The value of Handler_read_rnd_next is actually 91,3 G on my Database server but I am pretty sure that all tables have proper indexes. I am 100% sure that there is no query with a WHERE clause that ...
0
votes
0answers
64 views

Relationship between file shrink and used memory in SQL Server

Some background info: this is a test SQL Server 2012, with restored databases from production servers, all of them with over 20% space available in the data file, up to even 50%. I'd rather restore as ...
0
votes
0answers
161 views

Maxing out the shared pool's memory by executing many UPDATE statements (ORA-04031)

I was executing a bunch of UPDATE statement. Around ~32.8K got executed and committed, then got the error: cx_Oracle.DatabaseError: ORA-04031: unable to allocate 3896 bytes of shared memory ...
0
votes
0answers
50 views

Memory consumption of production MySQL

The MySQL database on one of my production servers consumes a lot of memory. The problem is that I cannot trace what causes that kind of high memory usage. Following values illustrate the problem. ...
0
votes
0answers
316 views

mysql eating RAM without queries?

Somehow MySQL eats up 50% of my RAM on the server being used. I checked and there are no queries, show full processlist is empty. I restarted the mysqld and within a couple of minutes the RAM usage ...
0
votes
0answers
193 views

Mongo DB accessesNotInMemory issue with RAM size

I am using Mongo Replica set and it seems to be working fine but when i check db.serverStatus i saw that there are lots of accessesNotInMemory for all The DBs in my mongo instance. I checked MY RAM ...
0
votes
0answers
151 views

Why only ~half of RAM is used by Oracle on Linux server?

Why Oracle 11.2 would be using only around half of available RAM on RHEL5 box? I have 64GB but 32GB is free which really annoys me. Any memory not used is wasted memory in my books - especially on ...
0
votes
0answers
439 views

MYSQL Out of memory, table crashing

an specific table on my DB keeps crashing. I suspect to be a bad buffer setting on my.conf, it show this error before crashing (most of the time it needs to be repaired): 18:26:59 [ERROR] ...
0
votes
0answers
115 views

innodb fulltext Table handler out of memory

I am running mariadb 10 and have a large innodb table with a fulltext index. When searching I am regularly getting this error ERROR 128 (HY000): Table handler out of memory Is there some way I ...
0
votes
0answers
49 views

Single query consuming most memory on server intermittently

Periodically, my SQL Server 2008 DB will come to a crawl because most of the connections are in memory wait. When I query the memory_grants DMV I see that three connections have been allocated ~33% of ...
0
votes
0answers
180 views

Memory Issue - SQL Server 2008r2

I am trying to troubleshoot a memory issue on a 2008r2 instance. Very high resource semaphore waits are present and a general slowdown of queries,backups,dbcc checks. Only one instance of SQL Server ...
0
votes
0answers
92 views

Set max memory lower than minimal

I dont know the best way to fix that, but for lucky now I am using one Transactional Replication Repository server, please someone can save me? The main server is down beacuse I set the max memory to ...
0
votes
0answers
187 views

How much RAM do I need?

Let's assume a query like the following as typical: select A.`date` as `date`, count(*) as N from A as A join B as B on B.id = A.b_id join C as C on C.id = B.c_id join D as D on D.id = ...
0
votes
0answers
118 views

MySQL overtaking system memory and forced to restart

I'm facing a frustrating issue. I have a MySQL Server 5.5 running on top of Ubuntu Server 12.04.3 LTS (VMWare guest w/ 16GB RAM - 8 Cores) mysqltuner.pl says [OK] Maximum possible memory usage: ...
0
votes
0answers
284 views

After RAM upgrade on 32-bit Oracle server, ORA-04031: unable to allocate x bytes of shared memory

We are in the process of upgrading our Oracle database server at work, from SUSE Linux Enterprise Server 10.4 / Oracle 10g / 4GB RAM (Intel 32-bit) to Scientific Linux 6.4 / Oracle 12c / 8GB RAM ...
0
votes
0answers
102 views

MongoDB RAM requirements doubt

I have a data file with 100 million documents. The number of documents is expected to always remain between 100 million and 200 million for atleast a year. I have 15 GB Ram. Currently the update ...
-1
votes
0answers
13 views

Sqlite retaining huge memory even after transactions

I am using sqlite browser to run some queries. In case of queries which return huge data, sqlite consumes large amount of RAM and does not free it until the browser is closed / killed. Is there a way ...