I have a MyISAM table, into which I am trying to bulk-load several gigabytes of data.
The first attempt got stuck after the table.MYD file had reached precisely 4 GB. There wasn't any error message, but I observed that neither the data nor the index file was increasing in size, even though the CPU load was at 100%. Anyways, this was solved by setting the following table properties (and killing the database server + deleting the table): MAX_ROWS = 100000000 AVG_ROW_LENGTH = 300 Now I have again run into the same issue, but at 5.78/1.21 GB (table/index size). For a while the table size remained constant while the index size still increased, but now nothing seems to be happing any more, while the CPU is 100% busy. I would have expected the index to reach a final size of something around 4 GB. Any idea what has gone wrong here? Yet another limitation I have run into? -- Eric Jain -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
