mysql的日志参数修改的问题.
mysql,修改了配置文件,增加了日志文件的参数innodb_log_file_size
大小.
结果,在每次启动数据时,报:
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 52428800 bytes!
结果,直接关闭数据库,删除这两个日志文件,系统就正常了.日志如下:
080707 14:23:02 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 50 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
看来,mysql的日志作用比起oracle(至少它的不能随便删除)来,还是差一些.
[@more@]来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/197458/viewspace-1006900/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量152
-
访问量724077
最新文章
- hadoop 代码编译 mvn报错 Unsupported major.minor version 51.0
- windows 根据标题，关闭进程
- expdp ORA-31637 ORA-06512 ORA-39080 ORA-00832
- grant debug connect session to db_test;
- 11g 启用或关闭自动统计任务
- ORA-600 [kkopmCheckSmbUpdate:2] or [kkopmCheckSmbUpdate:3]
- sqlserver 2005 安装注意事项
- http://www.tianya.cn/publicforum/content/no11/1/1136654.shtml
- 修改上传文件大小
- oracle bulk collects 之 java select
