Fixing “InnoDB: Error: log file ./ib_logfile0 is of different size” Error
来源:互联网 发布:汉朝 唐朝 知乎 编辑:程序博客网 时间:2024/06/04 22:19
So you wanted to change the value of “innodb_log_file_size” on your mysql server.
As it happens, you can’t just change it the “my.cnf” file, restart and make it work. If you do, Mysql will refuse to start and throw this error instead. You can the details of the startup error in your mysql error log file.
To safely change this setting follow these steps
- Shutdown your mysql server, make sure to check the error log that the shutdown had no issues
- Move the “ib_logfile0″ and “ib_logfile1″ files from your mysql data directory.
- Change “innodb_log_file_size” to your desired setting.
- Restart mysql. Check the error log to make sure everything started successfully, mysql may complain that the log files don’t exist, it will make new ones and start.
Make sure if you are changing things on a production server, you take due care of the mysql downtime due to the changes and restart, and have backups to recover quickly in case something goes wrong.
0 0
- Fixing “InnoDB: Error: log file ./ib_logfile0 is of different size” Error
- Mysql启动中 InnoDB: Error: log file ./ib_logfile0 is of different size 0
- InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes
- InnoDB: Error: log file /home/mysqldata/ib_logfile0 is of different size
- Mysql启动中 InnoDB: Error: log file ./ib_logfile0 is of different size 0
- InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
- InnoDB: Error: log file ./ib_logfile0 is of different size 50331648 bytes
- xtrabackup 恢复出现错误InnoDB: Error: log file ./ib_logfile2 is of different size 0 0 bytes
- [ERROR] InnoDB: Data file /data/mysql/3310/data/ibdata1 is of a different size 1536 pages
- mysqld_safe 启动、usr/local/mysql/data/ib_logfile0 is of different size ...的错误
- InnoDB: The Auto-extending innodb_system data file './ibdata1' is of a different size 640 pages
- Fixing an "SQL0964C Transaction log for database is full" error
- InnoDB: ERROR: the age of the last checkpoint is
- [ERROR] Table gym_api_utf8/membership_students contains 2 indexes inside InnoDB, which is different
- 备忘:编译Apache的configure: error: Size of "void *" is less than size of "long"错误
- 编译httpd的configure: error: Size of "void *" is less than size of "long"
- configure: error: Size of "void *" is less than size of "long"
- The count of VLFs for different size of transaction log
- ubuntu下安装Apache+PHP+Mysql
- PostgreSQL 连接问题 FATAL: no pg_hba.conf entry for host
- linux 路由表 配置
- 安装postgresql时出现的问题
- android.annotation.SuppressLint
- Fixing “InnoDB: Error: log file ./ib_logfile0 is of different size” Error
- [Android]高低API版本兼容之@TargetApi
- 嵌入式flash编码器与Flash Media对接
- 附加数据库出现拒绝方法的系统错误,错误代码5120的解决方法
- ARM汇编之寄存器
- 解决#号做为参数传递的时候获取不到的情况
- ios 实现版本更新检查
- 数据库优化实践【MS SQL优化开篇】
- 初创小公司如何拿下第一批客户