0
votes
6answers
713 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
965 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 ...
-1
votes
1answer
887 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
523 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
151 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
156 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 ...
0
votes
0answers
10 views

MySQL 5.5 performance settings [duplicate]

We are using server this theses parameters: 8 cores CPU 18GB RAM MySQL version 5.5 We would like to get the best performance. The DB is InnoDB type. I would like to know your experience and maybe you ...
0
votes
0answers
9 views

AWS which MS SQL server EC2 type should be used for MS Navision ERP backend database [duplicate]

I am trying to host Microsoft Navision ERP on AWS Cloud, currently it is on local data center. The licensing is based on number of cores with unlimited users. Which type of EC2 instance should be ...
0
votes
0answers
7 views

MySQL Config for 8gb Ram 4 cores Server [duplicate]

I am new to servers and I need to deploy an app. However, I don't have that much background with the needed configurations. I would like to know the advisable mysql config for server with 8 gb ram and ...
78
votes
4answers
26k 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 ...
85
votes
2answers
15k 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
6k 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 ...

15 30 50 per page