I've got 200,000 Information Events to clear out - Is there a backdoor method?

[mlavelle42]

The communications network we're gathering data on periodically burps causing a raft of events to occur. It got away from me and now there are so many the frontend doesn't display the events page. Is there a backdoor method for removing events?

[phildunlap]

Hi mlavelle42,

So Mango is still loading other pages? I would navigate to the Purge Settings section of either system settings page, where you will find a "Purge all events" button. Alternatively you can run,

delete from audit;
delete from userEvents;
delete from events;

on the /sqlConsole.shtm page, or you can access your DB's shell directly and do it there (on MySQL, on H2 you would have to stop Mango, then access the DB using the Mango/bin/h2-web-console.sh script)

[phildunlap]

Or, if you only want to delete information events, you could set the purge period for those events in the purge settings to be very short and then "Purge now using purge settings" will clear that, or you can wait for the nightly purge to take care of it.