MySQL Forums
Forum List  »  General

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
September 09, 2010 01:30AM
September 10, 2010 02:28PM
September 11, 2010 10:15AM
September 21, 2010 06:44AM
September 21, 2010 03:41PM
September 22, 2010 06:58AM
September 22, 2010 07:35PM
September 23, 2010 12:10AM
September 23, 2010 08:48AM
October 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.