Linked Questions

0
votes
2answers
822 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
439 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 ...
0
votes
1answer
125 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
votes
1answer
148 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 ...
-1
votes
1answer
104 views

Minimum System Requirements for MariaDB [duplicate]

I recently set up a CentOS 7 server on digitalocean, I went with the $20 a month plan because i found these minimum specs for MYSQL. When i did a LAMP install it had me install MariaDB instead. I'm ...
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, ...
65
votes
4answers
17k 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 ...
71
votes
2answers
11k 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
1answer
4k 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 ...
2
votes
2answers
2k 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 ...
-3
votes
1answer
181 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 ...
0
votes
0answers
287 views

java.lang.OutOfMemoryError: Unable to create new native thread when auto deploying a REST crud app

I have deployed a simple JEE app on my openshift app but when I take a look to server.log I found that a "java.lang.OutOfMemoryError: Unable to create new native thread" is avoiding wildfly from ...
-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
2answers
188 views

System Requirements of a write-heavy applications serving hundreds of requests per second

NOTE: I am a self-taught PHP developer who has little to none experience managing web and database servers. I am about to write a web-based attendance system for a very large userbase. I expect ...
3
votes
2answers
207 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 ...

15 30 50 per page