📄 ndb_binlog_ddl_multi.result

📁 开启mysql的远程连接的方法 mysql-noinstall-5.1.6-alpha-win32.zip
💻 RESULT
字号:
drop database if exists mysqltest;drop table if exists t1,t2;drop database if exists mysqltest;drop table if exists t1,t2;reset master;reset master;create database mysqltest;use mysqltest;create table t1 (a int primary key) engine=ndb;create table t2 (a int primary key) engine=ndb;show binlog events from 102;Log_name	Pos	Event_type	Server_id	End_log_pos	Infomaster-bin1.000001	#	Query	#	#	create database mysqltestmaster-bin1.000001	#	Query	#	#	use `mysqltest`; create table t1 (a int primary key) engine=ndbmaster-bin1.000001	#	Query	#	#	use `test`; create table t2 (a int primary key) engine=ndbshow binlog events from 102;Log_name	Pos	Event_type	Server_id	End_log_pos	Infomaster-bin.000001	#	Query	#	#	create database mysqltestmaster-bin.000001	#	Query	#	#	use `mysqltest`; create table t1 (a int primary key) engine=ndbmaster-bin.000001	#	Query	#	#	use `test`; create table t2 (a int primary key) engine=ndbreset master;reset master;alter table t2 add column (b int);show binlog events from 102;Log_name	Pos	Event_type	Server_id	End_log_pos	Infomaster-bin1.000001	#	Query	#	#	BEGINmaster-bin1.000001	#	Table_map	#	#	cluster_replication.apply_statusmaster-bin1.000001	#	Write_rows	#	#	master-bin1.000001	#	Query	#	#	COMMITmaster-bin1.000001	#	Query	#	#	use `test`; alter table t2 add column (b int)reset master;reset master;ALTER DATABASE mysqltest CHARACTER SET latin1;drop table mysqltest.t1;show binlog events from 102;Log_name	Pos	Event_type	Server_id	End_log_pos	Infomaster-bin.000001	#	Query	#	#	ALTER DATABASE mysqltest CHARACTER SET latin1master-bin.000001	#	Query	#	#	BEGINmaster-bin.000001	#	Table_map	#	#	cluster_replication.apply_statusmaster-bin.000001	#	Write_rows	#	#	master-bin.000001	#	Query	#	#	COMMITmaster-bin.000001	#	Query	#	#	use `mysqltest`; drop table `t1`reset master;reset master;use test;insert into t2 values (1,2);drop database mysqltest;create table t1 (a int primary key) engine=ndb;show binlog events from 102;Log_name	Pos	Event_type	Server_id	End_log_pos	Infomaster-bin1.000001	#	Query	#	#	BEGINmaster-bin1.000001	#	Table_map	#	#	cluster_replication.apply_statusmaster-bin1.000001	#	Write_rows	#	#	master-bin1.000001	#	Table_map	#	#	test.t2master-bin1.000001	#	Write_rows	#	#	master-bin1.000001	#	Query	#	#	COMMITmaster-bin1.000001	#	Query	#	#	drop database mysqltestmaster-bin1.000001	#	Query	#	#	use `test`; create table t1 (a int primary key) engine=ndbdrop table t2;reset master;reset master;CREATE LOGFILE GROUP lg1ADD UNDOFILE 'undofile.dat'INITIAL_SIZE 16MUNDO_BUFFER_SIZE = 1MENGINE=NDB;ALTER LOGFILE GROUP lg1ADD UNDOFILE 'undofile02.dat'INITIAL_SIZE = 4M ENGINE=NDB;CREATE TABLESPACE ts1ADD DATAFILE 'datafile.dat'USE LOGFILE GROUP lg1INITIAL_SIZE 12MENGINE NDB;ALTER TABLESPACE ts1ADD DATAFILE 'datafile02.dat'INITIAL_SIZE = 4M ENGINE=NDB;ALTER TABLESPACE ts1 DROP DATAFILE 'datafile.dat' ENGINE = NDB;ALTER TABLESPACE ts1 DROP DATAFILE 'datafile02.dat' ENGINE = NDB;DROP TABLESPACE ts1 ENGINE = NDB;DROP LOGFILE GROUP lg1 ENGINE =NDB;drop table t1;show binlog events from 102;Log_name	Pos	Event_type	Server_id	End_log_pos	Infomaster-bin1.000001	#	Query	#	#	CREATE LOGFILE GROUP lg1ADD UNDOFILE 'undofile.dat'INITIAL_SIZE 16MUNDO_BUFFER_SIZE = 1MENGINE=NDBmaster-bin1.000001	#	Query	#	#	ALTER LOGFILE GROUP lg1ADD UNDOFILE 'undofile02.dat'INITIAL_SIZE = 4M ENGINE=NDBmaster-bin1.000001	#	Query	#	#	CREATE TABLESPACE ts1ADD DATAFILE 'datafile.dat'USE LOGFILE GROUP lg1INITIAL_SIZE 12MENGINE NDBmaster-bin1.000001	#	Query	#	#	ALTER TABLESPACE ts1ADD DATAFILE 'datafile02.dat'INITIAL_SIZE = 4M ENGINE=NDBmaster-bin1.000001	#	Query	#	#	ALTER TABLESPACE ts1 DROP DATAFILE 'datafile.dat' ENGINE = NDBmaster-bin1.000001	#	Query	#	#	ALTER TABLESPACE ts1 DROP DATAFILE 'datafile02.dat' ENGINE = NDBmaster-bin1.000001	#	Query	#	#	DROP TABLESPACE ts1 ENGINE = NDBmaster-bin1.000001	#	Query	#	#	DROP LOGFILE GROUP lg1 ENGINE =NDBmaster-bin1.000001	#	Query	#	#	BEGINmaster-bin1.000001	#	Table_map	#	#	cluster_replication.apply_statusmaster-bin1.000001	#	Write_rows	#	#	master-bin1.000001	#	Query	#	#	COMMITmaster-bin1.000001	#	Query	#	#	use `test`; drop table `t1`
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -