Thread

Is there a way to cut down the ever growing datatable exp_throttle?

http://ellislab.com/forums/viewthread/188595/

franxx, a quick look at the source code says this should take care of itself, clearing the database of old entries every 7 days (or soonest after 7 days when someone looks at a page).

However, the conditions for clearing to occur include;
- you must have Enable Online User Tracking set, in Admin>Security and Privacy>Tracking Preferences
AND
- you must actually have throttling turned on, via Admin>Security and Privacy>Throttling Preferences>Enable Throttling

In other words, it’s going to clear, and once a week (date/time not determined easily), only if you actually have throttling and user tracking both enabled.

That’s what the code seems to say. Also, I note there was an item on today’s 2.1.5 release document that something had been fixed in this area. On an older 2.x site where I know I’ve hit throttling because of testing, the log is nearly empty (2 items), and both the settings mentioned are on, so I think the clearing does work.

Answering on this only because I know others who would know better are busy with the release. You can try these settings, and see if your database shrinks properly in a week or so, for now.

Good fortune on it, and regards,
Clive

Thanks Clive. Can you try those settings and let us know if the throttling table clears for you in time.
I’ll leave this thread open in the meantime.

Thank you Clive.

Admin>Security and Privacy>Tracking Preferences enabled
plus
Admin>Security and Privacy>Throttling Preferences>Enable Throttling

did the job. exp_throttle has now only 400kb.

Excellent! Feel free to start a new thread if you have any more questions.