Carlos, ----- Original Message ----- From: ""Carlos Proal"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Sunday, January 19, 2003 7:13 PM Subject: Innodb enable/disable keys
> > > > > Hi, i have a simple question: > The sql statement: alter table _table_name_ disable keys; > has any action on "INNODB" tables ?, helps improving bulk inserts ?. no effect. If you have UNIQUE secondary indexes, you can try SET UNIQUE_CHECKS=0; to speed up disk-bound inserts. > thanx > > Carlos Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com sql query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php