Articles in this section

See more

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

Avatar
Alexander Tsmokalyuk
Updated
Follow

Applicable to:

  • Plesk for Linux
  • Plesk for Windows

Question

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

Answer

Follow the steps below to achieve the same:

For Linux:
  1. Connect to the server using SSH ;

  2. Set the max_allowed_packet or wait_timeout value in [mysqld] and [mysqldump] sections of my.cnf file.

    • 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=16M
    ....
    [mysqldump]
    max_allowed_packet=16M

  3. Restart MySQL service (use the command appropriate to MySQL distribution used):

    # service mysql restart

    # service mysqld restart

    # service mariadb restart

For Windows:
  1. Connect to the server using RDP;

  2. Set the max_allowed_packet or wait_timeout value in [mysqld] and [mysqldump] sections of my.ini file.

    Note:

    • The file to edit in Windows with Plesk 12.5 or lower is %plesk_dir%\Plesk\Databases\MySQL\Data\my.ini.
    • The file to edit in Windows with Plesk Onyx or newer is %plesk_dir%\Plesk\Databases\MySQL\my.ini.

      Note: wait_timeout=31536000 is the maximum supported value in MySQL server.

    CONFIG_TEXT: [mysqld]
    wait_timeout = 31536000
    max_allowed_packet=16M
    ....
    [mysqldump]
    max_allowed_packet=16M

  3. After saving the file, restart MySQL process via Plesk Services Monitor:

    serv.png

Comments

4 comments

Sort by Date Votes
  • 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

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles