, 2012 1:54 PM
> To: Daevid Vincent; mysql@lists.mysql.com
> Subject: RE: Help with purging old logs for each customer ID
>
> If the 90 days is back from MAX(created_on) for a given customer...
>INDEX(customer_id, created_on)
> will probably be needed. And that should repla
.@daevid.com]
> Sent: Thursday, October 25, 2012 1:33 PM
> To: Rick James; mysql@lists.mysql.com
> Subject: RE: Help with purging old logs for each customer ID
>
> Well, the customer_id is relevant in that I want the last 90 days
> relative to each customer.
>
> customer_id
Original Message-
> From: Rick James [mailto:rja...@yahoo-inc.com]
> Sent: Thursday, October 25, 2012 1:09 PM
> To: Daevid Vincent; mysql@lists.mysql.com
> Subject: RE: Help with purging old logs for each customer ID
>
> Off hand, I would iterate over the PRIMARY KEY, looking
y, October 25, 2012 11:46 AM
> To: mysql@lists.mysql.com
> Subject: 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 f
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.)
CREATE TABLE `customers_log` (
`customer_log_id` bigint(20) unsigned NOT NULL auto_incremen
