MySQL Forums :: InnoDB :: Can't change innodb_log_file_size
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
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
| 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.