Large database - events table. How to find cause?

danodemano · January 29, 2018, 10:59pm

Hey all,

I have my “purge_keep_days” at 2. However my database is now over 11GB in size with nearly all of that in the “events” table. How can I best figure out what is flooding the database and correct it?

Thanks,
Dan

VDRainer · January 29, 2018, 11:48pm

Are you at the latest release?
There was an issue in 0.61.1 that is fixed.

danodemano · January 29, 2018, 11:49pm

Yes, I’m on 0.62

TBH there wasn’t anything important in there anyway since I pipe everything to InfluxDB for long-term storage. I just nuked the database, we’ll see if the problem resurfaces.

danodemano · February 6, 2018, 1:51pm

Nuking the database appears to have resolved the issue. Not sure if it was residual to the bug in 0.61.1 or not but my database has been between 2 and 3 GB since last week.