Skip to content

MySQL connection limit configuration

In some configurations, the MySQL connection limit may be restricted or behave unexpectedly, such as being unable to set a value higher than 214^[600-developer__operation-maintenance__zabbix__zabbix-agentd.md].

Configuration

To increase the number of permitted connections, you can set the global max_connections variable^[600-developer__operation-maintenance__zabbix__zabbix-agentd.md].

mysql> set global max_connections = 1000;

After changing this setting, updates to monitoring dashboards or external tools may be required to correctly reflect the new status^[600-developer__operation-maintenance__zabbix__zabbix-agentd.md].

Sources

  • 600-developer__operation-maintenance__zabbix__zabbix-agentd.md