How to increase the MySQL max_connections value on a Plesk server

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:

# service mariadb restart

# service mysql restart

# service mysqld restart

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 XX service via Plesk Services Monitor to apply changes: