May 26, 2012

Post: Can MySQL temporary tables be made safe for statement-based replication?

…: what if the whole transaction is inside a stored procedure? Whether this works or not depends, again, on how the stored procedure call is logged to…) What you see depends on your version of MySQL, because the logging of stored procedures has changed over time. If just the CALL…

Post: 10+ Ways to Crash or Overload MySQL

transaction and doing a lot of updates, or simply keeping transactionstored procedure language constructions but I do not think tight memory allocation policy is enforced. Stored Procedures Cursors – Cursors inside of stored procedures