If it's a dedicated MySQL server I would increase the key buffer to at least half the available main memory and leave the rest for filesystem cache. You'll probably get the biggest performance increase this way.
Cheers, A -----Original Message----- From: sangprabv [mailto:sangpr...@gmail.com] Sent: 06 October 2009 04:57 To: Rob Wultsch Cc: mysql@lists.mysql.com Subject: Re: Optimizing my.cnf As you see on my my.cnf I skip innodb and federated. So I just use myisam in this case. TIA. Willy On Mon, 2009-10-05 at 20:47 -0700, Rob Wultsch wrote: > > On Mon, Oct 5, 2009 at 6:12 PM, sangprabv <sangpr...@gmail.com> wrote: > I have Dell PE2950iii with 16GB of RAM, and 1 Quadcore > processor @2.00G. > Installed with MySQL 5.075 on 64bit Ubuntu Jaunty. I have > these > parameters in my.cnf: > > blah blah blah... > > > This heavily depends on workload. Are you using innodb? etc... > > -- > Rob Wultsch > wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=andrew.braithwa...@lovefilm.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
