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!
how to control page views
- jmestep
- AbleCommerce Angel
- Posts: 8164
- Joined: Sun Feb 29, 2004 8:04 pm
- Location: Dayton, OH
- Contact:
Re: how to control page views
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.
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
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
Re: how to control page views
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.
Re: how to control page views
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
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
http://help.ablecommerce.com - product support
http://wiki.ablecommerce.com - developer support
Re: how to control page views
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
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36