On Thu, Oct 18, 2001 at 11:41:08AM -0400, Wai Lee wrote: > Hi, > > I am experiencing a very slow performance while I am building an index on a > table. The following are some facts of system and the table I am dealing > with: > > Table size: 13,857,354 > Number of distinct value in the column I use as index: 176,322 > Platform: Linux system with dual CPUs 1G Hz and 4G in memory. > Time to build: 3 hours > > mySQL Configuration setting: > > key_buffer_size | 1073737728 > sort_buffer | 268435448 > myisam_sort_buffer_size | 67108864 > myisam_max_extra_sort_file_size | 256 > | > myisam_max_sort_file_size | 2047 > > Any help will be greatly appreciated.
Increasing the record buffer may help, too. MySQL has to read all the rows, so a larger record buffer might improve things. Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.41-max: up 43 days, processed 943,783,615 queries (253/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
