Configuration : How to clean your events database : Comments

RE: How to clean your events database

community@zenoss.org — Mon, 07 Dec 2009 12:10:15 GMT

Perfect, I'm trying this out now.
Thanks!

RE: How to clean your events database

community@zenoss.org — Fri, 11 Dec 2009 10:11:02 GMT

For me this wasn't enough: even though i told zenoss to prune events older then 40 days, it seems to not work.

so based on http://www.mail-archive.com/zenoss-users@zenoss.org/msg31456.html //www.mail-archive.com/zenoss-users@zenoss.org/msg31456.html

i also put the following in my zenoss crontab:

echo "DELETE FROM history WHERE lastTime < UNIX_TIMESTAMP(DATE_SUB(NOW(), INTERVAL 40 DAY));" | mysql -uzenoss -pzenoss events

the query is still running but i expect it will give me more free diskspace (at least, when innodb's auto vacuuming kicks in)

RE: How to clean your events database

community@zenoss.org — Mon, 14 Dec 2009 10:01:26 GMT

hmm.. i'm not getting my diskspace back.

Even doing a 'ALTER TABLE <name> TYPE=InnoDB' on all innodb tables didn't help.. (this should make innodb delete it's still data)

RE: How to clean your events database

community@zenoss.org — Mon, 14 Dec 2009 14:01:27 GMT

I finally got the diskspace back by doing a database backup, removing the data, and importing the backup again.

see http://crazytoon.com/2007/04/03/mysql-ibdata-files-do-not-shrink-on-database-deletion-innodb/

RE: How to clean your events database

community@zenoss.org — Sun, 03 Jan 2010 15:34:30 GMT

Innodb data bases do not shrink. That is a major glitch in that datatype in my view. So it clears space for new records but the only way to reclaim space is to export and then reinport the data.

Thanks

Robert