[rt-users] [repost] Performance-Bug in SelfService when updated from 3.6.1 to 3.6.3

[Gilmar Santos Jr]

Hi Torsten,

I think these parameter are most important:

key_buffer          =  16M
join_buffer_size    =  32M
innodb_buffer_pool_size =  256M
innodb_log_buffer_size  =   32M
innodb_log_file_size    =  128M


The last 2 affects the recovery time and write speed. Higher values provides 
better writing performance and greater crash recovery times.

Maybe you will have problems if you modify "innodb_log_file_size". I had to stop 
the server, change the configuration, remove the ib_log* files and start the 
server again. Sometimes, according to some docs, it doesn't work...

You can try at least 2 GB to "innodb_buffer_pool_size". MySQL save some useful 
information about innodb. The less "page faults" the better performance ;)

Good luck,

--
Gilmar Santos Jr

Torsten Brumm escreveu:
> Hi Gilmar,
> 
> i'm playing around with this buffers since some months without finding a 
> good solution, can you give me a hint about yours??
> 
> We have 4GB RAM at the DB Server.
> 
> Thanks Torsten
> 
> 2007/1/28, Gilmar Santos Jr <gilmarsantosjr at safernet.org.br 
> <mailto:gilmarsantosjr at safernet.org.br>>:
> 
>     Dirk Pape escreveu:
>      > [...]
>      > If the latter, does anybody have a hint where to dig into?
> 
>     Try to increase "innodb_buffer_pool_size" in my.cnf. See [1], [2] and
>     [3]. Tunning some parameters like "join_buffer_size",
>     "innodb_buffer_pool_size" and some others gave me a huge performance
>     improvement. Take care of available RAM to avoid swapping.
> 
>     1 - http://dev.mysql.com/doc/refman/4.1/en/innodb-configuration.html
>     2 - http://dev.mysql.com/doc/refman/4.1/en/innodb-tuning.html
>     3 - http://wiki.bestpractical.com/index.cgi?PerformanceTuning
> 
>     --
>     Gilmar Santos Jr
>     _______________________________________________
>     http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
>     Community help: http://wiki.bestpractical.com
>     Commercial support: sales at bestpractical.com
>     <mailto:sales at bestpractical.com>
> 
> 
>     Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
>     Buy a copy at http://rtbook.bestpractical.com
> 
> 
> 
> 
> -- 
> MFG
> 
> Torsten Brumm
> 
> http://www.torsten-brumm.de