Re: The record_buffer ,join_buffer, sort_buffer
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
The record_buffer ,join_buffer, sort_buffer
The variables record_buffer,join_buffer and sort_buffer are alocated every user connect ? ex: join_buffer=6M record_buffer=7M sort_buffer=9M max_connection=200 in final case the mysql stored in memory is: (6+7+9)*200 = 1813MB ??? or the variables in this case is to global operation ? 1 client = 1 thead ps: my system is mysql 3.23.52 , running on Windows 2k with 1G of RAM ... using tables with myisam and innodb table handler ! Tnks for attenction ! :) - ++ Dyego Souza do Carmo ++ Dep. Desenvolvimento - E S C R I B A I N F O R M A T I C A - The only stupid question is the unasked one (somewhere in Linux's HowTo) Linux registred user : #230601 -- $ look into my eyes look: cannot open my eyes - Reply: [EMAIL PROTECTED] - 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