Innodb_log_size help

[romerosantos02]

I've tried several times to install it to see if my "my.cnf" would appear to change the innodb_log_file_size, I've already researched a number of sites, so the innodb field usually appears. But mine only appears that this default with 10 mb. Thanks for helping out.
https://ap.imagensbrasil.org/image/puVNiY

[RStraub]

You have to:
- Shutdown / Stop MySQL
- Edit the setting for the file-size
- Remove or rename the old files (very important!)
- Startup MySQL

The new files then are autogenerated in the configured size.

[romerosantos02]

Sorry but I am new to otrs, which configuration file should I modify and where does it stay and which remove and rename

[root]

This is a MySQL topic, ask your DB if you're unsure.

[RStraub]

This might help you

http://stackoverflow.com/questions/1991 ... -file-size

[romerosantos02]

I make all steps but on my.cnf no have line Inno_db for change values :/

[romerosantos02]

I make all steps but on my.cnf no have line Inno_db for change values :/

[RStraub]

Then add one

Code: Select all

innodb_log_file_size=256M

[romerosantos02]

Wow, man thanks,Did not know could add rows on the my.cnf thanks again.