Re: Innodb enable/disable keys

2003-01-19 Thread Heikki Tuuri 
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

Innodb enable/disable keys

2003-01-19 Thread Carlos Proal 




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 ?.

thanx

Carlos




_
Help STOP SPAM: Try the new MSN 8 and get 2 months FREE* 
http://join.msn.com/?page=features/junkmail


-
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