Linked Questions

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 ...

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 ...

we have a dedicated server hosting 1 website on it uses WordPress, CPU: Intel® Xeon® W-2145 Octa-Core (8-core) RAM: 128 GB DDR4 ECC RAM Connection: 1 Gbit/s-Port Traffic: Unlimited OS: CENTOS 7.6 WHM/...

First of all, Apologies if this is a silly question. I've never really had to manage servers and databases, on a "large-scale", that is. ANYWAY, on to the question. I am trying to figure out if our ...

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 is ...

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 ...

I have a Laravel PHP webapp that shows analytics data in Angular frontend to users. User can only show content, plots and tables. I have written 3 laravel commands that hourly download and store data ...

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 ...

We have an e-commerce system which is currently deployed in EC2 instance. currently MySQL is in the same server and now that we are getting high traffic now and then, we're planning to use Autoscaling ...

I have a raspberry pi 3 webserver. When user gets into my app. App is sending a post request to my server every second to check if there are any messages for user. The query is simple: SELECT ...

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 procedures/...

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, all the ...

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 ...

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 databases? What are some ...

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 databases? I have a ...