MySQL Forums :: InnoDB :: MySQL InnoDB performance tuning


Advanced Search

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

Hi,

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

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

to

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.

Thanks!

Options: ReplyQuote


Subject Views Written By Posted
MySQL InnoDB performance tuning 2836 Jim Goh 06/15/2011 04:45PM
Re: MySQL InnoDB performance tuning 1445 Rick James 06/16/2011 10:48PM
Re: MySQL InnoDB performance tuning 1083 Jim Goh 06/17/2011 10:04AM
Re: MySQL InnoDB performance tuning 1474 Jim Goh 06/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.