Hi. I need to index about 300 million 20-byte records, but it takes forever (it isn't finished yet, after almost 24 hours, so I don't have actual numbers).
I'm using RHEL, kernel 2.6.9, Mysql 4.1.11, MyISAM table, on a dual Xeon with 4GB RAM and IDE disks. I'm using the following values from /my-huge.cnf: key_buffer = 384M max_allowed_packet = 1M table_cache = 512 sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache = 8 query_cache_size = 32M I also added bulk_insert_buffer_size = 256M. What am I doing wrong and how can I improve it? Also, are there any progress indicators, so I can know how much time is left until indexing finishes? --Thanks, Roi. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
