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;
thanks.
- Markus

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.