1
include/master-slave.inc
3
DROP TABLE IF EXISTS t1;
4
CREATE LOGFILE GROUP lg1
5
ADD UNDOFILE 'undofile.dat'
9
alter logfile group lg1
10
add undofile 'undofile02.dat'
11
initial_size 4M engine=ndb;
13
ADD DATAFILE 'datafile.dat'
18
add datafile 'datafile02.dat'
19
initial_size 4M engine=ndb;
21
(pk1 int not null primary key, b int not null, c int not null)
22
tablespace ts1 storage disk
24
insert into t1 values (1,2,3);
25
select * from t1 order by pk1;
28
select * from t1 order by pk1;
31
show binlog events from <binlog_start>;
32
Log_name Pos Event_type Server_id End_log_pos Info
33
master-bin.000001 # Query 1 # use `test`; DROP TABLE IF EXISTS t1
34
master-bin.000001 # Query 1 # use `test`; CREATE LOGFILE GROUP lg1
35
ADD UNDOFILE 'undofile.dat'
39
master-bin.000001 # Query 1 # use `test`; alter logfile group lg1
40
add undofile 'undofile02.dat'
41
initial_size 4M engine=ndb
42
master-bin.000001 # Query 1 # use `test`; CREATE TABLESPACE ts1
43
ADD DATAFILE 'datafile.dat'
47
master-bin.000001 # Query 1 # use `test`; alter tablespace ts1
48
add datafile 'datafile02.dat'
49
initial_size 4M engine=ndb
50
master-bin.000001 # Query 1 # use `test`; CREATE TABLE t1
51
(pk1 int not null primary key, b int not null, c int not null)
52
tablespace ts1 storage disk
54
master-bin.000001 # Query 1 # BEGIN
55
master-bin.000001 # Table_map 1 # table_id: # (test.t1)
56
master-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status)
57
master-bin.000001 # Write_rows 1 # table_id: #
58
master-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F
59
master-bin.000001 # Query 1 # COMMIT
62
drop datafile 'datafile.dat'
65
drop datafile 'datafile02.dat'
67
DROP TABLESPACE ts1 ENGINE=NDB;
68
DROP LOGFILE GROUP lg1 ENGINE=NDB;