Debian Codegraph @

mysql-test/suite/rpl/r/rpl_show_relaylog_events.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 ==== Initialize ====
7 CREATE TABLE t1 (a INT);
8 FLUSH LOGS;
9 CREATE TABLE t2 (a INT);
10 DROP TABLE t1;
11 DROP TABLE t2;
12 include/sync_slave_sql_with_master.inc
13 ==== Test ====
14 include/show_relaylog_events.inc
15 ---- [slave] SHOW RELAYLOG EVENTS IN <FILE> FROM <POSITION> ----
16 Log_name Pos Event_type Server_id End_log_pos Info
17 slave-relay-bin.000004 # Rotate # # master-bin.000002;pos=POS
18 slave-relay-bin.000004 # Format_desc # # SERVER_VERSION, BINLOG_VERSION
19 slave-relay-bin.000004 # Rotate # # master-bin.000002;pos=POS
20 slave-relay-bin.000004 # Query # # use `test`; CREATE TABLE t2 (a INT)
21 slave-relay-bin.000004 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
22 slave-relay-bin.000004 # Query # # use `test`; DROP TABLE `t2` /* generated by server */
23 include/show_relaylog_events.inc
24 ---- [slave] SHOW RELAYLOG EVENTS IN <FILE> FROM <POSITION> LIMIT 1 ----
25 Log_name Pos Event_type Server_id End_log_pos Info
26 include/show_relaylog_events.inc
27 ---- [slave] SHOW RELAYLOG EVENTS IN <FILE> FROM <POSITION> LIMIT 1,3 ----
28 Log_name Pos Event_type Server_id End_log_pos Info
29 slave-relay-bin.000004 # Rotate # # master-bin.000002;pos=POS
30 slave-relay-bin.000004 # Format_desc # # SERVER_VERSION, BINLOG_VERSION
31 slave-relay-bin.000004 # Rotate # # master-bin.000002;pos=POS
32 include/show_relaylog_events.inc
33 ---- [slave] SHOW RELAYLOG EVENTS FROM <POSITION> ----
34 Log_name Pos Event_type Server_id End_log_pos Info
35 slave-relay-bin.000003 # Rotate # # master-bin.000002;pos=POS
36 slave-relay-bin.000003 # Rotate # # slave-relay-bin.000004;pos=POS
37 ==== Cleanup ====
38 include/rpl_end.inc