From: wangxu Sent: Thu 12/04/2007 08:38
> ----- Original Message -----
> From: "Martijn Tonies" <m.tonies@stripped>
> To: <wangxu@stripped>; <mysql@stripped>
> Sent: Thursday, April 12, 2007 3:17 PM
> Subject: Re: when rebuilding keys?
> >> yes.
> >> >> before load data.
> >> >
> >> > You want to rebuild the indices after loading data,
> >> > correct?
> > Then what exactly is the question?
> > Please write your answer BELOW, not above.
> > Martijn Tonies
> > Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
> > MS SQL Server
> > Upscene Productions
> > http://www.upscene.com
> > My thoughts:
> > http://blog.upscene.com/martijn/
> > Database development questions? Check the forum!
> > http://www.databasedevelopmentforum.com
> sorry ,my english is poor.
> There is a observable event.
> My table's engine is myisam.
> Rows above 1000000 in my table.
> I did "alter table ......disable keys" before loading data.
> I did "alter table ......enable keys" after loading data.
> The operation of enable keys is so fast!
> I am not sure than if the keys have been rebuild.I think the course of
> rebuilding should need very long time.
Try inserting a duplicate value into one of unique columns and see
if you get an error. If you do they are working.
200 GRAY'S INN ROAD
T +44 (0)20 7430 4678
Any views or opinions are solely those of the author and do not necessarily represent
those of Independent Television News Limited unless specifically stated.
This email and any files attached are confidential and intended solely for the use of the
or entity to which they are addressed.
If you have received this email in error, please notify postmaster@stripped
Please note that to ensure regulatory compliance and for the protection of our clients and
we may monitor and read messages sent to and from our systems.