We just had this question come up regarding the labs, but it applies to 
production as well.

I'm thinking that we need to implement some sort of periodic database pruning. 
Perhaps like every two months or so, go through all databases, all tables, and 
do like

delete from FOO where deleted=1 and deleted_at < date_sub(now(), interval 2 
month)

Just as an example.

Does anyone have see any issues with purging deleted=1 data?
I've seen this be very helpful for things like Keystone tokens, etc.

Attachment: signature.asc
Description: Message signed with OpenPGP using GPGMail

_______________________________________________
OpenStack-operators mailing list
OpenStack-operators@lists.openstack.org
http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack-operators

Reply via email to