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 02, 2020 10:15AM

These are guidelines, not absolute rules to be applied literally.

For ib buffer pool size, 70% is probably safer.

Note the page says instances can improve concurrency. Can, not will. Do you have monitoring data indicating concurrency is an issue in this system?

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.