billcbos Posted July 19, 2011 Posted July 19, 2011 according to a monitoring tool, there are two database queries that are causing an excessive amount of activity on my site. According to the report there is an average of over 70,000 queries. Since I am averaging 200-300 visitors per day so I am really confused about how this many queries are occuring. The queries are: 1) select configuration_key as cfgkey, configuration_value as cfgvalue from configuration 2) select languages_id, name, code, image, directory from languages order by sort_order Can anyone explain this and is there anything I can do about it. My host is threatening to close my account because of the excessive activity saying it is impacting others on the shared server. Bill C
billcbos Posted July 19, 2011 Author Posted July 19, 2011 according to a monitoring tool, there are two database queries that are causing an excessive amount of activity on my site. According to the report there is an average of over 70,000 queries. Since I am averaging 200-300 visitors per day so I am really confused about how this many queries are occuring. The queries are: 1) select configuration_key as cfgkey, configuration_value as cfgvalue from configuration 2) select languages_id, name, code, image, directory from languages order by sort_order Can anyone explain this and is there anything I can do about it. My host is threatening to close my account because of the excessive activity saying it is impacting others on the shared server. Bill C I THINK, this might be a denial of service type of attack - I check the who's online tool and there have been a consistent 25 online users all from the same ip address (first three numbers are the same). checking online they trace back to a company in Japan. CAN I KICK USERS OFF THE SITE? Of block a certain IP address? Any insight would help. Thanks.
Guest Posted July 19, 2011 Posted July 19, 2011 Bill, You can deny them access to your site via .htaccess Enter this into your .htaccess in the store directory <Limit GET PUT POST> order allow,deny deny from 62.29.0.0 deny from 62.56.128.0 allow from all </Limit> Ofcourse, you would enter the offending IP address in place of the examples shown. Chris
billcbos Posted July 20, 2011 Author Posted July 20, 2011 Bill, You can deny them access to your site via .htaccess Enter this into your .htaccess in the store directory <Limit GET PUT POST> order allow,deny deny from 62.29.0.0 deny from 62.56.128.0 allow from all </Limit> Ofcourse, you would enter the offending IP address in place of the examples shown. Chris Chris, Thanks - I realized I should do that after I posted but it was a helpful post. I have yet to hear back from my host but the whose online now is down to the typical count and no repeat ip's so I'm hoping the excessive queries issue will be resolved. Be well Bill C
billcbos Posted July 20, 2011 Author Posted July 20, 2011 Chris, Thanks - I realized I should do that after I posted but it was a helpful post. I have yet to hear back from my host but the whose online now is down to the typical count and no repeat ip's so I'm hoping the excessive queries issue will be resolved. Be well Bill C For anyone following these festivities, it appears that the excessive queries issue is now resolved. I was apparently under attach - well the site was - in some poor excuse for a denial of service??? Thank you Chris for the input and to all a good night. Be well.
NodsDorf Posted July 20, 2011 Posted July 20, 2011 DoS attacks usually include multiple IP's and hackers typically have no shortage of them. I'd continue to monitor it either way. I've blocked literally hundreds of IPs over the years.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.