On Tue, Dec 16, 2003 at 10:38:14AM -0600, Dan Nelson wrote :
> In the last episode (Dec 16), Markus Fischer said:
> > I'm investigating a performance problem with mysql server set up. The
> > server is running linux with 1GB ram. I'ld like to tune the
> > configuration of the server to use as much RAM as possible without
> > swapping to the disc because of the big slow down.
> > [mysqld]
> > set-variable = key_buffer=16M
> Way too low; this says "only cache 16MB of index data". Try 256MB.
> > set-variable = max_allowed_packet=200M
> Probably way too high, but doesn't hurt since it won't actually
> allocate that much memory unless you have a 200MB field someplace.
Thanks for pointing this out. I've compensated max_allowed_packet
and increased the key_buffer.
> > I'm also not sure whether the database is swapping temporary tables
> > to the disc or not; is there a way to verify if this is happening?
> show status like 'created_tmp%';
> Raising sort_buffer_size and join_buffer_size may also help if your
> queries pull a lot of records.
From what I read from the manual, sort_buffer_size is only used for
the isamchk tools, isn't it? I've adapted join_buffer_size though;