<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1505" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=083350521-15092005><FONT face=Arial size=2>What size buffer
does everyone find works best for them. We currently have a 300Mb DB with
about 10K tickets. Our Key buffer is set to 256 Meg and so is the InnoDB
buffer pool. Currently the key buffer is utilizing 44k. The InnoDB
buffer pool shows to be using 16k. If I set these two to 32Mb, how will
this affect our performance? On the server it'll free up boatloads of RAM,
but will the RT users suffer? I don't think so. I think the setup we
used was way overkill.</FONT></SPAN></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV>
<P align=left><FONT size=2>Thanks<BR>Tim Mahoney<BR>Win Svr 2003 / RT 3.0.12 /
Apache 1.33 / Perl 5.8.6 / MySQL 4.1.18</FONT></P>
<P align=left><FONT size=2></FONT></P><FONT face=Arial
size=2></FONT></DIV></BODY></HTML>