Comments - Replication stops after one hour or so

10 years, 7 months ago Martin Trenz

Oh deary me, where can i hide my face?! You were right about the tables. We have one without a primary key and about 390000 records (created a long time before i joined the company).

Furthermore the DELETE statement is encapsulated in a transaction, so the Execution-Pointer really stops for an extensive time. I was able to find the problem by looking into the binlogs with "mysqlbinlog". Very useful tool. Thank you for pointing me in the right direction!

 
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.