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]>:
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] 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
