Issue changing innodb_log_file_size
Posted
by
savageguy
on Stack Overflow
See other posts from Stack Overflow
or by savageguy
Published on 2009-08-13T16:14:39Z
Indexed on
2012/04/08
11:29 UTC
Read the original article
Hit count: 185
I haven't done much tweaking in the past so this might be relatively easy however I am running into issues. This is what I do:
- Stop MySQL
- Edit my.cnf (changing
innodb_log_file_size) - Remove ib_logfile0/1
- Start MySQL
Starts fine however all InnoDB tables have the .frm file is invalid error, the status shows InnoDB engine is disabled so I obviously go back, remove the change and everything works again.
I was able to change every other variable I've tried but I can't seem to find out why InnoDB fails to start even after removing the log files. Am I missing something?
Thanks.
Edit: Pasting of the log below - looks like it still seems to find the log file even though they are not there?
Shutdown:
090813 10:00:14 InnoDB: Starting shutdown...
090813 10:00:17 InnoDB: Shutdown completed; log sequence number 0 739268981
090813 10:00:17 [Note] /usr/sbin/mysqld: Shutdown complete
Startup after making the changes:
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 268435456 bytes!
090813 11:00:18 [Warning] 'user' entry '[email protected]' ignored in --skip-name-resolve mode.
090813 11:00:18 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.81-community-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Edition (GPL)
090813 11:00:19 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './XXXX/User.frm'
090813 11:00:19 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './XXXX/User.frm'
090813 11:00:19 [ERROR] /usr/sbin/mysqld: Incorrect information in file: './XXXX/User.frm'
Its just a spam of the same error until I correct it
When it did start after it recreated the log files so it must be looking in the same spot I am.
© Stack Overflow or respective owner
