1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
set @my_barrier= "barrier";
SELECT CREATE_BARRIER(@my_barrier);
CREATE_BARRIER(@my_barrier)
1
set @my_barrier= "barrier";
SELECT USER_BARRIER_NAME FROM DATA_DICTIONARY.USER_DEFINED_BARRIERS WHERE USER_BARRIER_NAME=@my_barrier;
USER_BARRIER_NAME
barrier
SET @execute= "SELECT WAIT('barrier')";
SELECT SIGNAL(@my_barrier);
SIGNAL(@my_barrier)
1
EXECUTE @execute CONCURRENT;
EXECUTE @execute CONCURRENT;
EXECUTE @execute CONCURRENT;
SELECT WAIT_UNTIL(@my_barrier, 3);
WAIT_UNTIL(@my_barrier, 3)
1
SELECT USER,INFO FROM DATA_DICTIONARY.PROCESSLIST ORDER BY ID;
USER INFO
root SELECT USER,INFO FROM DATA_DICTIONARY.PROCESSLIST ORDER BY ID
root
root SELECT WAIT('barrier')
root SELECT WAIT('barrier')
root SELECT WAIT('barrier')
SELECT SIGNAL(@my_barrier);
SIGNAL(@my_barrier)
1
|