Re: Deleting rows from logging db efficiently

2002-03-04 Thread Jeremy Zawodny
On Mon, Mar 04, 2002 at 02:06:00PM -0700, Lopez David E-r9374c wrote: > Using MySQL 3.23.40 > > App is logging db with 130 clients to a central MySQL db with 2 > million events per day. Aged events of over 7 days are no longer > required. The central table is myisam type with fixed size > (dateti

Deleting rows from logging db efficiently

2002-03-04 Thread Lopez David E-r9374c
Using MySQL 3.23.40 App is logging db with 130 clients to a central MySQL db with 2 million events per day. Aged events of over 7 days are no longer required. The central table is myisam type with fixed size (datetime, enum and foreign keys only). Selects are done infrequently while inserts are