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 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 worth of data( >>90323 rows) from the table, which tends to be a performance problem >>since it's a table with a fair amount of contention. >> >>Platform: x86 >>OS: RH Linux 2.4.6 >>MySQL V: 3.23.42-max >>DB File Type: InnoDB >>Memory: 1 GB >>HD: 130GB SCSI >> > >If you're using InnoDB, where's the contention? > >Jeremy > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
