Hi! On Wed, Aug 16, 2023 at 2:50 PM Michael Widenius <[email protected]> wrote: > > Hi! > > Hi! > > On Tue, Aug 15, 2023 at 11:24 PM kpesio--- via discuss > <[email protected]> wrote: > > > > Hi. Could someone confirm in some way about running multiple events at same > > time.
Confirmed. Here is a test case that proves this: drop table if exists t1; drop event ev1; drop event ev2; SET GLOBAL event_scheduler=ON; set @n=now(); select @n, addtime(@n,1); CREATE TABLE t1 (a INT); CREATE EVENT ev1 ON SCHEDULE AT ADDTIME(@n,2) DO INSERT INTO t1 VALUES (10+sleep(10)); show warnings; CREATE EVENT ev2 ON SCHEDULE AT ADDTIME(@n,3) DO INSERT INTO t1 VALUES (13); select sleep(12); select * from t1; The last select returns rows 10 & 13 Regards, Monty _______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
