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
>
