Re: Indexing dynamics in MySQL Community Edition 5.1.34

[Simon J Mudd]

mos99@stripped (mos) writes:

> At 12:37 AM 6/25/2009, you wrote:

...

> >my.cnf based on my-huge.cnf, expanding key_buffer to 8G,
> >myisam_sort_buffer_size to 256M, and putting tmpdir on the fiber channel
> >disk.
> 
>      You mean "key_buffer_size" don't you and not "key_buffer"? If you
> are using MySQL 5.0 then the upper limit is 4gb but 5.1 allows for
> more than 4gb.

That's not entirely true. Later versions of 5.0 (above 5.0.56?) also allow
key_buffer_size to be greater than 4GB and we are using that on
several machines. Earlier versions of 5.0 did indeed have this problem.

Simon