set global read_only=0; 关闭只读,可以读写 set global read_only=1; 开始只读模式

来源:互联网 发布:去网吧带windows to go 编辑:程序博客网 时间:2024/05/29 04:03
mysql> set global read_only=0;Query OK, 0 rows affected (0.00 sec)mysql> show variables like '%read_only%';+------------------+-------+| Variable_name    | Value |+------------------+-------+| innodb_read_only | OFF   || read_only        | OFF   || tx_read_only     | OFF   |+------------------+-------+3 rows in set (0.00 sec)mysql> set global read_only=1;Query OK, 0 rows affected (0.00 sec)mysql> show variables like '%read_only%';+------------------+-------+| Variable_name    | Value |+------------------+-------+| innodb_read_only | OFF   || read_only        | ON    || tx_read_only     | OFF   |+------------------+-------+3 rows in set (0.00 sec)set global read_only=0;  关闭只读,可以读写 set global read_only=1; 开始只读模式

0 0
原创粉丝点击