Bug #55281 REPLICATION - How to keep COMMIT for every 10000 Records
Submitted: 15 Jul 2010 12:00 Modified: 15 Jul 2010 12:20
Reporter: Anil Alpati Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.1.45 OS:Linux
Assigned to: CPU Architecture:Any

[15 Jul 2010 12:00] Anil Alpati 
Description:
REPLICATION - How to keep COMMIT for every 10000 Records 

Since I have  6 lakhs records to insert in the MASTER Server in one shot  

Because of this - Replication is not happening correctly its breaking the transactions and rollback all the changes.

Since All the six lakh records are storing in single transactions. ( In ONE COMMIT). In the mean time if Mysql SERVER gone away  then all the changes will rollback 

Please help me out for the same.

How to repeat:
REPLICATION - How to keep COMMIT for every 10000 Records 

Since I have  6 lakhs records to insert in the MASTER Server in one shot  

Because of this - Replication is not happening correctly its breaking the transactions and rollback all the changes.

Since All the six lakh records are storing in single transactions. ( In ONE COMMIT). In the mean time if Mysql SERVER gone away  then all the changes will rollback 

Please help me out for the same.
[15 Jul 2010 12:20] Valeriy Kravchuk 
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.