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
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
|
CREATE LOGFILE GROUP lg1
ADD UNDOFILE 'lg1_undofile.dat'
INITIAL_SIZE 1M
UNDO_BUFFER_SIZE = 1M
ENGINE NDB;
CREATE TABLESPACE ts1
ADD DATAFILE 'ts1_datafile.dat'
USE LOGFILE GROUP lg1
INITIAL_SIZE 16M
ENGINE NDB;
CREATE TABLE procedure_control(
stop_flag INT
) ENGINE NDB;
CREATE PROCEDURE p1()
BEGIN
DECLARE done INT DEFAULT 0;
REPEAT
CREATE TABLE t1 (
a INT PRIMARY KEY,
b VARCHAR(255)
)
ENGINE NDB TABLESPACE ts1 STORAGE DISK;
DROP TABLE t1;
SELECT stop_flag INTO done FROM procedure_control;
UNTIL done END REPEAT;
END//
INSERT INTO procedure_control VALUE(0);
Start background load of CREATE + DROP TABLE t1 which uses tablespace ts1
CALL p1();
Start CREATE + DROP TABLE t2 which uses tablespace ts1
UPDATE procedure_control SET stop_flag=1;
Wait for background load to complete
DROP PROCEDURE p1;
DROP TABLE procedure_control;
ALTER TABLESPACE ts1
DROP DATAFILE 'ts1_datafile.dat';
DROP TABLESPACE ts1;
DROP LOGFILE GROUP lg1
ENGINE NDB;
CREATE LOGFILE GROUP lg1
ADD UNDOFILE 'lg1_undofile.dat'
INITIAL_SIZE 1M
UNDO_BUFFER_SIZE = 1M
ENGINE NDB;
CREATE TABLESPACE ts1
ADD DATAFILE 'ts1_datafile.dat'
USE LOGFILE GROUP lg1
INITIAL_SIZE 16M
ENGINE NDB;
CREATE TABLE procedure_control(
stop_flag INT
) ENGINE NDB;
CREATE TABLE dummy (
a INT PRIMARY KEY
) ENGINE NDB;
INSERT INTO dummy VALUES (1), (2), (3), (4), (5);
CREATE PROCEDURE p1()
BEGIN
DECLARE done INT DEFAULT 0;
DECLARE dummy_var INT DEFAULT 5;
REPEAT
ALTER TABLESPACE ts1
ADD DATAFILE 'ts1_datafile2.dat';
ALTER TABLESPACE ts1
DROP DATAFILE 'ts1_datafile2.dat';
SELECT stop_flag INTO done FROM procedure_control;
SELECT a INTO dummy_var FROM dummy WHERE a > 4;
UNTIL done END REPEAT;
END//
INSERT INTO procedure_control VALUE(0);
Start background load of ALTER TABLESPACE ts1 ADD/DROP DATAFILE
CALL p1();
Start CREATE + DROP TABLE t1 which uses tablespace ts1
UPDATE procedure_control SET stop_flag=1;
Wait for background load to complete
DROP PROCEDURE p1;
DROP TABLE procedure_control;
ALTER TABLESPACE ts1
DROP DATAFILE 'ts1_datafile.dat';
DROP TABLESPACE ts1;
DROP LOGFILE GROUP lg1
ENGINE NDB;
CREATE LOGFILE GROUP lg1
ADD UNDOFILE 'lg1_undofile.dat'
INITIAL_SIZE 1M
UNDO_BUFFER_SIZE = 1M
ENGINE NDB;
CREATE TABLESPACE ts1
ADD DATAFILE 'ts1_datafile.dat'
USE LOGFILE GROUP lg1
INITIAL_SIZE 16M
ENGINE NDB;
CREATE TABLE procedure_control(
stop_flag INT
) ENGINE NDB;
CREATE PROCEDURE p1()
BEGIN
DECLARE done INT DEFAULT 0;
REPEAT
ALTER TABLESPACE ts1
ADD DATAFILE 'ts1_datafile2.dat';
ALTER TABLESPACE ts1
DROP DATAFILE 'ts1_datafile2.dat';
SELECT stop_flag INTO done FROM procedure_control;
UNTIL done END REPEAT;
END//
INSERT INTO procedure_control VALUE(0);
Start background load of ALTER TABLESPACE ts1 ADD/DROP DATAFILE
CALL p1();
Start ALTER TABLESPACE ts1 ADD/DROP DATAFILE
UPDATE procedure_control SET stop_flag=1;
Wait for background load to complete
DROP PROCEDURE p1;
DROP TABLE procedure_control,dummy;
ALTER TABLESPACE ts1
DROP DATAFILE 'ts1_datafile.dat';
DROP TABLESPACE ts1;
DROP LOGFILE GROUP lg1
ENGINE NDB;
|
