He's dropping the table just prior to running the problematic query,
so I don't think optimizing the destination table will make a
difference. Optimizing the source might speed it up a little, but
he's looking at a difference of 2 minutes to 74 minutes if I'm
understanding correctly when simply
mos wrote:
I have a simple query in MySQL 5.0.24:
insert into table1 (col1) select distinct col1 from bigtable;
that will run for 1:14:18. Both tables are MyISAM and table1 was just
created with 2 columns and is empty.
The select distinct col1 from bigtable takes only 2 minutes to run
Mike, was this a straight software upgrade on the same box? Any
settings changes?
Dan
On 10/6/06, mos [EMAIL PROTECTED] wrote:
I have a simple query in MySQL 5.0.24:
insert into table1 (col1) select distinct col1 from bigtable;
that will run for 1:14:18. Both tables are MyISAM and table1
At 09:37 PM 10/6/2006, Dan Buettner wrote:
Mike, was this a straight software upgrade on the same box? Any
settings changes?
Dan
Hi Dan,
When I installed MySQL 5.0 I used the My.ini for dedicated server
and edited it to use my old settings. I also noticed if I had InnoDb turned
on,