When using the Jamf-Pro binary, to make a conversion of the database to InnoDB, I am encountering new settings for MySQL that I am unfamiliar with.
InnoDB buffer pool size says to choose around 70% of the total system memory and will automatically do that. Any wisdom as to why I should accept, increase or decrease this value?
InnoDB key buffer size: The only nugget of info I have found is the 16M value that is present when the question is asked. Any wisdom on how I would calculate a value?
InnoDB flush log at transaction commit: Presuming yes, but knowing more about what is being done is good.
InnoDB file per table: my choices are 0, 1 or 2. Logic dictates to choose 1 but again, I'm open to understanding what this setting is about.
For those wanting to know about the scale of our environment, I'm definitely willing to provide details. I'm just for now wanting to understand what these settings are and how one might determine what values to use.
Kind regards,
blackholemac