| Server IP : 45.40.142.9 / Your IP : 216.73.216.250 Web Server : Apache System : Linux s45-40-142-9.secureserver.net 2.6.32-754.35.1.el6.x86_64 #1 SMP Sat Nov 7 12:42:14 UTC 2020 x86_64 User : bayspec ( 506) PHP Version : 5.6.40 Disable Function : NONE MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/share/mysql-test/suite/ndb_binlog/r/ |
Upload File : |
drop table if exists t1,t2,t3; reset master; drop table if exists t1,t2,t3; reset master; set SQL_LOG_BIN=0; create database mysqltest; use mysqltest; create table t1 (a int key, b int) engine=ndb; create table t2 (a int key, b int) engine=ndb; insert into t1 values (1,1); alter table t1 add c int; Warnings: Warning 1478 Converted FIXED field to DYNAMIC to enable on-line ADD COLUMN show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info reset master; use mysqltest; insert into t2 values (1,1); show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info mysqld-bin.000001 # Query 2 # BEGIN mysqld-bin.000001 # Table_map 2 # table_id: # (mysqltest.t2) mysqld-bin.000001 # Table_map 2 # table_id: # (mysql.ndb_apply_status) mysqld-bin.000001 # Write_rows 2 # table_id: # mysqld-bin.000001 # Write_rows 2 # table_id: # flags: STMT_END_F mysqld-bin.000001 # Query 2 # COMMIT reset master; use mysqltest; drop table t1; drop table t2; create table t1 (d int key, e int) engine=ndb; create table t2 (d int key, e int) engine=ndb; insert into t1 values (1,1); show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info mysqld-bin.000001 # Query 1 # BEGIN mysqld-bin.000001 # Table_map 1 # table_id: # (mysqltest.t2) mysqld-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status) mysqld-bin.000001 # Write_rows 1 # table_id: # mysqld-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F mysqld-bin.000001 # Query 1 # COMMIT mysqld-bin.000001 # Query 1 # use `mysqltest`; DROP TABLE `t1` /* generated by server */ mysqld-bin.000001 # Query 1 # use `mysqltest`; DROP TABLE `t2` /* generated by server */ mysqld-bin.000001 # Query 1 # use `mysqltest`; create table t1 (d int key, e int) engine=ndb mysqld-bin.000001 # Query 1 # use `mysqltest`; create table t2 (d int key, e int) engine=ndb mysqld-bin.000001 # Query 1 # BEGIN mysqld-bin.000001 # Table_map 1 # table_id: # (mysqltest.t1) mysqld-bin.000001 # Table_map 1 # table_id: # (mysql.ndb_apply_status) mysqld-bin.000001 # Write_rows 1 # table_id: # mysqld-bin.000001 # Write_rows 1 # table_id: # flags: STMT_END_F mysqld-bin.000001 # Query 1 # COMMIT use mysqltest; insert into t2 values (1,1); show binlog events from <binlog_start>; Log_name Pos Event_type Server_id End_log_pos Info mysqld-bin.000001 # Query 2 # use `mysqltest`; drop table `mysqltest`.`t1` mysqld-bin.000001 # Query 2 # use `mysqltest`; drop table `mysqltest`.`t2` mysqld-bin.000001 # Query 2 # use `mysqltest`; create table t1 (d int key, e int) engine=ndb mysqld-bin.000001 # Query 2 # use `mysqltest`; create table t2 (d int key, e int) engine=ndb mysqld-bin.000001 # Query 2 # BEGIN mysqld-bin.000001 # Table_map 2 # table_id: # (mysqltest.t1) mysqld-bin.000001 # Table_map 2 # table_id: # (mysql.ndb_apply_status) mysqld-bin.000001 # Write_rows 2 # table_id: # mysqld-bin.000001 # Write_rows 2 # table_id: # flags: STMT_END_F mysqld-bin.000001 # Query 2 # COMMIT mysqld-bin.000001 # Query 2 # BEGIN mysqld-bin.000001 # Table_map 2 # table_id: # (mysqltest.t2) mysqld-bin.000001 # Table_map 2 # table_id: # (mysql.ndb_apply_status) mysqld-bin.000001 # Write_rows 2 # table_id: # mysqld-bin.000001 # Write_rows 2 # table_id: # flags: STMT_END_F mysqld-bin.000001 # Query 2 # COMMIT drop database mysqltest;