Reducing Visitors From Other Countries To Lower Cpu Load

Store Builder Questions
1

I am running the latest version of cs-cart and have a Emergo theme installed on my UK website. My main issue is my current hosting has exceeded the 5% shared hosting allowance.

I have approx. 200 visitors per day to my website however 100 seem to be from Russia where I do not ship or intend to sell too. How can I block these visitors or find out if something else is causing the visitors like a bot?

Also checking my error log I have found this:

mod_fcgid: stderr: PHP Warning: mysqli::query(): MySQL server has gone away in /home/www/MYWEBSITE.co.uk/app/Tygh/Backend/Database/Mysqli.php on line 76

Would fixing this error save some useage? I have not optimised my website in anyway.

2

You can ask your hosting provider to block unwanted counties for your account.

Or use Cloudflare and block unwanted countries from their firewall.

That error says a myqsl server crash, you shouldn't do any fix from cs-cart, is a server side issue.

Probably the server is overloaded (and overselled) and crashed. 200 visitors isn't the number where a server should crash...

3

I added the list of Russian IP's from http://www.blockcountryip.com/

Hopefully i will see a reduction.

My hoster advised to use cache compression. Is this already in cs-cart by default?