Re: Shudden Slow down of MySQL Queries
> 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
Subject
Views
Written By
Posted
1883
October 24, 2014 04:50AM
1315
October 25, 2014 12:52AM
1140
October 25, 2014 01:14AM
1306
October 26, 2014 11:53AM
1223
October 27, 2014 04:59AM
1186
October 27, 2014 11:43AM
1159
October 27, 2014 11:12PM
1228
October 28, 2014 02:24PM
1145
October 29, 2014 01:54AM
Re: Shudden Slow down of MySQL Queries
1105
October 29, 2014 02:12AM
970
October 29, 2014 08:18AM
1231
November 03, 2014 04:01AM
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.