List:General Discussion« Previous MessageNext Message »
From:F.A.I.Z.A.L Date:April 15 2010 7:21am
Subject:Re: difference btw Analyze and Optimize table..
View as plain text  
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 <sureshkumarilu@stripped>wrote:

> 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 will do the defragmentation of the data file and
> recliam the space. It sorts the indexes and updates the table statistics if
> it is not. However, the new inserts will reuse the deleted row space.
>
> For more details check the below URL
> http://dev.mysql.com/doc/refman/5.1/en/optimize-table.html
>
>
> On Tue, Apr 13, 2010 at 2:21 PM, F.A.I.Z.A.L <sac.faizal@stripped> wrote:
>
>> 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
>>
>
>
>
> --
> Thanks
> Suresh Kuna
> MySQL DBA
>

Thread
difference btw Analyze and Optimize table..F.A.I.Z.A.L13 Apr
  • Re: difference btw Analyze and Optimize table..River wubx13 Apr
    • Re: difference btw Analyze and Optimize table..F.A.I.Z.A.L13 Apr
      • RE: difference btw Analyze and Optimize table..misiaQ13 Apr
  • Re: difference btw Analyze and Optimize table..Suresh Kuna13 Apr
    • Re: difference btw Analyze and Optimize table..F.A.I.Z.A.L15 Apr