Starting on October 19, 2021, we will enable single-sign-on for our Plesk Support Center to provide a seamless login/account experience. This implies that you’ll be able to use a single account across any of our web-facing properties.
To be prepared for this change and to avoid the need to register during your next ticket submission after the change, we encourage you to create an account here before October 19 using the same email address as your current Zendesk login (support account). It’s essential that you use the same email address on our support center to ensure that your tickets stay attached to the same account. You will continue to use ZenDesk authentication until we switch over to single-sign-on on October 19th.

How to set the value of max_allowed_packet or wait_timeout for MySQL on Plesk server?

Follow

Comments

9 comments

  • Avatar
    Marco Marsala (Edited )

    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.

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    @Marco Marsala

    Hello!
    Such behavior is caused by MySQL Bug.

    See also MySQL forum topic regarding this issue.

    0
    Comment actions Permalink
  • Avatar
    Marco Marsala

    @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?

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    @Marco Marsala

    Hello!
    In this case, I would suggest submitting a ticket for Plesk Technical Support, as more detailed investigation is required.

    0
    Comment actions Permalink
  • Avatar
    DHH-SI

    Should Screenshot for Windows Plesk be updated so thick would be on "SQL Server" group or "MySQL56" service and not on "Plesk SQL Server"?

    0
    Comment actions Permalink
  • Avatar
    Alexander Tsmokalyuk

    @Almir The article has been updated, thank you!

    0
    Comment actions Permalink
  • Avatar
    Willy Cevallos

    Thank you

    0
    Comment actions Permalink
  • Avatar
    Edwynn Flores Martínez

    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 

    0
    Comment actions Permalink
  • Avatar
    Nelson Leiva

    Hello Edwynn Flores Martínez

    Yes, correct. It is needed to add these parameters in the /etc/my.cnf configuration file.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request