English
rpl_master_pos_wait.result
上传用户：romrleung
上传日期：2022-05-23
资源大小：18897k
文件大小：1k
源码类别：
MySQL数据库
开发平台：
Visual C++
- stop slave;
- drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
- reset master;
- reset slave;
- drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
- start slave;
- select master_pos_wait('master-bin.999999',0,2);
- master_pos_wait('master-bin.999999',0,2)
- -1
- explain extended select master_pos_wait('master-bin.999999',0,2);
- id select_type table type possible_keys key key_len ref rows Extra
- 1 SIMPLE NULL NULL NULL NULL NULL NULL NULL No tables used
- Warnings:
- Note 1003 select sql_no_cache master_pos_wait(_latin1'master-bin.999999',0,2) AS `master_pos_wait('master-bin.999999',0,2)`
- select master_pos_wait('master-bin.999999',0);
- stop slave sql_thread;
- master_pos_wait('master-bin.999999',0)
- NULL
