> 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