Debian Codegraph @

mysql-test/suite/ndb_rpl/r/ndb_rpl_dd_basic.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 DROP TABLE IF EXISTS t1;
7 CREATE LOGFILE GROUP lg1
8 ADD UNDOFILE 'undofile.dat'
9 INITIAL_SIZE 16M
10 UNDO_BUFFER_SIZE = 1M
11 ENGINE=NDB;
12 alter logfile group lg1
13 add undofile 'undofile02.dat'
14 initial_size 4M engine=ndb;
15 CREATE TABLESPACE ts1
16 ADD DATAFILE 'datafile.dat'
17 USE LOGFILE GROUP lg1
18 INITIAL_SIZE 12M
19 ENGINE NDB;
20 alter tablespace ts1
21 add datafile 'datafile02.dat'
22 initial_size 4M;
23 CREATE TABLE t1
24 (pk1 int not null primary key, b int not null, c int not null)
25 tablespace ts1 storage disk
26 engine ndb;
27 insert into t1 values (1,2,3);
28 select * from t1 order by pk1;
29 pk1 b c
30 1 2 3
31 select * from t1 order by pk1;
32 pk1 b c
33 1 2 3
34 include/show_binlog_events.inc
35 Log_name Pos Event_type Server_id End_log_pos Info
36 master-bin.000001 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by server */
37 master-bin.000001 # Query # # use `test`; CREATE LOGFILE GROUP lg1
38 ADD UNDOFILE 'undofile.dat'
39 INITIAL_SIZE 16M
40 UNDO_BUFFER_SIZE = 1M
41 ENGINE=NDB
42 master-bin.000001 # Query # # use `test`; alter logfile group lg1
43 add undofile 'undofile02.dat'
44 initial_size 4M engine=ndb
45 master-bin.000001 # Query # # use `test`; CREATE TABLESPACE ts1
46 ADD DATAFILE 'datafile.dat'
47 USE LOGFILE GROUP lg1
48 INITIAL_SIZE 12M
49 ENGINE NDB
50 master-bin.000001 # Query # # use `test`; alter tablespace ts1
51 add datafile 'datafile02.dat'
52 initial_size 4M
53 master-bin.000001 # Query # # use `test`; CREATE TABLE t1
54 (pk1 int not null primary key, b int not null, c int not null)
55 tablespace ts1 storage disk
56 engine ndb
57 master-bin.000001 # Query # # BEGIN
58 master-bin.000001 # Table_map # # table_id: # (test.t1)
59 master-bin.000001 # Table_map # # table_id: # (mysql.ndb_apply_status)
60 master-bin.000001 # Write_rows # # table_id: #
61 master-bin.000001 # Write_rows # # table_id: # flags: STMT_END_F
62 master-bin.000001 # Query # # COMMIT
63 drop table t1;
64 alter tablespace ts1
65 drop datafile 'datafile.dat';
66 alter tablespace ts1
67 drop datafile 'datafile02.dat';
68 DROP TABLESPACE ts1;
69 DROP LOGFILE GROUP lg1 ENGINE=NDB;
70 include/rpl_end.inc