Do not attempt to make any of these changes without a Backup of your JSS Database.
For some reason this is recommended to be set to 3. I believe this is to stop MariaDB/MySQL from coming up with too many execution plans.
As per this article, key buffer size should be set to about 25% or more of the available server RAM.
Set to 0 to disable the query cache.
(ignore) Table Storage: InnoDB¶
Changing the table storage might have far reaching implications for you so I don’t recommend this now, but these settings were recommended:
innodb_log_file_size=512M innodb_flush_log_at_trx_commit=1 innodb_file_per_table=1 innodb_buffer_pool_size=amount_of_RAMG # 60% or more of your total ram innodb_buffer_pool_instances=8