Not the answer you need?
Register and ask your own question!

max_allowed_packet reset

sterry1@tacc.utexas.edu[email protected] EntrantInactive User Role Beginner
I am having some trouble with my global max_allowed_packet being reset. The variable is set in the my.cnf file but some process with the server, galera or xtrabackup periodically resets the value. I have not been able to determine from the logs where this is coming from. Anyone have a clue?

Comments

  • mirfanmirfan Database Administrator Inactive User Role Beginner
    show me output of:
    $ ps -ef | grep -v grep | grep mysql
    $ cat /etc/my.cnf

    Did you tried to diagnose it with general query log ? However, If this issue is rare then your general log will be huge and it incur disk IO.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.