Configuring MySQL

sudo jamf-pro database config set --innodb-buffer-pool-size <size>

The <size> value is the total amount of memory that MySQL will use on the server. This should be approximately 70% of the server's total available memory. At a minimum, a value larger than the largest table size in the database is recommended. Table sizes will vary based on the number of enrolled devices and log flushing frequency. The value for this variable uses a single character to specify the unit of measure for the numeric value. Decimal values are not supported. For example:

• "16G" is equal to 16 Gigabytes

• "4096M" is equal to 4096 Megabytes or 4 Gigabytes.

  Note:

  Ensure that enough memory remains available for the operating system of the server. Different operating systems have different memory requirements.