MySQL Forums
Forum List  »  Newbie

innodb_flush_log_at_trx_commit on mySql 8
Posted by: Ron Oz
Date: June 04, 2023 02:32AM


Today I am using mySql 5.7 on windows 10 with innodb_flush_log_at_trx_commit=2.
The performance with innodb_flush_log_at_trx_commit=0 or innodb_flush_log_at_trx_commit=1 are very poor.

As I would like to upgrade to mySql 8 I started testing it on my environment and the performance were extremely poor.
It looks like innodb_flush_log_at_trx_commit=2 does not have the same impact as with mySql 5.7.

Is there another configuration I may be missing on mySql 8 that would make it behave more like 5.7 in that context?

Many thanks

Options: ReplyQuote

Written By
innodb_flush_log_at_trx_commit on mySql 8
June 04, 2023 02:32AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.