mehargags wrote:the mysql cannot be down for just one site, either it stops for all or else I would check some problem with your app.
Are you using cloudflare by any chance ?
XoXiLhJ0mn wrote:Hi JRobinsonOnline,
If you show htop values, when were they captured, during some other time or at the time of crash? At some other time, it is possible that the values were not severely bad for a crash. Check in the mysql log files and see what errors are given at the time of crash or hanging out.
It appears that you have sufficient RAM 3GB. Why do you have swap of 0,5GB? Make it to half of the total physical RAM to 1,5GB. How about tweaking the my.conf. For this Skurudo has given solution in many threads. Have a look. Did you try that?
Regardless of your problem, there may be a different problem on the domain related to crawlers and bots, which may be - in addition to description of your problem above - causing timeouts on that domain.
Did you check from the Vesta log menu for that domain, if bots are attacking your server causing mysql crash? If you do not know how to, let me know. I think the first thing you need to do is check this problem area...
If the bots and crawlers are activating 500 processes, like Majectic crawler regularly does, then it is VERY CLEAR FROM THE SWAP SIZE OF 0,5GB that the mysql server will crash, while nginx remains loaded!
Give in Google "Majestic" and "bad bots crawlers" and help yourself for many strategies to block them.
While using Cloudflare, you could use IP Blocking of bots and crawlers. Mind you, use 188.8.131.52/24, especially use at the end 0/24 to block the entire Octet of 256 IPs, in the Firewall menu of Cloudflare account.
There are sites, which will give you IP lists to block Octets of such bad crawlers and bots. They are OK but the crawlers and bots often change their IPs as they know this method of blocking strategy.
The best is to see in Vesta logs about them and simply add in Firewall of Cloudflare account an entire Octet of their IP.
After doing this, you will see under Traffic menu that there are many hundred blocking of their IPs.
Once you do this exercise for about two to four weeks, then your MySQL Server will cool down and not remain vulnerable to such bad bots and crawlers.
Once you began to apply IP Blocking, do come here and tell everyone here how my solution has finally helped you out.
Users browsing this forum: No registered users and 3 guests