innodb_system

The innodb_system data file 'ibdata1' must be writable

MySQL无法启动 Active: deactivating (stop-sigterm) (Result: exit-code) 查看配置文件中的日志存储位置: view /etc/my.cnf 查看日志存储文件位置:/var/log/mysqld.log 文件错误提示:The innodb_sy ......
innodb_system writable ibdata1 innodb ibdata

[ERROR] [MY-012263] [InnoDB] The Auto-extending innodb_system data file './ibdata1' is of a different sizethan specified in the .cnf file: initial 65536 pages, max 0 (relevant if non-zero) pages!

实际my.cnf发现里面的innodb_data_file_path = ibdata1:1G:autoextend 设置得太大,我这机器容量小,所以调到12M , innodb_data_file_path = ibdata1:12M:autoextend ......

Tablespace 'innodb_system' Page [page id: space=0, page number=5] log sequence number 2243306228 is in the future! Current system log sequence number 2243305813.

场景: 这几天在外面实习,老师的项目数据库崩了让我看,连着两条看到十一二点,哎。 主要场景是mysql突然崩溃,发现重启mysqld服务无效,重启系统无效。查看/var/log/mysql.log日志,看到以下内容: The manual page at http://dev.mysql.com/d ......
number sequence system page innodb_system
共3篇  :1/1页 首页上一页1下一页尾页