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 2 # create database mysqltest
14
mysqld-bin.000001 # Query 2 # 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 1 # use `test`; create table t2 (a int primary key) engine=ndb
23
alter table t2 add column (b int);
25
Warning 1478 Converted FIXED field to DYNAMIC to enable on-line ADD COLUMN
26
show binlog events from <binlog_start>;
27
Log_name Pos Event_type Server_id End_log_pos Info
28
mysqld-bin.000001 # Query 1 # use `test`; alter table t2 add column (b int)
31
ALTER DATABASE mysqltest CHARACTER SET latin1;
32
drop table mysqltest.t1;
33
show binlog events from <binlog_start>;
34
Log_name Pos Event_type Server_id End_log_pos Info
35
mysqld-bin.000001 # Query 1 # ALTER DATABASE mysqltest CHARACTER SET latin1
36
mysqld-bin.000001 # Query 1 # use `mysqltest`; drop table `mysqltest`.`t1`
37
show binlog events from <binlog_start>;
38
Log_name Pos Event_type Server_id End_log_pos Info
39
mysqld-bin.000001 # Query 1 # ALTER DATABASE mysqltest CHARACTER SET latin1
40
mysqld-bin.000001 # Query 1 # use `mysqltest`; drop table `mysqltest`.`t1`
44
insert into t2 values (1,2);
45
drop database mysqltest;
46
create table t1 (a int primary key) engine=ndb;
47
show binlog events from <binlog_start>;
48
Log_name Pos Event_type Server_id End_log_pos Info
49
mysqld-bin.000001 # Query 2 # BEGIN
50
mysqld-bin.000001 # Table_map 2 # table_id: # (test.t2)
51
mysqld-bin.000001 # Table_map 2 # table_id: # (mysql.ndb_apply_status)
52
mysqld-bin.000001 # Write_rows 2 # table_id: #
53
mysqld-bin.000001 # Write_rows 2 # table_id: # flags: STMT_END_F
54
mysqld-bin.000001 # Query 2 # COMMIT
55
mysqld-bin.000001 # Query 2 # drop database mysqltest
56
mysqld-bin.000001 # Query 2 # use `test`; create table t1 (a int primary key) engine=ndb
60
CREATE LOGFILE GROUP lg1
61
ADD UNDOFILE 'undofile.dat'
65
ALTER LOGFILE GROUP lg1
66
ADD UNDOFILE 'undofile02.dat'
70
ADD DATAFILE 'datafile.dat'
75
ADD DATAFILE 'datafile02.dat'
79
DROP DATAFILE 'datafile.dat'
82
DROP DATAFILE 'datafile02.dat'
86
DROP LOGFILE GROUP lg1
88
show binlog events from <binlog_start>;
89
Log_name Pos Event_type Server_id End_log_pos Info
90
mysqld-bin.000001 # Query 2 # CREATE LOGFILE GROUP lg1
91
ADD UNDOFILE 'undofile.dat'
95
mysqld-bin.000001 # Query 2 # ALTER LOGFILE GROUP lg1
96
ADD UNDOFILE 'undofile02.dat'
99
mysqld-bin.000001 # Query 2 # CREATE TABLESPACE ts1
100
ADD DATAFILE 'datafile.dat'
101
USE LOGFILE GROUP lg1
104
mysqld-bin.000001 # Query 2 # ALTER TABLESPACE ts1
105
ADD DATAFILE 'datafile02.dat'
108
mysqld-bin.000001 # Query 2 # ALTER TABLESPACE ts1
109
DROP DATAFILE 'datafile.dat'
111
mysqld-bin.000001 # Query 2 # ALTER TABLESPACE ts1
112
DROP DATAFILE 'datafile02.dat'
114
mysqld-bin.000001 # Query 2 # DROP TABLESPACE ts1
116
mysqld-bin.000001 # Query 2 # DROP LOGFILE GROUP lg1
118
show binlog events from <binlog_start>;
119
Log_name Pos Event_type Server_id End_log_pos Info
120
mysqld-bin.000001 # Query 2 # CREATE LOGFILE GROUP lg1
121
ADD UNDOFILE 'undofile.dat'
123
UNDO_BUFFER_SIZE = 1M
125
mysqld-bin.000001 # Query 2 # ALTER LOGFILE GROUP lg1
126
ADD UNDOFILE 'undofile02.dat'
129
mysqld-bin.000001 # Query 2 # CREATE TABLESPACE ts1
130
ADD DATAFILE 'datafile.dat'
131
USE LOGFILE GROUP lg1
134
mysqld-bin.000001 # Query 2 # ALTER TABLESPACE ts1
135
ADD DATAFILE 'datafile02.dat'
138
mysqld-bin.000001 # Query 2 # ALTER TABLESPACE ts1
139
DROP DATAFILE 'datafile.dat'
141
mysqld-bin.000001 # Query 2 # ALTER TABLESPACE ts1
142
DROP DATAFILE 'datafile02.dat'
144
mysqld-bin.000001 # Query 2 # DROP TABLESPACE ts1
146
mysqld-bin.000001 # Query 2 # DROP LOGFILE GROUP lg1
155
create table t1 (a int key) engine=ndb;
156
create table t2 (a int key) engine=ndb;
157
create table t3 (a int key) engine=ndb;
158
rename table t3 to t4, t2 to t3, t1 to t2, t4 to t1;
159
show binlog events from <binlog_start>;
160
Log_name Pos Event_type Server_id End_log_pos Info
161
mysqld-bin.000001 # Query 2 # use `test`; create table t1 (a int key) engine=ndb
162
mysqld-bin.000001 # Query 2 # use `test`; create table t2 (a int key) engine=ndb
163
mysqld-bin.000001 # Query 2 # use `test`; create table t3 (a int key) engine=ndb
164
mysqld-bin.000001 # Query 2 # use `test`; rename table `test`.`t3` to `test`.`t4`
165
mysqld-bin.000001 # Query 2 # use `test`; rename table `test`.`t2` to `test`.`t3`
166
mysqld-bin.000001 # Query 2 # use `test`; rename table `test`.`t1` to `test`.`t2`
167
mysqld-bin.000001 # Query 2 # use `test`; rename table `test`.`t4` to `test`.`t1`
177
create table t1 (a int key) engine=ndb;
178
insert into t1 values(1);
179
rename table t1 to t2;
180
insert into t2 values(2);
182
show binlog events from <binlog_start>;
183
Log_name Pos Event_type Server_id End_log_pos Info
184
mysqld-bin.000001 # Query 2 # use `test`; create table t1 (a int key) engine=ndb
185
mysqld-bin.000001 # Query 2 # BEGIN
186
mysqld-bin.000001 # Table_map 2 # table_id: # (test.t1)
187
mysqld-bin.000001 # Table_map 2 # table_id: # (mysql.ndb_apply_status)
188
mysqld-bin.000001 # Write_rows 2 # table_id: #
189
mysqld-bin.000001 # Write_rows 2 # table_id: # flags: STMT_END_F
190
mysqld-bin.000001 # Query 2 # COMMIT
191
mysqld-bin.000001 # Query 2 # use `test`; rename table `test`.`t1` to `test`.`t2`
192
mysqld-bin.000001 # Query 2 # BEGIN
193
mysqld-bin.000001 # Table_map 2 # table_id: # (test.t2)
194
mysqld-bin.000001 # Table_map 2 # table_id: # (mysql.ndb_apply_status)
195
mysqld-bin.000001 # Write_rows 2 # table_id: #
196
mysqld-bin.000001 # Write_rows 2 # table_id: # flags: STMT_END_F
197
mysqld-bin.000001 # Query 2 # COMMIT
198
mysqld-bin.000001 # Query 2 # use `test`; DROP TABLE `t2` /* generated by server */