I would not recommend delete massive numbers of records in a single sql statement. I have
had problems doing this on a system with few records (1.7 million) and doing a delete with
a condition clause of "where 1 = 1". The server had problems with this.
The MySQL server is probably building some rollback code in case something goes wrong. If
it succeeds it will be a good amount of time. I would recommend doing several small
---- Grant Peel <gpeel@stripped> wrote:
> Hi all,
> I have a table I needed to prune because it had grown to 5 million rows and
> it appeared that that app that uses it couldnt anymore.
> I am in the process of:
> DELETE FROM mytable WHERE id < 3000000;
> the above has been running for close than an hour and I am starting to get a
> little nervous.
> it is on freebsd 6.3, mysql 4.x on a Single core dell 2.8 GHx I think.
> I have shut down all process but necessary one so mysql has full access to
> the cpu.
> Should I be worried? Is there anything I can do to speed this up?
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
|• Help!||Grant Peel||26 Sep|
| • Re: Help!||andrewmchorney||26 Sep|
| • RE: Help!||Martin Gainty||26 Sep|
| • Re: Help!||Ananda Kumar||26 Sep|