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.
4
votes
1answer
220 views
How much memory is a table taking up?
Is there a way to find out how much memory a table is taking up in SQL Server (2005 and greater)?
For example, suppose I have a table with 30 million records. I'd like to know how many pages ...
6
votes
2answers
928 views
View Postgresql Memory Usage
I'm running Postgresql on a Ubuntu server and need to be able to monitor its memory usage. Currently I have scripts running in a one-minute cron job that monitor/log various statistics and need to ...
0
votes
2answers
64 views
MySQL still holding memory after I shut it down?
I used this command to shutdown MySQL, however it seems the amount of free memory on my box has not changed?
That seems to odd.
/usr/local/webserver/mysql/bin/mysqladmin -u ${mysql_username} ...
3
votes
2answers
711 views
ORA-04031: unable to allocate bytes of shared memory (“”,“”,“”,“”)
I am receiving this error in a development database.
It happens on some specific queries (simple inserts and deletes via .NET application).
The database is used by one user, and error happens ...
4
votes
3answers
2k views
How much memory will a MEMORY table take up?
Let's say I have a MyISAM table with a data length of 4.8GB and an index length of 6.2GB. So, a total data size of eleven gig. How much memory would this require, were I to convert it to a MEMORY ...
3
votes
1answer
2k views
I have lots of free memory. How do I use it to increase performance?
I am running Litespeed (with suExec, PHP SAPI), MySQL, DirectAdmin, named on a VPS with a 16-core Xeon CPU and 2GB RAM.
Currently, only 300 MB out of 2048 are used. It might sound a stupid, but how ...
3
votes
2answers
220 views
Is it important to release memory back to the server?
I have a SQL Server 2008 R2 instance running on a production system. I'm not a DBA; I'm more a developer, but my client is currently asking me: How important is it to release memory from SQL Server ...
3
votes
2answers
4k views
Is InnoDB Engine up to speed against Memory Engine?
I am exploring the efficiency of different database engines in MySQL version 5.5.18 to see which is best suited for use with a range query on a dataset of 5 million rows:
SELECT P.col1, P.col2, ...
2
votes
1answer
932 views
Mysql Memory table getting many locks
On my site I log every pageview (date, ip, referrer, page, etc) in a simple mysql table.
This table has the following activity:
1 SELECT per minute
1 DELETE per minute
no UPDATE queries
Lots of ...
0
votes
1answer
305 views
InnoDB table vs MEMORY table for a mysql environment with many inserts
I run my sites all on InnoDB tables which is working really well so far. Now I like to know what is going on in real-time on my sites, so I store each pageview (page, referrer, IP, hostname, etc) in ...
4
votes
2answers
2k views
Microsoft SQL Server 2008 Memory
I am running MSSQL 2008 Enterprise and in the configuration of the server the Max memory amount is set to 2147483647 MB.
My Question is, the server has 192 GB of ram,the number in the config can't be ...
2
votes
2answers
1k views
Mysql consumes a lot of memory
Here is my situation.
I have an ubuntu server monitored by nagios.
recently nagios sends alarms regarding the memory consumption on the server. I logged into the server and executed the top command ...
1
vote
4answers
757 views
RAM/memory based databases
I am looking for a RAM/memory based database, and these two seem to be interesting:
SQLite
Oracle Berkeley DB
Do you have any other suggestions?
I need more than one executable to be able to ...
7
votes
4answers
2k views
MySQL Cluster RAM requirement
From MySQL 5.1, the data doesn't need to be entirely in memory anymore.
I've read that the indexed columns (I think the entire index structure) must still be in memory (MySQL High Availability, 2010, ...
7
votes
3answers
4k views
SQL Server Max Memory not limiting use of RAM
I would like your input on this. I have a sql server 2008r2 Ent. Ed. 64bit with 16 cores and 64GB RAM. There is one instance of SQL server patched fully as of 20111014.
The max ram is set to 60000MB. ...
1
vote
3answers
203 views
RAM Impact on Oracle database operations
We are seeing drastic change in the amount of time taken for db operations depending on ram size.
The same content when inserted into a db running on a 4gb ram machine takes about 600% more than into ...
1
vote
1answer
64 views
RAM Impact on database operations [duplicate]
Possible Duplicate:
RAM Impact on Oracle database operations
We are seeing drastic change in the amount of time taken for db operations depending on ram size.
The same content when ...
6
votes
3answers
513 views
What advantages does in-memory OLAP have over traditional systems with significant memory?
Do in-memory OLAP engines have advantages over the traditional OLAP engines backed by enough RAM to contain the entire cube(s)?
For example, if I use a MOLAP engine (SSAS) and GB / TB of RAM where ...
3
votes
1answer
1k views
Why does MySQL use all of memory and goes into swap when doing lots of delayed inserts?
We have a database server running Centos 5.6 64bit 64Gb of RAM. The server is idle most of the time. However, every hour it gets a lot of DELAYED inserts. Up to 3 mil INSERTs per hour into a MyISAM ...
11
votes
3answers
2k views
SQL Server 2008 R2 “Ghost Memory”?
We have a dedicated SQL Server 2008 R2 machine that is experiencing some strange memory issues.. The machine itself has plenty of resources including two quad-core processors, 16gb of RAM and 64bit ...
7
votes
3answers
2k views
How to free SQL Server memory?
I have a SQL Server sandbox installation on my local computer. I have set the memory SQL Server instance can use to 1000 mb. When running an intensive operation, memory usage rises up to 1000 mb. When ...
3
votes
4answers
733 views
Is it feasible to have MySQL in-memory storage engine utilize 512 GB of RAM?
I am considering scaling up instead of scaling out. Therefore, I am interested to hear whether it is feasible to utilize the MySQL in-memory storage engine for a database that is 500+ GB, given that ...
5
votes
3answers
1k views
What is the default order of records for a SELECT statement in MySQL?
Suppose you have the following table and data:
create table t(k int, v int,index k(k)) engine=memory;
insert into t values(10, 1), (10, 2), (10, 3);
When issuing select * from t where k = 10 with ...
5
votes
1answer
304 views
How does table compression affect SQL Server's buffer pool?
I'm curious as to how SQL Server's buffer pool is affected by compressed data tables.
Is the data in memory compressed, just as it is on disk, or is it fully decompressed?
If the data is stored ...
5
votes
1answer
3k views
How do you increase MySQL performance using current server resources?
I have a MySQL database and some of my queries became slow. Query time is not stable. Most of the queries are fast, but some of them (may be that reads and returns less data) take long time.
I know ...
3
votes
1answer
534 views
No “Using locked pages for buffer pool” in SQL Server log
As a trial run for a client I am trying to enable the "Lock Pages in Memory" setting on my development server, but no matter what I change, I cannot get the "Using locked pages for buffer pool" to ...
14
votes
3answers
18k views
Recommended page file size for SQL 2008R2 on Windows 2008R2
This Microsoft article - How to determine the appropriate page file size for 64-bit versions of Windows Server 2008 and or Windows 2008 R2 provides guidance for calculating the page file size for 64 ...
7
votes
3answers
730 views
I am using the MEMORY storage engine but MySQL still writes to my disk…Why?
I am using the MEMORY Engine for all tables associated with a particular MYSQL query because speed of access is paramount to my project.
For some reason, I have noticed that a large amount of disk ...
1
vote
3answers
2k views
SQL Server service unresponsive
I am unable to connect to the SQL Server instance. Logging into the box remotely I can see both CPU and MEMORY are maxed out. I have tried to restart the SQL Server service which has resulted it in ...
5
votes
3answers
3k views
MySQL gives “Out of Memory” error when inserting a large file. From where is this filesize limitation arising?
I'm using a MySQL database to store files.
The table I'm using is structured as follows:
+--------------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default ...
10
votes
5answers
3k views
PostgreSQL: Force data into memory
Is there a systematic way to force PostgreSQL to load a specific table into memory, or at least read it from disk so that it will be cached by the system?
5
votes
4answers
7k views
Why does MySQL say I'm out of memory?
I was trying to execute a fairly large INSERT...SELECT in MySQL with JDBC, and I got the following exception:
Exception in thread "main" java.sql.SQLException: Out of memory (Needed 1073741824 bytes)
...
7
votes
2answers
2k views
What are reasons *not* to use the MEMORY storage engine in MySQL?
I recently discovered that MySQL has a "memory" engine that I wasn't aware of (most of my database work is for hobby projects so I learn what I need as I go). It seems like this option should give me ...
4
votes
5answers
1k views
What is the best use of memory in MySQL?
I have a MySql server with 2Gb of memory. What's the best configuration to use then with best results? How can I "distribute" this memory fine to MySql server?
24
votes
3answers
2k views
On a dedicated database server, how much memory to reserve for the OS?
Assuming you have a dedicated server explicitly for database functions -- how much memory should you reserve for the operating system?
I realize this will probably vary somewhat depending on the ...
