8.2.16. MySQL settings

MySQL instance settings are managed in the "MySQL" section on the "Settings" tab:

The following settings can be changed:

  • wait_timeout — number of seconds that the server waits for activity on a non-interactive connection before closing it (default is 7200 seconds / 2 hours).
  • connect_timeout — number of seconds that the MySQL server waits for a connection packet before returning a Bad handshake (default is 100 seconds).
    • Increasing the value may help with frequent errors like "Lost connection to MySQL server at 'XXX', system error: errno".
  • binlog_expire_logs_seconds — storage period for binary logs in seconds, after which these logs can be automatically deleted (minimum 10,800 seconds / 3 hours).
    • When using replication, the value must be no less than the lag time between the replica and the source.
  • performance_schema — option is required to collect and view query execution statistics.
    • ⚠️ Can only be enabled in plans with 4 GB of RAM or more.
    • ⚠️ Instance restart required.
  • max_connections — maximum number of simultaneous client connections (maximum 5000).

The following settings cannot be changed:

Content