http://dev.mysql.com/doc/refman/5.0/en/optimize-table.html
The entire page is highly recommended due to the number of helpful
information.
Regards,
m
-----Original Message-----
From: F.A.I.Z.A.L [mailto:sac.faizal@stripped]
Sent: Tuesday, April 13, 2010 10:56 AM
To: River wubx
Cc: mysql; mysql-help
Subject: Re: difference btw Analyze and Optimize table..
hi River
thanks for your mail.
could you please tel me the correct syntax for optimize table command. i
plan to put this in cronjob and execute every 8 hours in a day.
optimize table tab1; is that correct or anything need to add with his
statement.
my environment is solaria
Cheers
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
On Tue, Apr 13, 2010 at 2:37 PM, River wubx <cnwubx@stripped> wrote:
> OPTIMIZE TABLE tablename;
> analyze table ,stores the key distribution for a table ,reclaim the
unused
> space and to defragment the data file.
>
> ANALYZE TABLE tablename;
> This action only analyze table and stores the key distribution for a
table.
>
> 2010-04-13
> ------------------------------
> River wubx
> Gtalk: wubingxi@stripped
> http://www.mysqlsupport.cn
> China
> ------------------------------
> *发件人：* F.A.I.Z.A.L
> *发送时间：* 2010-04-13 16:52:28
> *收件人：* mysql; mysql-help
> *抄送：*
> *主题：* difference btw Analyze and Optimize table..
> hi all
> what is the difference between
> OPTIMIZE TABLE tablename;
> and
> ANALYZE TABLE tablename;
> thank you
> Cheers
> Faizal S
> GSM : 9840118673
> Blog: http://oradbapro.blogspot.com
>
