Linked Questions

0
votes
6answers
710 views

Determining MySQL Settings [duplicate]

We are running a server right now and the MySQL database is crashing quite often. We know that we need to find good settings for MaxClients and MaxRequestsPerChild as we are getting lots of traffic ...
0
votes
2answers
851 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
470 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
228 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 ...
0
votes
1answer
129 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
149 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
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, ...
0
votes
0answers
14 views

Conservative Azure Windows VM to Run SQL Server 2008 R2 [duplicate]

For testing purposes I need to set up three Azure Windows VMs to each run an instance of SQL Server 2008 R2 each holding one DB of approx 100GB. There will be quite a few complex stored ...
68
votes
4answers
20k 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 ...
76
votes
2answers
12k 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
5k 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
196 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
336 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 ...

15 30 50 per page