2
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
5
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
8
create table t1(a int) engine=InnoDB;
9
create table t2(a int) engine=MyISAM;
10
insert into t1 values(1001);
11
insert into t2 values(2001);
12
set global read_only=1;
31
set global read_only=0;
33
insert into t1 values(1002);
34
insert into t2 values(2002);
36
insert into t1 values(1003);
37
insert into t2 values(2003);
38
set global read_only=1;
41
ERROR HY000: The MySQL server is running with the --read-only option so it cannot execute this statement
42
set global read_only=0;
43
insert into t1 values(1004);
44
insert into t2 values(2004);
67
set global read_only=1;
73
t1 CREATE TABLE `t1` (
74
`a` int(11) DEFAULT NULL
75
) ENGINE=InnoDB DEFAULT CHARSET=latin1
78
t2 CREATE TABLE `t2` (
79
`a` int(11) DEFAULT NULL
80
) ENGINE=MyISAM DEFAULT CHARSET=latin1
81
insert into t1 values(1005);
82
insert into t2 values(2005);
109
insert into t1 values(1006);
110
ERROR HY000: The MySQL server is running with the --read-only option so it cannot execute this statement
111
insert into t2 values(2006);
112
ERROR HY000: The MySQL server is running with the --read-only option so it cannot execute this statement
116
set global read_only=0;