thanks to you and everyone involved in this mail thread..
after optimize the table. i can see huge performance improvement..
thanks again..
Cheers
Faizal S
GSM : 9840118673
Blog: http://oradbapro.blogspot.com
On Tue, Apr 13, 2010 at 11:35 PM, Suresh Kuna wrote:
> Analyze table :
>
> Analyze t
Analyze table :
Analyze table analyzes and stores the key distribution for a table.
For more details check the below URL
http://dev.mysql.com/doc/refman/5.1/en/analyze-table.html
Optimize table :
OPTIMIZE TABLE is useful when we do more deleted operations on a table with
variable columns. It w
; 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
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
>
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
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