MySQL Forums
Forum List  »  Performance

Re: Deleted Records and Optimize
Posted by: Luis Cavazos
Date: September 08, 2015 03:51PM

Thanks for your answer.

But it Actually does Slow things, if I don run the optimize, within few days the 2MB will convert into 2GB, in about a month it reaches about 4GB, and the program using that table becomes very slow, as soon as I run the Optimize it will accelerate again.

And Yes the inodb_pool is set to 32GB of 48GB Ram.

So far What I did is set the optimize to every 3 hours. but i dont know if there is any other way to manage this.

Thanks Again.

Options: ReplyQuote


Subject
Views
Written By
Posted
1535
August 21, 2015 08:08AM
709
August 22, 2015 11:13AM
Re: Deleted Records and Optimize
738
September 08, 2015 03:51PM
679
September 09, 2015 06:42PM


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.