Using variable in trigger - high CPU usage problem
Hi,
I have a trigger which is executed AFTER INSERT on a "state" table (where values are inserted/removed rapidly), to accumulate the state changes into another table. This is only done for certain INSERTs where an id column has a certain value which changes over time so I use a function for that, like:
SET @value=GET_VALUE(CURRENT_TIMESTAMP);
IF (new.id=@value) THEN
INSERT INTO `accu_table` (id, ...columns...) VALUES(N, ...columns...);
END IF;
but this skyrocketed the servers CPU usage to 100%.
So pretty much I'd like to be able to do this with lesser CPU usage.
Ideas?
/Rob
Edited 1 time(s). Last edit at 06/28/2012 05:38AM by Robert Bielik.
Subject
Views
Written By
Posted
Using variable in trigger - high CPU usage problem
3362
June 28, 2012 03:35AM
1941
June 29, 2012 02:12AM
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.