my.cnf Per Server Settings

my.cnf Per Server Settings

You can configure my.cnf settings on a per-server basis for both MySQL and MariaDB.

Before applying any settings, Enhance will verify that the MySQL server accepts the changes without errors. A MySQL restart will be required for the settings to take effect.

Steps to Configure my.cnf Settings on a Per Server Basis:

1. Open Servers in the left sidebar.
2. Locate the server you want to edit.
3. Click Manage in the dropdown.
4. Scroll to Roles.
5. Select the Database tab and click my.cnf.
6. Click Save to finish.

Common Settings to Adjust:

• sql_mode
• key_buffer_size
• sort_buffer_size
• innodb_buffer_pool_size
• max_allowed_packet

This is not an exhaustive list. Be sure to research and test any changes before applying them in a production environment.