Hi Andrey,
-
Thanks for the response.
-
Here is what my host said about the MySQL issue...Any more thoughts on this? Since it appears to be somewhat related to the spy on homepage...perhaps Chris (topher) can chime in on this one also.
-
~~ Lorren
-
When services begin to go down on servers, such as MySQL, it is usually due to
high resource usage. I've looked at your account's resource usage over the last
several days and have found several errors related to your memory usage. Your
apache log files indicate that most of the errors were given when the following
page was accessed:
/home/lrepton2/public_html/community/cc_forum_spy.php
I don't however see this as a constant memory usage, but rather quick
and large spikes. High memory usage is most often attached to heavily php and
MySQL driven sections of your website, such as a blog or a forum. If you have a
large forum for example, you may have been crawled by a search engine. When this
happens, the search engine is requesting 100's of pages in your account in a
small amount of time. If you are getting spidered by search engines there is a
simple fix that can be applied. The fix would entail you placing a file called
"robots.txt" in your home directory, this file would tell
certain(or all)
search engines to disregard your site or certain directories. Usually you can
get by with only excluding galleries or forums. For more information on this you
can look over the following information.
Link: http://www.robotstxt.org/
You can decrease count of connections to your SQL ..
for example try to begin remove blocks from index page .. that can show any statistic .. ,aybe here something unnecessary
Just make your pages more light and faster