summaryrefslogtreecommitdiff
path: root/libmysql_r
diff options
context:
space:
mode:
authorManish Kumar <manish.4.kumar@oracle.com>2012-05-21 12:57:39 +0530
committerManish Kumar <manish.4.kumar@oracle.com>2012-05-21 12:57:39 +0530
commit9aa79dc5966b6bba74c772d110265161a018cbf2 (patch)
treee2cc824480d8f8df482d14d8b25129df48df0bdf /libmysql_r
parentc64b88d65a48d6c6651787f46f2094b310ceb5f1 (diff)
downloadmariadb-git-9aa79dc5966b6bba74c772d110265161a018cbf2.tar.gz
BUG#12400221 - 60926: BINARY LOG EVENTS LARGER THAN MAX_ALLOWED_PACKET
Problem ======== SQL statements close to the size of max_allowed_packet produce binary log events larger than max_allowed_packet. The reason why this failure is occuring is because the event length is more than the total size of the max_allowed_packet + max_event_header length. Now since the event length exceeds this size master Dump thread is unable to send the packet on to the slave. That can happen e.g with row-based replication in Update_rows event. Fix ==== The problem was fixed by increasing the max_allowed_packet for the slave's threads (IO/SQL) by increasing it to 1GB. This is done using the new server option included which is used to regulate the max_allowed_packet of the slave thread (IO/SQL). This causes the large packets to be received by the slave and apply it successfully.
Diffstat (limited to 'libmysql_r')
0 files changed, 0 insertions, 0 deletions