--0016362849be4726f304841a6014
Content-Type: text/plain; charset=ISO-8859-1
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
--0016362849be4726f304841a6014--
--=====003_Dragon320125853876_=====
Content-Type: text/plain;
charset="utf-8"
Content-Transfer-Encoding: base64
T1BUSU1JWkUgVEFCTEUgdGFibGVuYW1lOw0KYW5hbHl6ZSB0YWJsZSAgLHN0 b3JlcyB0aGUga2V5
IGRpc3RyaWJ1dGlvbiBmb3IgYSB0YWJsZSAscmVjbGFpbSB0aGUgdW51c2Vk IHNwYWNlIGFuZCB0
byBkZWZyYWdtZW50IHRoZSBkYXRhIGZpbGUuDQoNCkFOQUxZWkUgVEFCTEUg dGFibGVuYW1lOw0K
VGhpcyBhY3Rpb24gb25seSBhbmFseXplIHRhYmxlIGFuZCBzdG9yZXMgdGhl IGtleSBkaXN0cmli
dXRpb24gZm9yIGEgdGFibGUuDQoNCjIwMTAtMDQtMTMgDQoNCg0KDQpSaXZl ciB3dWJ4ICANCkd0
YWxrOiB3dWJpbmd4aUBnbWFpbC5jb20NCmh0dHA6Ly93d3cubXlzcWxzdXBw b3J0LmNuIA0KQ2hp
bmENCg0KDQoNCuWPkeS7tuS6uu+8miBGLkEuSS5aLkEuTCANCuWPkemAgeaX tumXtO+8miAyMDEw
LTA0LTEzICAxNjo1MjoyOCANCuaUtuS7tuS6uu+8miBteXNxbDsgbXlzcWwt aGVscCANCuaKhOmA
ge+8miANCuS4u+mimO+8miBkaWZmZXJlbmNlIGJ0dyBBbmFseXplIGFuZCBP cHRpbWl6ZSB0YWJs
ZS4uIA0KIA0KaGkgYWxsDQp3aGF0IGlzIHRoZSBkaWZmZXJlbmNlIGJldHdl ZW4NCk9QVElNSVpF
IFRBQkxFIHRhYmxlbmFtZTsNCmFuZA0KQU5BTFlaRSBUQUJMRSB0YWJsZW5h bWU7DQp0aGFuayB5
b3UNCkNoZWVycw0KRmFpemFsIFMNCkdTTSA6IDk4NDAxMTg2NzMNCkJsb2c6 IGh0dHA6Ly9vcmFk
YmFwcm8uYmxvZ3Nwb3QuY29tDQo=
--=====003_Dragon320125853876_=====--
--0016361e882a3b2d8e04841b4680
Content-Type: text/plain; charset=GB2312
Content-Transfer-Encoding: quoted-printable
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
> OPTIMIZE TABLE tablename;
> analyze table ,stores the key distribution for a table ,reclaim the unus=
ed
> space and to defragment the data file.
>
> ANALYZE TABLE tablename;
> This action only analyze table and stores the key distribution for a tabl=
e.
>
> 2010-04-13
> ------------------------------
> River wubx
> Gtalk: wubingxi@gmail.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
> Blog: http://oradbapro.blogspot.com
>
--0016361e882a3b2d8e04841b4680--
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@gmail.com]=20
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
> 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@gmail.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
> Blog: http://oradbapro.blogspot.com
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg
--000e0cd32da4f6f8350484221b68
Content-Type: text/plain; charset=ISO-8859-1
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
> 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
--000e0cd32da4f6f8350484221b68--
--0016e64643300abe1c0484415b0a
Content-Type: text/plain; charset=ISO-8859-1
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
> 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
>
>> 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
>
--0016e64643300abe1c0484415b0a--