myisam_max_sort_file_size=10GB You have alloted 10GB memory to myisam_max_sort_file_size, The system has 8GB of memory.
send show global status; On Mon, May 12, 2008 at 6:48 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > Hi All, > We have a table which is around 100 Million rows. Its a myisam table, but > the db default is innodb. > CREATE TABLE `dc_data` ( > `id` decimal(22,0) NOT NULL, > `words` varchar(255) NOT NULL, > `lf_id` decimal(22,0) NOT NULL, > `occurence` bigint(20) NOT NULL, > `date_modified` timestamp NULL default CURRENT_TIMESTAMP on update > CURRENT_TIMESTAMP) ENGINE=MyIsam DEFAULT CHARSET=utf8 > > > indexs are as below > > PRIMARY KEY (`id`), > KEY `KI_IDX_0805090456` (`words`,`id`), > KEY `CI_IDX_0805090456` (`lf_id`) > > we have 8 cpu, 8 gb ram. > We use set below parameters at session level > > myisam_sort_buffer_size=300MB > myisam_max_sort_file_size=10GB > > Each index creation is taking 10hrs, is there any way i can speed up index > creation. > > regards > anandkl > -- Krishna Chandra Prajapati MySQL DBA, Ed Ventures e-Learning Pvt.Ltd. 1-8-303/48/15, Sindhi Colony P.G.Road, Secunderabad. Pin Code: 500003 Office Number: 040-66489771 Mob: 9912924044 URL: ed-ventures-online.com Email-id: [EMAIL PROTECTED]