Re: Table corruption using DISABLE/ENABLE KEYS

2003-09-09 Thread Sergei Golubchik
Hi! On Sep 09, [EMAIL PROTECTED] wrote: > > I'm using MySQL v4.0.12 on Redhat Linux 9.0 > > I have a python script (using the MySQLdb module) that inserts a large > batch of records to several MyISAM tables. The largest table (named > 'log') has 20 columns. A single column defines the primary

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. > > However, in doing so, th