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

Follow

Comments

4 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.

  • Avatar
    Ivan Postnikov

    @Marco Marsala

    Hello!
    Such behavior is caused by MySQL Bug.

    See also MySQL forum topic regarding this issue.

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

  • 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.

Please sign in to leave a comment.

Have more questions? Submit a request