Optimization of Innodb tables
Posted by: Kevin Tyson
Date: July 17, 2012 08:43AM

My Database is almost exclusively INNODB tables, we run optimization of out database once each month. My understanding is that optimization is achieved by copying to a temp table, truncating the table and rebuilding/reindexing the table (please confirm if that is incorrect). A colleague of mine indicated that we could get better performance by adjusting our INNODB buffer pool size prior to optimzation. I don't see the benefit in doing this since optimization is done on a per table basis (although we run 4 in parallel through a shell script). Can anyone advise on the affect of the innodb buffer size specifically on optimization?

Thanks in advance,
Kevin

Options: ReplyQuote


Subject
Written By
Posted
Optimization of Innodb tables
July 17, 2012 08:43AM


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.