MySQL Forums :: General :: Optimize table statement


Advanced Search

Optimize table statement
Posted by: abilash vs ()
Date: September 09, 2010 01:30AM

Hi,

I am using optimize table statement for a InnoDB table in which approximately thousands of records gets deleted daily.I have scheduled the optimize commnad to run once a week.If I want to see the quantitative improvements of optimize command results on this table,can you let me know what all I need to check (like table space etc..) and how to check those ?

Regards,
Abilash

Options: ReplyQuote


Subject Written By Posted
Optimize table statement abilash vs 09/09/2010 01:30AM
Re: Optimize table statement Shawn Taylor 09/10/2010 02:28PM
Re: Optimize table statement Rick James 09/11/2010 10:15AM
Re: Optimize table statement abilash vs 09/21/2010 06:44AM
Re: Optimize table statement Rick James 09/21/2010 03:41PM
Re: Optimize table statement abilash vs 09/22/2010 06:58AM
Re: Optimize table statement Rick James 09/22/2010 07:35PM
Re: Optimize table statement abilash vs 09/23/2010 12:10AM
Re: Optimize table statement Rick James 09/23/2010 08:48AM
Re: Optimize table statement abilash vs 10/08/2010 01:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.