Re: How to optimize/index merged tables

2002-07-23 Thread Benjamin Pflugmann
Hi. On Mon 2002-07-08 at 17:49:03 -0700, [EMAIL PROTECTED] wrote: > Hello, > > I have _a lot_ of http log data to throw into a mysql db (currently over 1.5 > billion rows). New data is coming in all the time, so I don't want to lock > myself into one set of big tables that are over 100 gigs eac

How to optimize/index merged tables

2002-07-08 Thread Brad Ford
Hello, I have _a lot_ of http log data to throw into a mysql db (currently over 1.5 billion rows). New data is coming in all the time, so I don't want to lock myself into one set of big tables that are over 100 gigs each. I'd rather arrange this data into smaller chunks, then merge the tables t