MySQL :: Re: Mysql 5.6: Are these calculations for innodb_buffer_pool

New Topic

Re: Mysql 5.6: Are these calculations for innodb_buffer_pool_size and instances correct?

Posted by: Peter Brawley
Date: November 01, 2020 10:34AM

innodb_buffer_pool_size should probably max out at 70% of available ram, and there should be enough ram to run without ever having to swap.

Recommendations for instances in 5.6 at https://dev.mysql.com/doc/refman/5.6/en/innodb-multiple-buffer-pools.html

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Written By

Posted

Mysql 5.6: Are these calculations for innodb_buffer_pool_size and instances correct?

Cesar Murilo Cesar

November 01, 2020 06:01AM

Re: Mysql 5.6: Are these calculations for innodb_buffer_pool_size and instances correct?

Peter Brawley

November 01, 2020 10:34AM

Re: Mysql 5.6: Are these calculations for innodb_buffer_pool_size and instances correct?

Cesar Murilo Cesar

November 02, 2020 09:58AM

Re: Mysql 5.6: Are these calculations for innodb_buffer_pool_size and instances correct?

Peter Brawley

November 02, 2020 10:15AM

Re: Mysql 5.6: Are these calculations for innodb_buffer_pool_size and instances correct?

Cesar Murilo Cesar

November 02, 2020 10:28AM

Re: Mysql 5.6: Are these calculations for innodb_buffer_pool_size and instances correct?

Peter Brawley

November 02, 2020 12:41PM

Re: Mysql 5.6: Are these calculations for innodb_buffer_pool_size and instances correct?

Cesar Murilo Cesar

November 02, 2020 01:50PM

Re: Mysql 5.6: Are these calculations for innodb_buffer_pool_size and instances correct?

Edwin Desouza

November 02, 2020 02:01PM

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.