MySQL Forums
Forum List  »  InnoDB

MySQL InnoDB performance tuning
Posted by: Jim Goh
Date: June 15, 2011 04:45PM


We recently updated our Solaris 10 (Sparc) patch level. It is from:

Solaris 10 8/07 s10s_u4wos_12b SPARC
Patch level 137111-05


Solaris 10 10/09 s10s_u8wos_08a SPARC
Patch level 144488-14

We have two functions in MySQL uses InnoDB. In the old version of Solaris 10 (8/07), one function takes less than 1 sec to finish execute.

However in the newer version of Solaris 10 (10/09). It takes about 40 secs to finish execute.

So, we found one solution in google that said to change the innodb_flush_log_at_trx_commit to 0 instead of default 1, then the function take only about 0.41 sec to finish execute.

So does anyone know that we did the newer version of Solaris (update 8) has changed that I need to change this innodb_flush_log_at_commit to make better performance.


Options: ReplyQuote

Written By
MySQL InnoDB performance tuning
June 15, 2011 04:45PM
June 16, 2011 10:48PM
June 17, 2011 10:04AM
June 17, 2011 12:06PM

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.