Hostgator aşağıdaki maili göndermiş. Anladığım kadarıyla seo.php aşırı sorgu yapıyormuş buda diğer siteleri etkilemiş. Bu problemi nasıl düzeltebilirim?
Unfortunately, we were forced to disable the scripts under "/home/uveyik/public_html/seo.php" as they were causing a high load on the server, and due to this affecting all of the other accounts on the system, we were forced to take immediate action for the health of the server.
Chiefly the MySQL queries that were being made are a problem. Each time they run, several thousand rows are returned at random, which can take quite some time when several of them are being made at once. You can see some examples of why this is this sort of query can cause issues as more and more rows are added, as well as some possible changes that can be made here (
http://www.phpbuilder.com/board/show...php?t=10338930). You will need to make some modifications to this query, or consider caching this query for some time, and then getting a different random result after that time has passed. Likely the original author would be able to assist you with making such a change.
If you reply back to this with your IP address (
http://www.hostgator.com/ip.shtml) we will be more than happy to go ahead enable HTTP access for you, so that you can safely work on the script without it causing further issues. Please let us know how you would like to proceed.