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 <[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>>:
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: [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
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
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
