Re: Performance problems using 1GB Linux server and trying to avoid swapping

[Dan Nelson]

In the last episode (Dec 18), Markus Fischer said:
> On Tue, Dec 16, 2003 at 10:38:14AM -0600, Dan Nelson wrote : 
> > 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.

It's used for any sorting:

   * `sort_buffer_size' Each thread that needs to do a sort allocates a
     buffer of this size. Increase this value for faster `ORDER BY' or
     `GROUP BY' operations.  *Note Temporary files::.

-- 
	Dan Nelson
	dnelson@stripped