Υπάρχει τρόπος μέσω htaccess να επιλέξω εγω ποιες χώρες θα έχουν πρόσβαση στο κανάλι μου?
Έστειλα και στον host μηνυμα και μου απαντησαν το παρακάτω. Επειδή ΔΕΝ ξέρω καλά αγγλικά, μπορείτε να με βοηθήσετε σχετικά με το τι πρέπει να κάνω?
Το μηνυμά τους
The issue at hand is due to bots accessing your website slow MySQL queries being executed on your database at the same time. This leads to high load on your Cloud Server which then renders your website inaccessible in order to bring the load down.
To resolve this issue you should address the slow MySQL queries by optimizing your website's database, and implement additional directives in your .htaccess file(s) in order to restrict bots from accessing your website.
Regarding your database - you should optimize the database in order to fix the slow queries issue. In order to optimize your database, you could follow the steps in this article. I have provided you with the mysql-slow.log in:
Κώδικας: Επιλογή όλων
You could also consider contacting an experienced third party MySQL developer to optimize your database for you. I cannot recommend anyone in particular, however you should be able to find one at the popular freelancer websites.
Regarding your website's traffic issues - you should follow the steps in this article in order to restrict bad bots from accessing your website and generating unnecessary executions. You could also use the directives from this sample .htaccess file in order to update your own .htaccess file.
I also noticed that your website is being accessed excessively by GoogleBot. You could decrease GoogleBot's crawl rate by logging into your Google Webmasters account or by placing a robots.txt file in your website's document root. You could also disable indexing entirely by following the steps in the article above.
I would also recommend that you analyze the statistics provided by the AWStats tool in cPanel and check the IP addresses which have accessed your website the most. If you do not recognize those IP addresses, you could consider blocking them via the IP Deny Manager in cPanel.
If you need any further assistance, please do not hesitate to contact us again!
Technical Support Team