Daevid Vincent Help with purging old logs for each customer ID
Oct 25, 2012; 11:46
Daevid Vincent
Help with purging old logs for each customer ID
I have a customer log table that is starting to rapidly fill up (we have hundreds of thousands of users, but many are transient, and use the service for a few months, or use the free trial and quit, etc.)
What I'd like to do now is make a 'rolling log' in that I want to DELETE any entries older than 90 days for EACH `customer_id`.
I'm not sure how to do that in a query? I'd rather not iterate over each customer_id if I can help it.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Oct 25
Rick James RE: Help with purging old logs for each customer ID
Oct 25, 2012; 13:09
Rick James
RE: Help with purging old logs for each customer ID
Oct 25
Daevid Vincent RE: Help with purging old logs for each customer ID
Oct 25, 2012; 13:32
Daevid Vincent
RE: Help with purging old logs for each customer ID
Oct 25
Rick James RE: Help with purging old logs for each customer ID
Oct 25, 2012; 13:54
Rick James
RE: Help with purging old logs for each customer ID
Oct 25
Daevid Vincent RE: Help with purging old logs for each customer ID
Oct 25, 2012; 16:15
Daevid Vincent
RE: Help with purging old logs for each customer ID
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!