[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: Help!
From:       <andrewmchorney () cox ! net>
Date:       2008-09-25 22:45:00
Message-ID: 20080925184500.YSQ75.594296.imail () fed1rmwml30
[Download RAW message or body]

Hello

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

Andrew



---- Grant Peel <gpeel@ody.ca> 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?
> 
> -G
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=andrewmchorney@cox.net
> 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql-marcsub@progressive-comp.com



[prev in list] [next in list] [prev in thread] [next in thread]