my.cnf Per Server Settings
my.cnf settings can be configured on a per-server basis for both MySQL and MariaDB. Before applying any changes, LxRoot will verify that the database server accepts the configuration without errors.
Note
A MySQL/MariaDB restart is required for these settings to take effect.
Configuration Steps
- Open Servers in the left side bar
- Locate the server you would like to edit and select Manage
- Scroll to Roles and select the Database tab
- Click my.cnf, enter your parameters, and click Save
Commonly Modified Settings
While not exhaustive, the following parameters are frequently adjusted to optimize performance:
- sql_mode
- key_buffer_size
- sort_buffer_size
- innodb_buffer_pool_size
- max_allowed_packet
This is not an exhaustive list. You should thoroughly research and test any configuration changes prior to making them in a production environment.