.
- 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
Could the problem the Locked data table in this case?
mysql show processlist;
+-+---+---+---+-+---
-+--+---
---+
| Id | User | Host
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;
+-+---+---+---+-
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
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";
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
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
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
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
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
10 matches
Mail list logo