Applicable to:
- Plesk for Linux
- Plesk for Windows
Question
How to set custom parameter value for MySQL server (which serves client databases) on Plesk?
For example, max_allowed_packet, read_buffer_size or wait_timeout
Answer
Note: the custom value should not exceed limits defined by MySQL vendor
Follow the steps below to achieve the same:
- Connect to Plesk server via SSH
-
Set the max_allowed_packet or wait_timeout value in
[mysqld]and[mysqldump]sections ofmy.cnffile (open the file using vi editor).- For Debian/Ubuntu:
CONFIG_TEXT: /etc/mysql/my.cnf
- For CentOS/RHEL/CloudLinux:
CONFIG_TEXT: /etc/my.cnf
CONFIG_TEXT: [mysqld]
wait_timeout = 31536000
max_allowed_packet=32M
....
[mysqldump]
max_allowed_packet=32M - For Debian/Ubuntu:
-
Restart MySQL service:
# service mysql restart || service mariadb restart || service mysqld restart
- Connect to Plesk server via RDP
-
Set the max_allowed_packet or wait_timeout value in
[mysqld]and[mysqldump]sections of%plesk_dir%Databases\MySQL\my.inifile.CONFIG_TEXT: [mysqld]
wait_timeout = 31536000
max_allowed_packet=32M
....
[mysqldump]
max_allowed_packet=32MNote: wait_timeout=31536000 is the maximum supported value in MySQL server.
- After saving the file, restart MySQL process via Plesk Services Monitor (it can be found in system tray):
Comments
12 comments
I increased max_allowed_packet editing the right my.cnf file, and I confirmed using phpMyAdmin that the new value is applying.
Periodically, max_allowed_packet reset itself to 1024, even lower than MySQL default (that is 4M), crashing the majority of websites relying on MySQL.
@Marco Marsala
Hello!
Such behavior is caused by MySQL Bug.
See also MySQL forum topic regarding this issue.
@Ivan Postnikov
This is classified as “not a bug”. The forum topic says that 3rd party software is running a query to reset the value to 1024.
My code never run such query. The only 3rd party running on the server is Plesk panel.
Maybe this is a Plesk issue?
@Marco Marsala
Hello!
In this case, I would suggest submitting a ticket for Plesk Technical Support, as more detailed investigation is required.
Should Screenshot for Windows Plesk be updated so thick would be on "SQL Server" group or "MySQL56" service and not on "Plesk SQL Server"?
@Almir The article has been updated, thank you!
Thank you
I use centos 7 with plesk
For CentOS
Command: vi /etc/my.cnf
This code is not visible.
[mysqld]
wait_timeout = 31536000
max_allowed_packet=32M
....
[mysqldump]
max_allowed_packet=32M
You need add this line
Hello Edwynn Flores Martínez
Yes, correct. It is needed to add these parameters in the /etc/my.cnf configuration file.
There is no definable place to put these lines. I can't just add the block as it corrupts my plesk database after restart.
not explained, my.cnf is very diferent to this
Rafael Dominguez Rodriguez You can put the mentioned parameters to any place within [mysqld] and [mysqldump] sections: in the beginning, or in the end - it should work
Please sign in to leave a comment.