3
File Position Binlog_Do_DB Binlog_Ignore_DB
4
master-bin.000001 # <Binlog_Do_DB> <Binlog_Ignore_DB>
7
change master to master_host='127.0.0.1';
24
Replicate_Ignore_Table #
25
Replicate_Wild_Do_Table
26
Replicate_Wild_Ignore_Table
41
Seconds_Behind_Master #
42
Master_SSL_Verify_Server_Cert No
47
change master to master_host='127.0.0.1',master_user='root',
48
master_password='',master_port=MASTER_PORT;
53
Master_Port MASTER_PORT
65
Replicate_Ignore_Table #
66
Replicate_Wild_Do_Table
67
Replicate_Wild_Ignore_Table
82
Seconds_Behind_Master #
83
Master_SSL_Verify_Server_Cert No
93
Master_Port MASTER_PORT
95
Master_Log_File master-bin.000001
99
Relay_Master_Log_File master-bin.000001
101
Slave_SQL_Running Yes
105
Replicate_Ignore_Table #
106
Replicate_Wild_Do_Table
107
Replicate_Wild_Ignore_Table
111
Exec_Master_Log_Pos #
116
Master_SSL_Allowed No
122
Seconds_Behind_Master #
123
Master_SSL_Verify_Server_Cert No
128
drop table if exists t1;
129
create table t1 (n int, PRIMARY KEY(n));
130
insert into t1 values (10),(45),(90);
131
SELECT * FROM t1 ORDER BY n;
136
SELECT * FROM t1 ORDER BY n;