Re: Insert problems with InnoDB (big table)

[Luc Charland]

[EMAIL PROTECTED] wrote:
Estimado Luc,
Con fecha jueves 5 de agosto de 2004, 11.07.23, escribió:
 

Did you try disable index table? When you import millon of records
there is an overload indexing it. First import and then create your
index or:
ALTER TABLE tb_name DISABLE KEYS;
import data...
ALTER TABLE tb_name ENABLE KEYS;
 

As said in the doc: 
http://dev.mysql.com/doc/mysql/en/Converting_tables_to_InnoDB.html

__________________________________________________________________
|InnoDB| does not have a special optimization for separate index 
creation the way the |MyISAM| storage engine does. Therefore, it does 
not pay to export and import the table and create indexes afterward.
__________________________________________________________________

But we tried it anyway, and it is actually slower in our setup.
Luc
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]