Question How to change 'innodb_flush_log_at_trx_commit'

[omexlu]

Hello,

Is it possible to set 'innodb_flush_log_at_trx_commit' to the value '2' within the panel?

What is the best way to do this?

 

[IgorG]

Resolved - innodb_flush_log_at_trx_commit=1

i receive from my woltlab always this warning below, how can i set alway the „innodb_flush_log_at_trx_commit“ to "2" Die MySQL-Einstellung „innodb_flush_log_at_trx_commit“ steht auf dem Wert „1“ und verursacht dadurch eine starke Verlangsamung bestimmter Datenbankabfragen. Es wird empfohlen...

talk.plesk.com

 

[omexlu]

Hi,

Can't this be set via the GUI of the panel?

Must this be done manually in the configurations?

 

[IgorG]

Must this be done manually in the configurations?

yes

 

[omexlu]

Ok, thank you.

Can you maybe say me where i can find the configuration file to put it on?
innodb_flush_log_at_trx_commit=2

And must i restart the mysql-server? For this i haven't an option under plesk to restart it.

Thank you very much.

 

[IgorG]

1. Open the /etc/mysql/my.cnf (location of my.cnf can be different, it depends on your OS ) file with any text editor.
2. Specify the innodb_flush_log_at_trx_commit=2 under [mysqld] section.
3. Save changes in a text document.
4. Restart the MySQL service to apply the changes with the command:

# service mysql restart

 

[omexlu]

Thank you, worked