On Tue, Oct 30, 2001 at 10:50:50AM -0500, C. Williams wrote:
>
> Sorry, semantic miscommunication. It's a heavily used table and the
> performance of other queries done during the mass deletion slows,
> which is a problem since this is a near-realtime system where delays
> in queries cause perform
Sorry, semantic miscommunication. It's a heavily used table and the
performance of other queries done during the mass deletion slows, which
is a problem since this is a near-realtime system where delays in
queries cause performance issues in other dependent modules.
Jeremy Zawodny wrote:
>On
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 takes approximately 45 seconds to delete an hour's wor
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
