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
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