Hi Gilmar,<br><br>i'm playing around with this buffers since some months without finding a good solution, can you give me a hint about yours??<br><br>We have 4GB RAM at the DB Server.<br><br>Thanks Torsten<br><br><div>

<span class="gmail_quote">2007/1/28, Gilmar Santos Jr <<a href="mailto:gilmarsantosjr@safernet.org.br">gilmarsantosjr@safernet.org.br</a>>:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">

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",

<br>"innodb_buffer_pool_size" and some others gave me a huge performance<br>improvement. Take care of available RAM to avoid swapping.<br><br>1 - <a href="http://dev.mysql.com/doc/refman/4.1/en/innodb-configuration.html">

http://dev.mysql.com/doc/refman/4.1/en/innodb-configuration.html</a><br>2 - <a href="http://dev.mysql.com/doc/refman/4.1/en/innodb-tuning.html">http://dev.mysql.com/doc/refman/4.1/en/innodb-tuning.html</a><br>3 - <a href="http://wiki.bestpractical.com/index.cgi?PerformanceTuning">

http://wiki.bestpractical.com/index.cgi?PerformanceTuning</a><br><br>--<br>Gilmar Santos Jr<br>_______________________________________________<br><a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users">

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br><br>Community help: <a href="http://wiki.bestpractical.com">http://wiki.bestpractical.com</a><br>Commercial support: <a href="mailto:sales@bestpractical.com">

sales@bestpractical.com</a><br><br><br>Discover RT's hidden secrets with RT Essentials from O'Reilly Media.<br>Buy a copy at <a href="http://rtbook.bestpractical.com">http://rtbook.bestpractical.com</a><br></blockquote>

</div><br><br clear="all"><br>-- <br>MFG<br><br>Torsten Brumm<br><br><a href="http://www.torsten-brumm.de">http://www.torsten-brumm.de</a>