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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
