[rt-users] MySQL Key Buffer size

[Mahoney, Tim]

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.
 

Thanks
Tim Mahoney
Win Svr 2003 / RT 3.0.12 / Apache 1.33 / Perl 5.8.6 / MySQL 4.1.18

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20050915/490cc41b/attachment.htm>