MySQL InnoDB performance tuning

[Jim Goh]

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!