MySQL Forums
Forum List  »  Replication

Replication Halts during Bulk insert Mysql5.7.10
Posted by: Karthik Ramakrishnan
Date: July 29, 2016 10:16AM

Hi All

I'm using MySQL 5.7.10 (CentOS6.3) . My replication halts on Slave when there is a bulk insert from Master. Replication halts only on insert statement on specific table. I have changed the bulk_insert_buffer_size from 8M to 256 M. Please let me know your inputs to resolve the issue. Tried few blogs , but i could find any updates . Once replication Hangs i cant execute any statements in mysql prompt (i.e stop slave). I need to bounce the DB at that point ,then mysql start processing that record and gets synced.

Regards
Karthik R

Options: ReplyQuote


Subject
Views
Written By
Posted
Replication Halts during Bulk insert Mysql5.7.10
1226
July 29, 2016 10:16AM


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.