SQLRelay

2002-04-26 Thread C. Williams
Anyone know/using SQLRelay w/ MySQL? Any gotchas or wierdness in MT apps using SQLRelay? Sorry for the blast, didn't find alot in the deja archives. TIA, Chris - Before posting, please check: http://www.mysql.com/manual.ph

Index Cleanup

2001-11-28 Thread C. Williams
Just wondering, say I have a couple of indexes on a table that grows linearly over a month. I have a script working in the background that archives anything in that table older than a month, so I effectively have a moving 1 month window of data. Does MySQL cleanup the index records accordingly

Re: Delete performance

2001-10-30 Thread C. Williams
>On Mon, Oct 29, 2001 at 05:49:57PM -0500, C. Williams wrote: > >>Does anyone know how to speed the performance of deletes on a large >>table? I have a large table w/ approx. 180,000,000 rows, with the >>following table structure: >> > >[snip] > >>It

Delete performance

2001-10-29 Thread C. Williams
Does anyone know how to speed the performance of deletes on a large table? I have a large table w/ approx. 180,000,000 rows, with the following table structure: mysql> desc TABLEA; |+--+---+--+-+--+---+| Field | Type