MySQL configuration option

  • Affected Version
    WoltLab Suite 3.1

    I got this on my ACP how can I set to 2 thanks

    The MySQL configuration option “innodb_flush_log_at_trx_commit” is set to “1”, slowing down certain database queries. It is highly recommended to set its value to “2”.

  • For most forums, a value of 1 is absolutely fine. In some cases (e.g. data import), a value of 2 can speed up the process. But when setting this to 2, there's a minimal risk of data loss.

    However, if you don't know how to change it, just ignore that message.