how to control page views

For general questions and discussions specific to the AbleCommerce GOLD ASP.Net shopping cart software.
Post Reply
fiddycent
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 45
Joined: Tue Sep 03, 2013 12:30 pm

how to control page views

Post by fiddycent » Wed Apr 04, 2018 9:51 am

Website has been up for some time and working out ok. However it went down recently, due to file size growing significantly. The root cause is the ac_pageviews table has 21 million rows over the last two months. We don't get but a handful of actual customers per day so it must be bots? I truncated the table and it's back up and running now.

How do I prevent this from happening again? I had set the page tracking to maintain history for only 7 days, so I'm not sure why there was data from 2 months ago in the table, unless this is the wrong setting I'm using. I can also just turn off the tracking as a worst case scenario. I'm not sure what kind of bot this is - the user agent for the majority of the rows I deleted was 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36''

Appreciate any advice or tips to prevent this. Thanks!

User avatar
jmestep
AbleCommerce Angel
Posts: 8164
Joined: Sun Feb 29, 2004 8:04 pm
Location: Dayton, OH
Contact:

Re: how to control page views

Post by jmestep » Sun Apr 08, 2018 9:56 pm

That should be the right setting for maintaining page views. Are there any entries in your App_Data/Logs/app.log file to indicate that maintenance didn't complete correctly? There should be some entries like the following to indicate the maintenance:
Page view maintenance cleared xx expired records.
Last edited by jmestep on Mon Apr 09, 2018 10:29 pm, edited 1 time in total.
Judy Estep
Web Developer
jestep@web2market.com
http://www.web2market.com
708-653-3100 x209
New search report plugin for business intelligence:
http://www.web2market.com/Search-Report ... -P154.aspx

fiddycent
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 45
Joined: Tue Sep 03, 2013 12:30 pm

Re: how to control page views

Post by fiddycent » Mon Apr 09, 2018 1:10 am

Nothing in the log files except for out of memory issues due to the files growing so large. Another 600k entries in my page views table and 20k anonymous users over the last 3 days. I guess I need to turn off page tracking, this is getting ridiculous.

User avatar
Katie
AbleCommerce Admin
AbleCommerce Admin
Posts: 2651
Joined: Tue Dec 02, 2003 1:54 am
Contact:

Re: how to control page views

Post by Katie » Mon Apr 09, 2018 4:57 am

Here is a link to a prior discussion about rogue bots.

viewtopic.php?f=65&t=18610&start=0&hilit=rogue+bot

There might be some helpful information.

Thanks
Katie
Thank you for choosing AbleCommerce!

http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support

fiddycent
Lieutenant, Jr. Grade (LT JG)
Lieutenant, Jr. Grade (LT JG)
Posts: 45
Joined: Tue Sep 03, 2013 12:30 pm

Re: how to control page views

Post by fiddycent » Mon Apr 09, 2018 6:07 am

Yes I had asked some questions a few years ago on that thread, I will take a look again. The IP addresses are coming mainly from US addresses, so I think geoIP filters would not help. The user agent is the only thing that remains the same and it doesn't have a bot name in it, but I guess that's why it's called a rogue bot -

Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36

Post Reply