MySQL Forums
Forum List  »  InnoDB

Re: Shudden Slow down of MySQL Queries
Posted by: jayaram pagoti
Date: October 29, 2014 02:12AM

> DELETE FROM availability WHERE datum < NOW() - INTERVAL 24 HOUR LIMIT 1000;

delete with limit is not a safe bin-log statement it seems, as we are using Master-Slave (Statement based) replication

Options: ReplyQuote


Subject
Views
Written By
Posted
1883
October 24, 2014 04:50AM
1306
October 26, 2014 11:53AM
1186
October 27, 2014 11:43AM
1228
October 28, 2014 02:24PM
Re: Shudden Slow down of MySQL Queries
1105
October 29, 2014 02:12AM
970
October 29, 2014 08:18AM


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.