Re: How does one speed up delete-Again

2006-07-10 Thread Brent Baisley
. - Original Message - From: Jacob, Raymond A Jr [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Sunday, July 09, 2006 10:36 PM Subject: How does one speed up delete-Again I started the operation below on Friday at 1300hrs EST DELETE data FROM data, event WHERE data.cid = event.cid

Re: How does one speed up delete-Again

2006-07-10 Thread Jacob, Raymond A Jr
Could the problem the Locked data table in this case? mysql show processlist; +-+---+---+---+-+--- -+--+--- ---+ | Id | User | Host

Re: How does one speed up delete-Again

2006-07-10 Thread Jacob, Raymond A Jr
It appears that every time I start query the event or the data table gets Locked. Could this have any affect on why it takes so long to delete records. Grasping at straws, Thank you, Raymond mysql show processlist; +-+---+---+---+-

How does one speed up delete-Again

2006-07-09 Thread Jacob, Raymond A Jr
I started the operation below on Friday at 1300hrs EST DELETE data FROM data, event WHERE data.cid = event.cid AND event.timestamp 2006-05-01 It is now Sunday 22:00hrs EST and the operation is still running. Question: Should it take this long to delete 7.5 million records from a 4.5GB

Re: Delete Again?

2001-03-30 Thread Basil Hussain
Hi, This is my full code $www_domain="select Failed_Signups.EmailAddress.Email from Failed_Signups.EmailAddress left join www_domain_net.Members on Failed_Signups.EmailAddress.Email=www_domain_net.Members.EmailAddress where www_domain_net.Members.EmailAddress is null";

Delete Again?

2001-03-29 Thread KPortsmout
Hmmm Well I didn`t manage to get any of those examples to work. This is my select statement.. "select Failed_Signups.EmailAddress.Email from Failed_Signups.EmailAddress left join www_domain_net.Members on Failed_Signups.EmailAddress.Email=www_domain_net.Members.EmailAddress where

Re: Delete Again?

2001-03-29 Thread Rolf Hopkins
What doesn't work and where is your delete statement? - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, March 30, 2001 11:35 Subject: Delete Again? Hmmm Well I didn`t manage to get any of those examples to work

RE: Delete Again?

2001-03-29 Thread Quentin Bennett
Hi, No. you can't delete based on a join. Regards Quentin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, 30 March 2001 3:35 p.m. To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Delete Again? Hmmm Well I didn`t manage to get

Re: Delete Again?

2001-03-29 Thread KPortsmout
In a message dated 30/03/2001 04:42:44 GMT Daylight Time, [EMAIL PROTECTED] writes: What doesn't work and where is your delete statement? This is my full code $www_domain="select Failed_Signups.EmailAddress.Email from Failed_Signups.EmailAddress left join www_domain_net.Members on

Re: Delete Again?

2001-03-29 Thread Rolf Hopkins
Subject: Re: Delete Again? In a message dated 30/03/2001 04:42:44 GMT Daylight Time, [EMAIL PROTECTED] writes: What doesn't work and where is your delete statement? This is my full code $www_domain="select Failed_Signups.EmailAddress.Email from Failed_Signups.EmailAddress left