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