How To Update the innodb_log_file_size Setting in MySQL
erics, Posted October 29th, 2014 at 7:09:40pm
[root@db1 ~]# service mysqld stop
[root@db1 ~]# cd /var/lib/mysql
[root@db1 mysql]# ls -l ib_logfile?
-rw-rw---- 1 mysql mysql 5242880 Oct 29 23:00 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 Oct 29 22:38 ib_logfile1
[root@db1 mysql]# mv ib_logfile0 ib_logfile0.old
[root@db1 mysql]# mv ib_logfile1 ib_logfile1.old
[root@db1 ~]# vi /etc/my.cnf
innodb_log_file_size=64M
# comment out the old value, if one exists
#innodb_log_file_size=128M
[root@db1 ~]# service mysqld start
For advice on how to calculate a proper innodb_log_file_size for your environment, see the following article by Percona…
http://www.percona.com/blog/2008/11/21/how-to-calculate-a-good-innodb-log-file-size/
Categories: How-To's, Technology Change, howto, InnoDB, innodb_log_file_size, my.cnf, mysql, Percona, tips, update
Leave Your Comment
All fields marked with "*" are required.