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.
Win Svr 2003 / RT 3.0.12 / Apache 1.33 / Perl 5.8.6 / MySQL 4.1.18