MySQL Forums
Forum List  »  General

Re: Optimize table statement
Posted by: Rick James
Date: September 23, 2010 08:48AM

Assuming all InnoDB:

innodb_buffer_pool_size -- 70% of _available_ RAM
key_buffer_size -- 16M is fine
innodb_additional_mem_pool_size -- leave at the default.
innodb_file_per_table -- ON is preferred, but not easy to retrofit.

Don't bother to OPTIMIZE. Not even monthly.

If your daily DELETE gets too invasive, delete in small batches.

Options: ReplyQuote


Subject
Written By
Posted
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
Re: Optimize table statement
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.