Am I reaching the limits of my droplet?

March 15, 2016 1.3k views
DigitalOcean Networking WordPress MySQL Ubuntu

Hello guys, i currently have a business and we host our client’s websites on a single droplet (2 GB Memory / 40 GB Disk / AMS2) in total we have: 22 domains

16 of them have are active wordpress sites, but these don't give me problems since they are light websites.
Then we have 3 that are prestashops

One of them has 3 products but very many combinations...
One has 100 products and medium combinations
Then there is this last one that has 1900 products (18 mb in the database) (all with images) and some of them have combinations but no to many.

This last one we finished it like half month ago and the server is giving a lot of problems, basically all of a sudden it doesn’t load the websites, chrome stays loading, the fix for this is always restart the droplet but we can’t have this every day since the issue is neglecting our work in this websites...
Also sometimes speed insights shows 5 second of response with the server, what do you guys think, should I move the prestashops to another droplet, individual droplet for every big website, please give me your review of this situation.

Thank you very much.

2 comments
  • Without more information it is difficult to say what issue you're running into. Some additional data that would be helpful in gauging whether this is an issue with a lack of resources would be:

    1. Load - run the command uptime on your droplet. If the value is above 1 x the number of CPU cores you have this could indicate that you need to scale.

    2. Memory use - running the command free -m with your services running will display the available memory on your system. The most common reason for MySQL to crash is running out of memory.

    3. Log files - In /var/log review your MySQL and Apache (or nginx) log files for an indication as to what is occurring when your services crash.

    If you can share these details here I'll be happy to help you interpret them.

  • Thank you for your time here is what i have found:

    LOAD = load average: 3.09, 1.51, 1.21

    MEMORY USE =

    MEM: total = 2002 // used = 1935 // free = 66 // shared = 0 // buffers = 82 // cached = 536.
    -/+ buffers/cache: total = 2002 // used = 1316 // free = 686
    Swap: total = 2810 // used = 1733 // free = 2077

    And about the logs, there are too many files I don't know which of them matter for our situation (could you be more specific?)...

    Can you suggest anything for me with the info above?
    Thank you.

2 Answers

Thank you for your time here is what i have found:

LOAD = load average: 3.09, 1.51, 1.21

MEMORY USE =

MEM: total = 2002 // used = 1935 // free = 66 // shared = 0 // buffers = 82 // cached = 536.
-/+ buffers/cache: total = 2002 // used = 1316 // free = 686
Swap: total = 2810 // used = 1733 // free = 2077

And about the logs, there are too many files I don't know which of them matter for our situation (could you be more specific?)...

Can you suggest anything for me with the info above?
Thank you.

can you send your mysql error log,
you can access it with this command: sudo nano /var/log/mysql/error.log

Have another answer? Share your knowledge.