AbleCommerce Shopping Cart Software

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!

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.

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.

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

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