| docs

Appearance

Database Settings ​

The Settings page in the Database section allows administrators to configure database server settings and manage MariaDB configuration profiles.

Database Settings

Overview ​

URL: /admin/database-settings

The page header reads: "Configure database server settings and manage MariaDB configuration profiles."

MariaDB Profile ​

At the top, a MariaDB Profile dropdown allows selecting a configuration profile (e.g., "MariaDB 2CPU 2GB RAM Profile"). An options menu (three dots) is available next to the profile selector.

Service Status ​

A status banner shows whether the MariaDB service is running, with a Check Service Status button.

Configuration Tabs ​

The settings page is organized into five tabs:

1. Server Configuration ​

Basic Server Settings ​

  • MySQL Port (required) - The port the database listens on (default: 3306).
  • MySQL Socket (required) - Path to the MySQL socket file.
  • Base Directory (required) - The MySQL installation base directory.
  • Bind Address (required) - The address the server binds to.
  • Data Directory (required) - Path to the data directory.
  • Default Authentication Plugin (required) - The default authentication method.
  • PID File (required) - Path to the process ID file.
  • Temporary Directory (required) - Path to the temporary directory.

Performance Settings ​

  • Max Allowed Packet (required) - Maximum packet size.
  • Max Connect Errors (required) - Maximum connection errors before blocking.
  • Skip External Locking - Whether to skip external locking (toggle).
  • Skip Name Resolve - Whether to skip DNS name resolution (toggle).
  • Key Buffer Size (required) - Size of the key buffer.
  • Low Priority Updates (required) - Priority for update operations.

2. InnoDB Configuration ​

InnoDB storage engine settings including buffer pool size, log file configuration, and other InnoDB-specific parameters.

3. Connection & Performance ​

Connection pooling, thread handling, and performance tuning options.

4. Logging & Monitoring ​

Configure log levels, slow query logging, error log paths, and monitoring options.

5. MySQL Dump Settings ​

Settings for mysqldump operations including default options for database backups.

Click Apply Configuration to apply the configuration for the active tab.

Profiles and Service Control ​

Configuration profiles and service controls are available at the top of the page:

  • Save as New Profile – Save the current configuration as a reusable profile.
  • Load Profile / Download Profile – Restore or export a saved profile.
  • Apply Configuration – Apply the current settings to the database service.
  • Refresh – Reload the current service status.
  • Restart – Restart the database service.