increase bulk_insert_buffer_size and if possible split the bigger file into small chunks. It will help you.
On Thu, Jun 12, 2008 at 1:51 PM, Ananda Kumar <[EMAIL PROTECTED]> wrote: > Hi All, > We are doing load data into a table using LOAD DATA INFILE process. Below > is > the method we are following. > > 1. create empty table with all the indexes. > 2. disable keys > 3. Load data using LOAD DATA INFILE, close to 99 Million records which > takes > around 3 hrs > 4 . Enable keys > > Table size is around 19.5 gb > > There is one primary key, 2 non unique indexes and one FULLTEXT INDEX. > > Enable kyes goes fine for couple of hrs with "REPAIR BY TMP", but then > switches to "REPAIR BY KEYCACHE" and writes a log in the error log > file "Warning: > Enabling keys got errno 28, retrying" > > What could be the problem. > > System has 8 cpu and 16GB RAM > > I have set myisam_max_sort_file_size=98GB > myisam_sort_buffer_size=750MB. > > /tmp folder has 16GB free space. > > please let me know, this problem is causing lot of dealy for other process > to run. > > 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]
