Hi, While trying to index a 77million row table (I know, I'll shut up), I started to fiddle with the mysql variables to get it done in under 3 weeks. Finally, I happened upon the myisam_max_sort_file_size and myisam_max_extra_sort_file_size variables. Messing with these allowed the indexing to go through the 'copy to temp file' stage a lot quicker (5GB in 10 minutes), and start to proceed with the 'repair by sorting' phase. But ah, here's the rub: mysql starts making temp files; first a 18.9GB file, then it starts on another before it eats the remaining 5GB of space and gives me an error 28 (one of my favourite errors). How can I adjust the variables to do the copying quickly, yet not fill my drive with temp files? One of the problems is that the two variables I mentioned supposedly report their values in MB. If I use set-variable=myisam_max_sort_file_size=10000M, it reports that myisam_max_sort_file_size is 1895825408, but if I use set-variable=myisam_max_sort_file_size=10000 (no 'M'), it reports that myisam_max_sort_file_size is 10000. What's up with that? Why is it being so silly? Anyways, could someone please help me set these bloody variables? I'm on a athlon 1.33Ghz w/512MB RAM, 24GB HD space available. The table is 5GB, and if the aforementioned variables are too small, it takes eons to copy the table (and indexes on the fly for some reason), then does a painfully slow repair by keycache (next to no processor utilization). my.ini looks like this: set-variable=key_buffer=128M set-variable=table_cache=16 set-variable=sort_buffer=64M set-variable=record_buffer=64M set-variable=join_buffer=16M set-variable=tmp_table_size=16M set-variable=myisam_sort_buffer_size=128M set-variable=myisam_max_sort_file_size=10000M <-kinda sure set-variable=myisam_max_extra_sort_file_size=5000M <- guessing very wrong Thank you in advance, -robin (losing his sanity quickly) --------------------------------------------------------------------- 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
