On Wed, Sep 25, 2002 at 08:42:05AM -0300, Dyego Souza do Carmo wrote: > > The variables record_buffer,join_buffer and sort_buffer are alocated > every "user connect" ?
No, their are allocated on an as-needed basis for each thread. If a thread doesn't need to join anything, there will be no join buffer allocated. You can test that easily by setting them to really large values and noticing that your server doesn't run out of memory if your run INSERTs (for example). Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 50 days, processed 1,069,315,891 queries (244/sec. avg) --------------------------------------------------------------------- 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
