> Do you use so huge queries that you really need sort_buffer=64M and
 > record_buffer=32M? Don't forget that record_buffer and sort_buffer are
 > specified per-thread.

I don't know exactly which values I need, but when I generate statistical
data from the tables it often spans a not-so-small dataset. Also, there
is not much concurrency and I am not tight on memory (the box has 2 GB).

Would it have something to do with the problem ?

Regards

Antoine.


(keywords : sql,query)



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to