Re: difference btw Analyze and Optimize table..
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 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 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 >
Re: difference btw Analyze and Optimize table..
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 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
RE: difference btw Analyze and Optimize table..
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.fai...@gmail.com] 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 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: wubin...@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=arch...@jab.org
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 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: wubin...@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 >
Re: difference btw Analyze and Optimize table..
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 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
