Linked Questions

0
votes
2answers
635 views

Cassandra: capacity planning [duplicate]

Im investigating moving some large DBs from MySQL to Cassandra and Im trying to figure out how to plan the cluster. Historically, one would just buy disks to contain the relevant data but Im not clear ...
0
votes
1answer
337 views

How good is this MongoDB/EC2 setup? [duplicate]

Hi, I wondered what was a good setup for AWS/MongoDB in terms of machines and the sizes of their disks. Current setup 3 micro machines for the config servers, 1 mongos and arbiters. The 8Gb limit ...
-1
votes
1answer
110 views

Choosing linux server for mysql - memory clock speed [duplicate]

I have a Linux Mysql server cluster where master and slaves are overloaded by a combination of read/write i/o and by SELECT queries load. We purchased FusionIO cards to replace the hard drives. My ...
0
votes
1answer
70 views

MySql calculate number of connections needed [duplicate]

I am trying to figure my needs regarding web service hosting. After trying Azure I have realized that the default MySql they provide (through a third party) limits the account to 4 connections. You ...
1
vote
0answers
51 views

My server is slower than the average user's computer, should I still offload Access queries to SQL Server? [duplicate]

Possible Duplicate: How do you do Load Testing and Capacity Planning for Databases I have a database set up with MS Access 2007 front ends and an SQL Server 2005 back end. At the moment, ...
-1
votes
0answers
16 views

Compression rate TSDB [duplicate]

I am considering an in-memory database solution for timeseries data. In order to estimate what kind of hardware I will approximately need, I need to know how much data will fit in an in-memory ...
50
votes
3answers
9k views

How do you do load testing and capacity planning for web sites?

This is a canonical question about capacity planning for web sites. Related: Can you help me with my capacity planning? How do you do Load Testing and Capacity Planning for ...
50
votes
2answers
7k views

Can you help me with my capacity planning?

This is a Canonical Question about Capacity Planning Related: How do you do Load Testing and Capacity Planning for Web Sites? How do you do Load Testing and Capacity Planning for ...
2
votes
2answers
852 views

Windows Server 2003 r2 vs 2008 r2 - Performance for SQL Server [closed]

First off, I'm not a sys admin, just a programmer frustrated by poor server performance… We’re currently running a VM (I believe the host is Win Server 2008) on a newer E5-2650 CPU, 24 GB RAM, at ...
1
vote
1answer
1k views

Mysql high memory usage and using swap

I have a 1.6GB database that adds about 200MB of size every month. I have a 12GB RAM(shared with apache, mysql and os), mysql always uses swap that i need to restart the service once it reached the ...
-1
votes
3answers
49 views

Which of the servers is suitable more for DB and which for front end? [closed]

Good day, I have a web-server running Apache with wsgi (Python) and Mysql database. The server is dual core, with 4GB RAM. The time has come for a system upgrade, and the new server will be Xeon ...
-3
votes
1answer
119 views

Can postgres go faster? [closed]

My question is simply: have i missed any configuration settings that might make postgres achieve better read throughput? Background I'm modeling a very simple twitter program. My schema has only 3 ...
3
votes
2answers
190 views

What's the optimal server configuration for fastest inserting in a MySql database in this scenario? [closed]

I have a MyISAM table partitioned by range with 90 partitions representing the last 90 days. I expect this table to receive somewhere between 500 million to 1 billion records before i start rotating ...
2
votes
1answer
67 views

Add new shard - always best? [closed]

In our setup, we currently have 3 shard set sharded cluster, each shard being a replica set of 3. Our writes are about to go up significantly to implement a new feature, and we know the extra data ...

15 30 50 per page