Re: max_allowed_Packet automatically reset to 1M
Well, there are three main possibilities ...
1. The server restarted with a different my.cnf. You can rule that in or out by inspecting the server log.
2. Someone with SUPER privilege is running a script that changes the max_allowed_packet value. You can fix this by setting the SUPER privilege of everyone except root to 'N', and of course ensuring that only you can login to the DB as root.
3. You have a rogue user, ie you've been hacked. The app doesn't login as root, does it? Turn on the general query log, wait for the value to reset, then inspect the query log.
Subject
Written By
Posted
Re: max_allowed_Packet automatically reset to 1M
March 22, 2016 11:09AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.