MySQL Forums :: InnoDB :: Can't change innodb_log_file_size


Advanced Search

Re: Can't change innodb_log_file_size
Posted by: Aftab Khan ()
Date: January 11, 2010 07:57AM

If you modify the innodb_log_file_size, MySQL will fail to restart and InnoDB will complain about the size of the changed log file.

The proper way to increase the innodb_log_file_size:
- shutdown mysql server
- make backup of log files
- remove InnoDB log files
- set new value for innodb_log_file_size in my.cnf [ you have already done that]
- start mysqld
- check error logs to ensure everything went fine.

Steps to be followed:

- shutdown mysql server e.g. /etc/init.d/mysql stop
- rename innodb log files e.g.
mv /var/lib/mysql/ib_logfile0 /var/lib/mysql/ib_logfile0_bk
mv /var/libmysql/ib_logfile1 /var/lib/mysql/ib_logfile1_bk
- start mysql e.g. /etc/init.d/mysql start

--assuming datadir path is /var/lib/mysql

Options: ReplyQuote


Subject Views Written By Posted
Can't change innodb_log_file_size 4134 Stephan Craft 01/10/2010 08:29AM
Re: Can't change innodb_log_file_size 3291 Aftab Khan 01/11/2010 07:57AM
Re: Can't change innodb_log_file_size 1410 Stephan Craft 01/11/2010 08:13AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.