How to predict a system resource?

Question

Is there any software or a way to predict the need for system resources by accepting several inputs, such as the read / write ratio of MySQL queries, queries executed in the second, properties of tables and databases, and maybe some additional inputs related with PHP configurations, etc.?

Yes. I know that there is probably no perfect solution that software can provide, but I'm not looking for the perfect solution.

Answer 1

A few tools that might come in handy: AWS Cloudwatch, but will only work with EC2. Set an alarm, say, to use the CPU, so the moment you exceed, say, 75%, you will be sent an email with a warning or SMS so that you can look around.

The AWS Elsatic Load Balancer helps you further distribute traffic by freeing up an unhealthy instance and routing traffic to a healthier server.

Some monitoring tools, such as ... missing in the names ... but if you can take care of things using the self-control method, when we use a control panel such as webmin, you can get information about CPU usage, RAM usage, storage, etc.

And finally, just a concept, but a lot will take a lot, and I will follow what was said above, create a mathematical model that can work on cron, so every 5 minutes the observation can be recorded, and the action if necessary.

Answer 2

I would create a mathematical model to calculate the prediction of system resources. I would calculate an empirical estimate of probability density based on Bayesian statistics. More formally, you want to compute something like:

E [Memory | Processor = 0.9, QuerySpeed ​​= 0.6, ...]

You can update the distribution based on new signaling events using the Bayes theorem:

P (A | B) = P (B | A) P (A) / P (B)

This adapts to new empirical data.

Answer 3

Another option is to use a scalable platform such as Amazon Web Services. You can start with a micro-instance and configure load balancing to run more instances as needed.

Once you determine your average resource requirements, you can resize your image to a larger or smaller size depending on your needs.

http://aws.amazon.com http://tuts.pinehead.tv/2011/06/26/creating-an-amazon-ec2-instance-with-linux-lamp-stack/

Answer 4

mysqltuner is based on a perl script ..

I highly recommend you try this ...

download mysqltuner here

http://mysqltuner.pl/mysqltuner.pl 

its command line application and tell us in detail what resources you need for your current application ...