Re: Using variable in trigger - high CPU usage problem

[Robert Bielik]

I finally opted for setting an event executed each day which updates a MEMORY table so I can in the trigger do:

DECLARE value INT;
SELECT `id` INTO value FROM mem_table WHERE `name`='Something';
IF (new.id=value) THEN
   INSERT INTO `accu_table` (id, ...columns...) VALUES(N, ...columns...);
END IF;

This does not influence CPU measurably.