Auto-Tune suggests and applies a MySQL/MariaDB configuration sized to the server’s RAM and workload, instead of the stock defaults.
Where
Admin panel → SQL Services → MySQL Tune (also run during install).
What it does
- Reads the server’s total RAM and the current MySQL/MariaDB status.
- Proposes values for the main buffers and limits (e.g. InnoDB buffer pool, connections, caches) that fit the available memory and leave headroom for the web/PHP stack.
- Writes a CWP-managed include so your own custom settings are preserved, and restarts the database to apply.
Notes
- A backup of the previous configuration is kept, so a change can be reverted.
- Re-run it after adding RAM to the server.