How to increase the MySQL/MariaDB max_connections value?

Connect to a Plesk server via SSH

Open the file my.cnf in a text editor. In this example, we are using the vi editor:

• on CentOS/RHEL-based distributions

  # vi /etc/my.cnf

• on Debian/Ubuntu-based distributions

  # vi /etc/mysql/my.cnf

Add the max_connections parameter with a required value under the [mysqld] section:

CONFIG_TEXT: max_connections=150

Save the changes and close the file.

Restart the MySQL/MariaDB service:

# systemctl restart mysql

# systemctl restart mariadb

Connect to a Plesk server via RDP

Open the %plesk_dir%\Databases\MySQL\my.ini file in a text editor.

Add the max_connections parameter with a required value under the [mysqld] section:

CONFIG_TEXT: max_connections=150

Restart the MySQL/MariaDB XX service via Plesk Services Monitor to apply changes: