DISABLE / ENABLE keys is very fast even for your dataset. Basically when disabled it only respects UNIQUE type keys when loading data and rebalances the binary tree when enabled.
Dathan
Dathan,
So you're saying it will not create a temporary table and reload the data into it, like all Alter Table statements do?
Mike
> -----Original Message----- > From: mos [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 13, 2005 5:24 PM > To: mysql@lists.mysql.com > Subject: Will "Alter Table ... enable keys" reload data to table? > > I am importing data into a large table, 100 million rows, and > I want to use "Alter table disable keys" prior to executing a > Load Data...,. But after loading the data, if I execute a > "Alter Table ... enable keys" will MySQL create a second > table, load the data into the second table, and then rebuild > the keys like it does for most Alter Tables? I don't want to > use Alter Table ... if it is going to copy the data over to > another table. I'm thinking MySQL should be smart enough just > to rebuild the index without moving data. Am I right? > > TIA > > Mike > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
