Hi again,
> > 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. Well, some further input about this as I've just tried at home (MySQL 4.0.1-alpha-nt). You seem to be right : with record_buffer=2M, the query takes 0.01 sec ; with record_buffer=32M, it jumps to 0.16 sec ! Although there is no swapping, and the task manager shows no change in allocated memory. (sort_buffer on the other hand, doesn't do anything) I'll try to confirm this tomorrow at work.... However, it's a really strange and annoying behaviour. Nowhere in the documentation is stated something like that, and 3.23 was fine about it. Is it a bug ? Thanks, Antoine. --------------------------------------------------------------------- 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
