On Tue, Jul 20, 2004 at 10:39:00AM +1000, Lachlan Mulcahy wrote: > > Chris, > > Have you checked your following server configurables: > > sort_buffer_size: > - This is the size of the cache created by _each_ thread that requires > ORDER BY or GROUP BY in a query. > If you are doing a lot of large ordered queries you will need to increase > this value otherwise MySQL will use _disk_ for sorting (this is very slow > and largely undesirable).
This was at it's default 2MB, so I've raised it to 64; doesn't seem to have helped much in the short term though :( > > tmp_table_size: > - This is the maximum size of an "in memory" or HEAP temporary table. If a > GROUP BY query causes the server to exceed this limit, an "on disk" table > will be used. Once again, this is slow and undesirable. This was 100MB, so that should be sufficient. I've altered sort_buffer_size so I'll see how it goes over the next few hours. Cheers for the pointer! -- Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
