log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master

MySQL Replication is throwing the below error while show slave status:

 

log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master

 

  • max_allowed_packet refers to single SQL statement sent to the MySQL server as binary log event from master to slave.
  • This error usually occurs when you have a different size of max_allowed_packet on the master and slave (i.e. master max_allowed_packet size is greater then slave server).
on August 3, 2018.
Add Comment
1 Answer(s)
  • max_allowed_packet refers to single SQL statement sent to the MySQL server as binary log event from master to slave.
  • This error usually occurs when you have a different size of max_allowed_packet on the master and slave (i.e. master max_allowed_packet size is greater then slave server).
Answered on August 6, 2018.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.