New answers tagged

0

thanks, changing myisam tables to innodb solved the problem, now mysql CPU is at most 300% and normal load average peak 5%


2

There are several options: use a script which writes needed data on a regular basis to a logfile. You could use cron to write the output of ps (and other commands) every x minutes into a logfile. Better it would be to use a specialized program, which does this for you. atop is very good at this, at it takes care of logfile retention. atop is available ...


1

I don't think faster processors make more than 10 - 20% real world performance. My suggestions: Optimisation of the code probably makes most sense. This may need a developer, who can reduce database calls, reduce general work done, or simply optimise it. Putting in a page cache, unless the page is customised for each user. Nginx is great for this, and it ...


2

I have an Amazon Linux server (no GUI), which is somewhat similar to Ubuntu, but not the same. The CPU utilization when the server isn't serving requests is around 0.03%, and I get to maximum CPU credit fairly quickly. Eight t2.micro instances comes to $86/month, one m4.2xl is $350 a month. If you go with the t2 instances you also need a load balancer, ...



Top 50 recent answers are included