MySQL Forums
Forum List  »  InnoDB

Re: configure for innodb variables
Posted by: Rick James
Date: August 14, 2016 06:01PM

Leave most settings at their default values. But, do set innodb_buffer_pool_size to about 70% of _available_ RAM. After you have been running for some time, see if you have any performance issues. If you do, start by suspecting bad indexes and/or queries. Only after that is fixed as much as practical, re-investigate the tuning parameters.

At that point provide both SHOW VARIABLES and SHOW GLOBAL STATUS (after the server has been running at least a day), plus RAM size. With that set of values, we can advise whether anything else needs tuning.

Options: ReplyQuote


Subject
Views
Written By
Posted
1404
August 12, 2016 02:24AM
Re: configure for innodb variables
954
August 14, 2016 06:01PM
924
August 16, 2016 01:59AM
743
August 18, 2016 04:36PM


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.