0
votes
0answers
16 views

Cluster Manager Ignoring Config File

I have just setup my first cluster manually (not using the auto install) and it all works great. I have 1 SQL node, 2 data nodes and 1 management node (all on separate machines). I intend to port ...
0
votes
1answer
106 views

Database server size

I received a recommendation from my hosting provider noting that a general rule in production server management is to ensure that the memory on your database server is larger than the size of your ...
3
votes
2answers
1k views

How can I check if my DB needs more RAM?

How would you check if your postgresql DB instance needs more RAM memory to handle their current working data?
4
votes
3answers
222 views

What hardware & software consideration does a major website require to properly manage 1000+ servers? [closed]

Sorry for such a high level question. I understand the basics of server load balancing, but the concept of managing 30,000 servers is a bit foreign to me. Is it really just the same concept of ...
9
votes
2answers
10k views

Best Mysql cache settings for 8gb RAM dedicated mysql server using only Innodb (5gb database)

I'm a pretty big noob when it comes to setting up mysql for performance. And honestly I'm not worried about the fine tuning to squeeze every last bit of performance out of mysql, but I do know that ...
32
votes
7answers
2k views

Database server: Small quick RAM or large slow RAM?

We are currently designing our new database servers, and have come up with a trade off I'm not entirely sure of how to answer. These are our options: 48GB 1333MHz, or 96GB 1066MHz. My thinking is ...
1
vote
2answers
566 views

What happens to redis when your server runs out of free RAM?

Let's say you're hosting redis on a small server with little RAM. What happens if there's too much data, and all the RAM gets used up? Does redis die? Or does it continue operating?
20
votes
4answers
2k views

Can MySQL effectively take advantage of 64 GB RAM?

We have been running into a problem where querying a table that has approximately 50 million rows, and has an index size of 4 GB (table size of about 6 GB) results in the database server swapping ...
3
votes
2answers
322 views

Very large database, very small portion most being retrieved in real time

I have an interesting database problem. I have a DB that is 150GB in size. My memory buffer is 8GB. Most of my data is rarely being retrieved, or mainly being retrieved by backend processes. I would ...
0
votes
2answers
81 views

2 partitions in a sharded mysql database

the first one is running at 73% memory utilization. The second one runs at 16% utilization. how can i balance the 2 out?
0
votes
1answer
145 views

Memory Usage for Databases on Linux

So with free output what we care about with application memory usage is generally the amount of free memory in the -/+ buffers/cache line. What about with database applications such as Oracle, is it ...
0
votes
1answer
467 views

MySQL keeps restarting due to running out of memory

how can we prevent this from happening? it generally causes down time of about 30 minutes, which is extremely disruptive for service...
0
votes
1answer
100 views

Tomcat - Persistent Object

I am running a servlet that recommends items based on a data model. The data model has to be loaded into an object from a database each time user makes a request to the sever and since the data is the ...
0
votes
2answers
1k views

Oracle 9i Instance Memory Usage?

My question deals specifically with a way to tell how much memory is being used by an Oracle instance on a UNIX (Solaris) server. For example (I'm gonna really oversimplify this...), if I see that ...
12
votes
7answers
4k views

SQL Server - Force DB in memory?

We have a beefy Windows 2008 x64 server (4 x 4 core CPU, 32GB RAM) running SQL Server 2005 64-bit. We have a small (6GB) but very important database that is somewhat slow to access until the pages are ...