> Any idea what has gone wrong here? Yet another limitation I have run > into?
Tried this: 1) CREATE TABLE 2) ALTER TABLE DISABLE KEYS 3) LOAD DATA -> Complete after 30 min, table size 5.78 GB, index size 1.21 GB. 4) ALTER TABLE ENABLE KEYS -> Puts a full load on the CPU, but neither index nor table size seem to change, even after waiting for an hour. Based on smaller data sets, I'd expect the index to reach something close to 4 GB. I'd appreciate any suggestions. Do I need to allocate more memory? Which parameters? Surely I'm not the first to store more than a gigabyte of data into a table with a few indexes :-) -- Eric Jain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
