官方文档如下 If a repeating event does not terminate within its scheduling interval, the result may be multiple
instances of the event executing simultaneously. If this is undesirable, you should institute a
mechanism to prevent simultaneous instances. For example, you could use the GET_LOCK()
function, or row or table locking.
instances of the event executing simultaneously. If this is undesirable, you should institute a
mechanism to prevent simultaneous instances. For example, you could use the GET_LOCK()
function, or row or table locking.
如果重复事件不其调度时间间隔内终止,其结果可能是同时执行该事件的多个实例。 如果这是不可取的,你应该建立一个机制,以防止并发实例。 例如,您可以使用GET_LOCK()函数,或行或表锁。
#判断是否被锁
IF(SELECT IS_FREE_LOCK(_lockName)=1) THEN
#未被锁
#给程序加锁
SELECT GET_LOCK(_lockName, 10);
#执行不允许争抢的资源
BEGIN
END;
#释放锁
SELECT RELEASE_LOCK(_lockName);
END IF;
1946 JobExtractCalculateExport-ExtractTag 2014-04-09 13:49:45
1945 JobExtractCalculateExport-Start 2014-04-09 13:49:45
1944 JobExtractCalculateExport-End 2014-04-09 13:48:56
1943 JobExtractCalculateExport-ExportMatch 2014-04-09 13:48:56
1942 JobExtractCalculateExport-CalculateWeight 2014-04-09 13:46:04
1941 JobExtractCalculateExport-ExtractTag 2014-04-09 13:45:45
1940 JobExtractCalculateExport-Start 2014-04-09 13:45:45
1947 JobExtractCalculateExport-CalculateWeight 2014-04-09 13:50:04
1946 JobExtractCalculateExport-ExtractTag 2014-04-09 13:49:45
1945 JobExtractCalculateExport-Start 2014-04-09 13:49:45只有JobExtractCalculateExport-Start没有JobExtractCalculateExport-End