InnoDB: Running in read-only mode 问题排查

排查方法

1：/var/lib/mysql 文件权限设置

I just encountered a similar problem on one of my production servers
this morning. (I'm still investigating the cause.) After doing a
quick bit of Google-searching, this solved my problem:

mysqladmin -u <username> -p flush-tables

By the way: All directories in /var/lib/mysql should have 700
permissions (owned my the mysql user) and everything within those
directories should be 660 (owned by the mysql user and mysql group).

运行flush-tables后，read only问题解决：）

2：/etc/my.cnf 文件配置

#直接设置数据库的可读性
read_only=0
#在mysql中innodb_force_recovery参数是用来恢复数据库使用的 掉电恢复时会将innodb设为只读
innodb_force_recovery=0