Tune MySQL for Artifactory

JFrog Installation & Setup Documentation

Content Type
Installation & Setup

When using Artifactory with MySQL it is recommended to use the InnoDB engine with the following tuning parameters configured in the /etc/my.cnf file.

# The MySQL server
# By default innodb engine use one file for all databases and tables. We recommend changing this to one file per table.
# NOTE: This will take effect only if Artifactory tables are not created yet! Need to be set and MySQL restarted before starting Artifactory for the first time.
# Theses are tuning parameters that can be set to control and increase the memory buffer sizes.
# Theses control the innodb log files size and can be changed only when MySQL is down and MySQL will not start if there are some innodb log files left in the datadir.
# So, changing theses means removing the old innodb log files before start.

After tuning, you need to restart MySQL.