Hi! ----- Original Message ----- From: "Jeremy Zawodny" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Wednesday, April 03, 2002 9:00 AM Subject: Re: Replication and transaction questions
> On Tue, Apr 02, 2002 at 11:49:10AM +0200, Nico Sabbi wrote: ... > > 2) why are creations of tables and databases non transactional when > > using InnoDB? > > Because InnoDB is a transactional table type. I think Nicola means why one cannot rollback a CREATE TABLE, for instance. It is a tradition in transactional databases that database schema changes are run in a kind of auto-commit mode. Providing the capability to roll back a CREATE TABLE would require some extra code in the database server. > > Is there an options to change this behavior? > > No. Use a non-transactional table type such as MyISAM. > > Jeremy > -- > Jeremy D. Zawodny, <[EMAIL PROTECTED]> > Technical Yahoo - Yahoo Finance > Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 > > MySQL 3.23.47-max: up 54 days, processed 1,508,679,843 queries (319/sec. avg) 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 --------------------------------------------------------------------- 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
