I would increase your myisam_sort_buffer_size considerably just for
this operation. You've got your key_buffer set high, but your sort
buffer is comparatively low for creating a big index.
One way you can tell how far along the index is, is to look at how
quickly the index file is growing and how big it is. Of course, you
don't know what the end size is going to be, but at least you'll be
able to tell it's progress.
On Jun 8, 2005, at 10:45 AM, roi h wrote:
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]
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
