rpl_init_slave.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;
- show variables like 'init_slave';
- Variable_name Value
- init_slave set global max_connections=500
- show variables like 'max_connections';
- Variable_name Value
- max_connections 500
- reset master;
- show variables like 'init_slave';
- Variable_name Value
- init_slave
- show variables like 'max_connections';
- Variable_name Value
- max_connections 100
- set global init_connect="set @c=1";
- show variables like 'init_connect';
- Variable_name Value
- init_connect set @c=1
- stop slave;