1
drop database if exists mysqltest;
2
drop table if exists t1,t2,t3;
3
drop database if exists mysqltest;
4
drop table if exists t1,t2,t3;
7
create database mysqltest;
9
create table t1 (a int primary key) engine=ndb;
10
create table t2 (a int primary key) engine=ndb;
11
show binlog events from <binlog_start>;
12
Log_name Pos Event_type Server_id End_log_pos Info
13
mysqld-bin.000001 # Query 1 # create database mysqltest
14
mysqld-bin.000001 # Query 1 # use `mysqltest`; create table t1 (a int primary key) engine=ndb
15
mysqld-bin.000001 # Query 2 # use `test`; create table t2 (a int primary key) engine=ndb
16
show binlog events from <binlog_start>;
17
Log_name Pos Event_type Server_id End_log_pos Info
18
mysqld-bin.000001 # Query 1 # create database mysqltest
19
mysqld-bin.000001 # Query 1 # use `mysqltest`; create table t1 (a int primary key) engine=ndb
20
mysqld-bin.000001 # Query 2 # use `test`; create table t2 (a int primary key) engine=ndb
23
alter table t2 add column (b int);
24
show binlog events from <binlog_start>;
25
Log_name Pos Event_type Server_id End_log_pos Info
26
mysqld-bin.000001 # Query 2 # use `test`; alter table t2 add column (b int)
29
ALTER DATABASE mysqltest CHARACTER SET latin1;
30
drop table mysqltest.t1;
31
show binlog events from <binlog_start>;
32
Log_name Pos Event_type Server_id End_log_pos Info
33
mysqld-bin.000001 # Query 2 # ALTER DATABASE mysqltest CHARACTER SET latin1
34
mysqld-bin.000001 # Query 2 # use `mysqltest`; drop table `t1`
35
show binlog events from <binlog_start>;
36
Log_name Pos Event_type Server_id End_log_pos Info
37
mysqld-bin.000001 # Query 2 # ALTER DATABASE mysqltest CHARACTER SET latin1
38
mysqld-bin.000001 # Query 2 # use `mysqltest`; drop table `t1`
42
insert into t2 values (1,2);
43
drop database mysqltest;
44
create table t1 (a int primary key) engine=ndb;
45
show binlog events from <binlog_start>;
46
Log_name Pos Event_type Server_id End_log_pos Info
47
mysqld-bin.000001 # Query 2 # BEGIN
48
mysqld-bin.000001 # Table_map 2 # table_id: # (test.t2)
49
mysqld-bin.000001 # Table_map 2 # table_id: # (mysql.ndb_apply_status)
50
mysqld-bin.000001 # Write_rows 2 # table_id: #
51
mysqld-bin.000001 # Write_rows 2 # table_id: # flags: STMT_END_F
52
mysqld-bin.000001 # Query 2 # COMMIT
53
mysqld-bin.000001 # Query 1 # drop database mysqltest
54
mysqld-bin.000001 # Query 1 # use `test`; create table t1 (a int primary key) engine=ndb
58
CREATE LOGFILE GROUP lg1
59
ADD UNDOFILE 'undofile.dat'
63
ALTER LOGFILE GROUP lg1
64
ADD UNDOFILE 'undofile02.dat'
68
ADD DATAFILE 'datafile.dat'
73
ADD DATAFILE 'datafile02.dat'
77
DROP DATAFILE 'datafile.dat'
80
DROP DATAFILE 'datafile02.dat'
84
DROP LOGFILE GROUP lg1
86
show binlog events from <binlog_start>;
87
Log_name Pos Event_type Server_id End_log_pos Info
88
mysqld-bin.000001 # Query 1 # CREATE LOGFILE GROUP lg1
89
ADD UNDOFILE 'undofile.dat'
93
mysqld-bin.000001 # Query 1 # ALTER LOGFILE GROUP lg1
94
ADD UNDOFILE 'undofile02.dat'
97
mysqld-bin.000001 # Query 1 # CREATE TABLESPACE ts1
98
ADD DATAFILE 'datafile.dat'
102
mysqld-bin.000001 # Query 1 # ALTER TABLESPACE ts1
103
ADD DATAFILE 'datafile02.dat'
106
mysqld-bin.000001 # Query 1 # ALTER TABLESPACE ts1
107
DROP DATAFILE 'datafile.dat'
109
mysqld-bin.000001 # Query 1 # ALTER TABLESPACE ts1
110
DROP DATAFILE 'datafile02.dat'
112
mysqld-bin.000001 # Query 1 # DROP TABLESPACE ts1
114
mysqld-bin.000001 # Query 1 # DROP LOGFILE GROUP lg1
116
show binlog events from <binlog_start>;
117
Log_name Pos Event_type Server_id End_log_pos Info
118
mysqld-bin.000001 # Query 1 # CREATE LOGFILE GROUP lg1
119
ADD UNDOFILE 'undofile.dat'
121
UNDO_BUFFER_SIZE = 1M
123
mysqld-bin.000001 # Query 1 # ALTER LOGFILE GROUP lg1
124
ADD UNDOFILE 'undofile02.dat'
127
mysqld-bin.000001 # Query 1 # CREATE TABLESPACE ts1
128
ADD DATAFILE 'datafile.dat'
129
USE LOGFILE GROUP lg1
132
mysqld-bin.000001 # Query 1 # ALTER TABLESPACE ts1
133
ADD DATAFILE 'datafile02.dat'
136
mysqld-bin.000001 # Query 1 # ALTER TABLESPACE ts1
137
DROP DATAFILE 'datafile.dat'
139
mysqld-bin.000001 # Query 1 # ALTER TABLESPACE ts1
140
DROP DATAFILE 'datafile02.dat'
142
mysqld-bin.000001 # Query 1 # DROP TABLESPACE ts1
144
mysqld-bin.000001 # Query 1 # DROP LOGFILE GROUP lg1
153
create table t1 (a int key) engine=ndb;
154
create table t2 (a int key) engine=ndb;
155
create table t3 (a int key) engine=ndb;
156
rename table t3 to t4, t2 to t3, t1 to t2, t4 to t1;
157
show binlog events from <binlog_start>;
158
Log_name Pos Event_type Server_id End_log_pos Info
159
mysqld-bin.000001 # Query 1 # use `test`; create table t1 (a int key) engine=ndb
160
mysqld-bin.000001 # Query 1 # use `test`; create table t2 (a int key) engine=ndb
161
mysqld-bin.000001 # Query 1 # use `test`; create table t3 (a int key) engine=ndb
162
mysqld-bin.000001 # Query 1 # use `test`; rename table `test.t3` to `test.t4`
163
mysqld-bin.000001 # Query 1 # use `test`; rename table `test.t2` to `test.t3`
164
mysqld-bin.000001 # Query 1 # use `test`; rename table `test.t1` to `test.t2`
165
mysqld-bin.000001 # Query 1 # use `test`; rename table `test.t4` to `test.t1`
175
create table t1 (a int key) engine=ndb;
176
insert into t1 values(1);
177
rename table t1 to t2;
178
insert into t2 values(2);
180
show binlog events from <binlog_start>;
181
Log_name Pos Event_type Server_id End_log_pos Info
182
mysqld-bin.000001 # Query 1 # use `test`; create table t1 (a int key) engine=ndb
183
mysqld-bin.000001 # Query 2 # BEGIN
184
mysqld-bin.000001 # Table_map 2 # table_id: # (test.t1)
185
mysqld-bin.000001 # Table_map 2 # table_id: # (mysql.ndb_apply_status)
186
mysqld-bin.000001 # Write_rows 2 # table_id: #
187
mysqld-bin.000001 # Write_rows 2 # table_id: # flags: STMT_END_F
188
mysqld-bin.000001 # Query 2 # COMMIT
189
mysqld-bin.000001 # Query 1 # use `test`; rename table `test.t1` to `test.t2`
190
mysqld-bin.000001 # Query 2 # BEGIN
191
mysqld-bin.000001 # Table_map 2 # table_id: # (test.t2)
192
mysqld-bin.000001 # Table_map 2 # table_id: # (mysql.ndb_apply_status)
193
mysqld-bin.000001 # Write_rows 2 # table_id: #
194
mysqld-bin.000001 # Write_rows 2 # table_id: # flags: STMT_END_F
195
mysqld-bin.000001 # Query 2 # COMMIT
196
mysqld-bin.000001 # Query 2 # use `test`; drop table t2