Re: Question: InnoDB transaction and table changes

DDL cannot be rollback http://dev.mysql.com/doc/mysql/en/cannot-roll-back.html It also apply to many DB like Sybase for example... Ville Karjalainen wrote: Greetings, I created a table during transaction and was surprised to find out it still existed after I did a ROLLBACK. The same seems to apply

RE: Question: InnoDB transaction and table changes

-- ---+ 1 row in set (0.00 sec) See: http://dev.mysql.com/doc/mysql/en/cannot-roll-back.html HTH Mark Mark Leith Cool-Tools UK Limited http://www.cool-tools.co.uk -Original Message- From: Ville Karjalainen [mailto:[EMAIL PROTECTED] Sent: 04 February 2005 13:59 To: m

Question: InnoDB transaction and table changes

Greetings, I created a table during transaction and was surprised to find out it still existed after I did a ROLLBACK. The same seems to apply to changes made using ALTER TABLE statements. Is there a simple logical explanation to this behaviour? Any help would be appreciated. Demonstration fol

Question innodb

Hi, I have a question about setting up the innodb part of mysql server. I run mysql version 8.21, distribution 3.23.40 for pc-linux-gnu on i686 (installed the binary distribution). I tried to turn on innodb, so I stopped the server, copied my-medium.cnf under /etc/my.cnf, uncomment the lines c