List:General Discussion« Previous MessageNext Message »
From:Markus Fischer Date:December 18 2003 8:25am
Subject:Re: Performance problems using 1GB Linux server and trying to avoid swapping
View as plain text  
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
Thread
Performance problems using 1GB Linux server and trying to avoid swappingMarkus Fischer16 Dec
  • Re: Performance problems using 1GB Linux server and trying to avoidswappingChris Nolan16 Dec
    • Re: Performance problems using 1GB Linux server and trying to avoid swappingMarkus Fischer18 Dec
  • Re: Performance problems using 1GB Linux server and trying to avoid swappingDan Nelson16 Dec
    • Re: Performance problems using 1GB Linux server and trying to avoid swappingMarkus Fischer18 Dec
      • Re: Performance problems using 1GB Linux server and trying to avoid swappingDan Nelson18 Dec
        • Re: Performance problems using 1GB Linux server and trying to avoid swappingMarkus Fischer18 Dec