MySQL Forums
Forum List  »  Newbie

Re: Simple UPDATE query takes too much time in InnoDB than MyISAM
Posted by: Atul Patil
Date: June 02, 2015 10:25PM

Ok. I found the issue was here in my.ini (which can be located in C:\ProgramData\MySQL\MySQL Server 5.6 or similar folder based on installation)

There is parameter innodb_flush_log_at_trx_commit which has value defaulted to zero causing 1 MB of innodb_log_buffer_size to be written to disk at each commit. This was resulting in major performance penalty.

So I made innodb_flush_log_at_trx_commit=2 after reading its description and then restarted MySQL server, then performance boosted a lot.

Options: ReplyQuote


Subject
Written By
Posted
Re: Simple UPDATE query takes too much time in InnoDB than MyISAM
June 02, 2015 10:25PM


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.