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@]