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 <cnw...@gmail.com> 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