Which size of droplet should i use for my web-site?

January 23, 2014 4.1k views
hakan.snn
By:
hakan.snn
Hello there, I have a question for you, actually i need help. I have a web-site, which had 61.360 unique visitors and 1.307.283 page views in December 2013. For this web-site i have been using second plan of droplet on DigitalOcean which is 1 GB ram/1 cpu. But in january my hits increased %10 rate, so my web-site slowed down little bit. Here is my question, can i solve that problem some server-side coding or do i have to increase/resize my droplet's size. Sorry for bad english, thanks for understanding.
Log In to Comment
5 Answers
cvarda January 23, 2014
I would try first inspect your Droplet's CPU and memory usage. Try using htop - an interactive process viewer for Linux.

So you can find out if you're running out of memory (causing swap) or too much CPU processing (and what is using that resources).

http://hisham.hm/htop/
Reply
hakan.snn January 23, 2014
I run top command from shell. Here's the i got;

[root@s ~]# top
top - 12:45:50 up 1 day, 5:31, 1 user, load average: 5.34, 5.40, 5.58
Mem: 1020388k total, 880792k used, 139596k free, 61336k buffers
Swap: 0k total, 0k used, 0k free, 413648k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
20437 mysql 20 0 1048m 189m 7232 S 73.2 19.1 704:47.40 mysqld
6701 apache 20 0 510m 20m 9236 S 1.3 2.0 0:00.26 httpd
1139 admin 20 0 509m 21m 10m S 1.0 2.1 0:02.30 httpd
4008 apache 20 0 508m 20m 10m S 1.0 2.0 0:01.31 httpd
Reply
kamaln7 MOD January 23, 2014
Looks like there's quite a bit of load on the CPU. Try upgrading to a plan with more CPUs—does that help?
Reply
hakan.snn January 23, 2014
Thank you so much.
Reply
cvarda January 24, 2014
Looks like most of CPU usage is from MySQL. From this point you can consider analyzing which queries are taking too much time to run. Also, you can migrate just MySQL to another, larger server (you will get more CPU cores for the price).
Reply
Have another answer? Share your knowledge.