mysql同步报错2020
080927 15:28:42 [Note] Slave: connected to master 'test@localhost:3306',replication resumed in log 'mysql-bin.000003' at position 34699088080927 15:28:42 [ERROR] Error reading packet from server: Got packet bigger than 'max_allowed_packet' bytes ( server_errno=2020)080927 15:28:42 [Note] Slave I/O thread: Failed reading log event, reconnecting to retry, log 'mysql-bin.000003' position 34699088 |
修改my.cnf中max_allowed_packet这个属性的值为16M。
vi /etc/my.cnf# max_allowed_packet = 1M# modify it tomax_allowed_packet = 16M |