…: 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: Can MySQL temporary tables be made safe for statement-based replication?
Post: 10+ Ways to Crash or Overload MySQL
…transaction and doing a lot of updates, or simply keeping transaction…stored procedure language constructions but I do not think tight memory allocation policy is enforced. Stored Procedures Cursors – Cursors inside of stored procedures…

