Hi! On Oct 26, Kyle Hayes wrote: > On Friday 26 October 2001 07:18, Wai Lee wrote: > > > I dig through the manual and changed any possible settings > > > > set-variable = max_heap_table_size=2000M > > set-variable = key_buffer=2500M > > set-variable = max_allowed_packet=1M > > set-variable = table_cache=512 > > set-variable = sort_buffer=2500M > > set-variable = join_buffer=2500M > > set-variable = record_buffer=2500M > > set-variable = myisam_sort_buffer_size=2500M > > set-variable = myisam_max_sort_file_size=2500M > > set-variable = myisam_max_extra_sort_file_size=2500M > > set-variable = thread_cache=8 > > I am not certain, but I think you told MySQL to use 2.5G x 5 or 12.5GB! That > is a little more than the 4GB you have in the machine :-)
No. Some of these variables are per-thread settings, so in the worts case MySQL will try to allocate much more than 12.5GB. But it's doesn't matter - as there were not that many clients accessing the db during the index creation (I presume), so sort_buffer, join_buffer, and record_buffer settings does not matter. And for a dedicated task of building the index myisam_sort_buffer_size=2500M looks ok. Still, it never hurts to control memory consumption with top :-) Other tasks can eat up the memory. > > set-variable = max_heap_table_size=200M > > set-variable = key_buffer=1000M > > set-variable = max_allowed_packet=1M > > set-variable = table_cache=512 > > set-variable = sort_buffer=250M > > set-variable = join_buffer=250M > > set-variable = record_buffer=250M > > set-variable = myisam_sort_buffer_size=250M That's too small for 4G RAM (unless one tries to rebuild multi-gigabyte index on heavily loaded database server). > > set-variable = myisam_max_sort_file_size=2500M > ?? Not sure about this one. Check the manual. To be increased. > > set-variable = myisam_max_extra_sort_file_size=2500M > ?? Not sure about this one. Check the manual. To be increased. Regards, Sergei -- MySQL Development Team __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ --------------------------------------------------------------------- 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
