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]