Re: [gentoo-user] mysqld invoked oom-killer

[kashani]

On 7/21/2011 9:53 AM, Grant wrote:
>>         Next I'd look at tuning your Mysql config. If you've never touched
>> my.cnf, by default it's set to use 64MB IIRC. You may need to raise this to
>> get better performance. key_buffer and innodb_buffer_pool_size are the only
>> two I'd modify without knowing more.
>
> I use the default MyISAM tables and it looks like there are three
> key_buffer definitions in my.cnf.  One under [mysqld] is 16M, one
> under [isamchk] is 20M, and one under [myisamchk] is 20M.  All
> defaults.  Should I increase them all to 64M?

	You can, but [mysqld] is the only one that matters for normal 
production. Depends on the size of your data and tables, but 64M is fine 
to start. If you've got a few GB in your databases I'd go with 256-512M 
or as high as you think you can get away with.

	Any reason you're still using MyISAM tables? Innodb is almost as fast 
or much much faster than MyISAM in nearly every way these days.

kashani