RE: Will "Alter Table ... enable keys" reload data to table?

2005-01-13 Thread mos
At 07:42 PM 1/13/2005, Dathan Pattishall wrote: 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 temp

RE: Will "Alter Table ... enable keys" reload data to table?

2005-01-13 Thread Dathan Pattishall
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 > -Original Message- > From: mos [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 13,

Will "Alter Table ... enable keys" reload data to table?

2005-01-13 Thread mos
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 se

Re: Disable/Enable Keys and Duplicate Records

2003-10-13 Thread Matt W
sage - From: "Randy Chrismon" Sent: Monday, October 13, 2003 9:48 AM Subject: Disable/Enable Keys and Duplicate Records I'm not clear on this. What happens to duplicates under the following scenario? MyISAM table with either (or both!) a primary key or a unique index. Alter table

Disable/Enable Keys and Duplicate Records

2003-10-13 Thread Randy Chrismon
I'm not clear on this. What happens to duplicates under the following scenario? MyISAM table with either (or both!) a primary key or a unique index. Alter table my_table disable keys. Import 200K records. Alter table my_table enable keys. But it turns out there are duplicate records. Does

Re: Table corruption using DISABLE/ENABLE KEYS

2003-09-09 Thread Sergei Golubchik
single column defines the primary key. There > isn't an auto increment column. Many of the other columns in the log > table are indexed as well. > > This seemed like an ideal case to DISABLE KEYS, insert the data and > then ENABLE KEYS based on the MySQL documentation. And

Re: Table corruption using DISABLE/ENABLE KEYS

2003-09-09 Thread Jeremy Zawodny
On Tue, Sep 09, 2003 at 02:56:56PM -0700, [EMAIL PROTECTED] wrote: > > This seemed like an ideal case to DISABLE KEYS, insert the data and > then ENABLE KEYS based on the MySQL documentation. And running some time > tests proves that this approach runs much faster. > > Ho

Table corruption using DISABLE/ENABLE KEYS

2003-09-09 Thread stuff
ent column. Many of the other columns in the log table are indexed as well. This seemed like an ideal case to DISABLE KEYS, insert the data and then ENABLE KEYS based on the MySQL documentation. And running some time tests proves that this approach runs much faster. However, in doing so, t

Bug: MySQL 4.0.13 crashes during simultaneous execution "ALTER TABLE ... ENABLE KEYS" and "SHOW TABLE STATUS" statements.

2003-06-10 Thread Mikhail Entaltsev
Hi all, My MySQL crashed during simultaneous execution of "ALTER TABLE ... ENABLE KEYS" and "SHOW TABLE STATUS" statements. There were 2 threads: #3 and #4. In thread #4 I executed: 4 Query DROP TABLE IF EXISTS History 4 Query CREATE TABLE History

ENABLE KEYS

2002-10-21 Thread tl
Please help me! mysql>alter table a_log ENABLE KEYS; ERROR 1064: You have an error in your SQL syntax near 'ENABLE KEYS' at line 1 Thank's - Before posting, please check: http://www.mysql.com/manual

RE: ENABLE KEYS

2002-10-21 Thread STIBS
>mysql>alter table a_log ENABLE KEYS; >ERROR 1064: You have an error in your SQL syntax near 'ENABLE KEYS' at >line 1 What version are you running, I think I read ENABLE/DISABLE KEYS just work in 4.0. STIBS --