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