MySQL Forums
Forum List  »  Replication

MySQL Replicaiton Slave Halts on Bulk insert from master
Posted by: Karthik Ramakrishnan
Date: July 29, 2016 09:50AM

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




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.