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]

Reply via email to