InnoDB Log File Size [Solved]

[spiderpig]

Hi,

after upgrade to 5.0.3 I'm getting this flag in the system log

"InnoDB Log File Size (5 MB)
The setting innodb_log_file_size must be at least 256 MB"

Is it enough to add this line to my.cnf and restart the mysql?
innodb_log_file_size = 256M

[root]

You have to remove the existing InnoDB logfiles and then restart mysql.

[spiderpig]

ooo, after that I can not connect to the database.

[RStraub]

What does the log say when you startup the db ?

[root]

ooo, after that I can not connect to the database.

Which files did you remove?

[spiderpig]

I stopped the mysqld service,then I insert the "innodb_log_file_size=256M" to my.cnf.
deleted ib_logdile0 and ib_logfile_1 and then started the mysqld service.

what am I doing wrong here?

[RStraub]

This looks good but then again - did you take a look into the mysql log?

[spiderpig]

the log in now about 700 mb and is increasing by every second, and I cant open the file. Fortunately this was only a test test server.
i will clone the live environment again and try this again.

[RStraub]

Then stop the process, delete the logfile, start the DB and tail the log.

[EXG133]

You may need an additional step depending on the version of your MySQL:

http://dev.mysql.com/doc/refman/5.6/en/ ... ation.html

Also make sure you put the setting in the correct part of your my.cnf, it should be in the [mysqld] part

You also *need* to:

1) stop the service (with the extra setting if you have an old MySQL)
2) optional if your version is older: move the logfiles somewhere
3) modify your my.cnf
4) start your service

No restarting.

[spiderpig]

I followed that steps and it worked for me on the test environment

OTRS is more responsive after I increase the log file.
do you recommend to change it to 256 or 512?