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
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
GS
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: wubin...@gmail.com