At 12:20 PM 11/21/2007, you wrote:
mos wrote:
Jerry,
Does TRUNCATE work on a merge table?
Apparently not.
I tried:
"truncate table mymergetable" and got:
Error Code : 1
Can't create/write to file '.\dbname\mymergetable.MRG' (Errcode: 17)
I even tried a Flush Tables before the truncate and tha
the merge definition changes, I have to remember to remember to
update the deletes as well.
Mike
- Original Message
From: Chris <[EMAIL PROTECTED]>
To: mos <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Tuesday, November 20, 2007 11:13:58 PM
Subject: Re: Why is
ormation Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
> -Original Message-
> From: mos [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 20, 2007 4:13 PM
> To: mysql@lists.mysq
FROM'
without a WHERE clause to a DELETE FROM on all underlying MyISAM tables.
- Original Message
From: Chris <[EMAIL PROTECTED]>
To: mos <[EMAIL PROTECTED]>
Cc: mysql@lists.mysql.com
Sent: Tuesday, November 20, 2007 11:13:58 PM
Subject: Re: Why is Delete slow on a Merge Table?
mos wrote:
I have a merge table that is a union of 20 1 million row tables. Select
rows from it is quite fast. However if I want to delete all the rows as in:
delete from MyMergeTable;
it takes just over 3 minutes. I could execute 20 separate delete
statements for each of the 20 tables and it
w.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
> -Original Message-
> From: mos [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 20, 2007 4:13 PM
> To: mysql@lists.mysql.com
> Subject: Why is Delete slow on a Merge Table?
>
> I have a merge table that is a union
I have a merge table that is a union of 20 1 million row tables. Select
rows from it is quite fast. However if I want to delete all the rows as in:
delete from MyMergeTable;
it takes just over 3 minutes. I could execute 20 separate delete statements
for each of the 20 tables and it would compl
