Applicable to:
- Plesk for Linux
- Plesk for Windows
Question
How to adjust the max_user_connections
value in MySQL/MariaDB on a Plesk server?
Answer
-
Connect to a Plesk server via SSH.
-
Open the
my.cnf
file 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 following line under the [MySQLD] section:
# grep max_user_connections /etc/my.cnf
max_user_connections = 100 -
Save the changes and close the file.
-
Restart the MySQL/MariaDB service to apply the changes:
# systemctl restart mysql
# systemctl restart mariadb
-
Connect to a Plesk server via RDP.
-
Open the file
%plesk_dir%Databases\MySQL\my.ini
in a text editor (just paste this path in Windows Explorer to open). -
Increase the value of
max_user_connections
:Note: If
max_user_connections
does not exist, add this line under the [MySQLD] section.CONFIG_TEXT: max_user_connections = 100
-
Save the changes and close the file.
-
Open Plesk Services Monitor in Windows Start > All Programs > Plesk.
-
Select MySQL56 or MariaDB103 under the SQL Server section and click Restart to apply the chnages.
Comments
0 comments
Please sign in to leave a comment.