2 items I would increase bump key_buffer_size as suggested here http://dev.mysql.com/doc/refman/5.1/en/delete-speed.html
also TRUNCATE instead of DELETE where TRANSACTION is not active Martin ______________________________________________ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. > Date: Thu, 25 Sep 2008 15:45:00 -0700 > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED]; mysql@lists.mysql.com > Subject: Re: Help! > > 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 <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > _________________________________________________________________ See how Windows connects the people, information, and fun that are part of your life. http://clk.atdmt.com/MRT/go/msnnkwxp1020093175mrt/direct/01/
