Skip to content

Instantly share code, notes, and snippets.

@joefrancia
joefrancia / events_safe.sql
Created June 13, 2020 22:51
Avoid SQL contention in events
DELIMITER //
CREATE EVENT testlock_event ON SCHEDULE EVERY 2 SECOND DO
BEGIN
DECLARE CONTINUE HANDLER FOR SQLEXCEPTION
BEGIN
DO RELEASE_LOCK('testlock_event');
END;
IF GET_LOCK('testlock_event', 0) THEN
-- add some business logic here, for example:
-- insert into test.testlock_event values(NULL, NOW());

Keybase proof

I hereby claim:

  • I am scaba on github.
  • I am joefrancia (https://keybase.io/joefrancia) on keybase.
  • I have a public key ASDjpkwMd66Z3QqwQ2nKKCYhI4C7P1nFCSNrDRwS1WYTRAo

To claim this, I am signing this object: