2006/3/14, Truong Tan Son <[EMAIL PROTECTED]>: > Dear Sir, > > I could not find table of innoDB in mysql. >
Tables in the mysql are MyISAM and should stay that way. Odds are that there is a skip-innodb in your my.cnf on your RHE, and not you XP. what produces a "show status" ? > mysql> show tables; > +----------------------+ > | Tables_in_mysql | > +-----------------------+ > | columns_priv | > | db | > | func | > | host | > | tables_priv | > | user | > +----------------------+ > > > I set innodb_table_locks=0 in my.cnf , but ROLLBACK is still not effect. > > > Could you teach me more ? > > > Thanks and best regards, > > > ----- Original Message ----- > From: "Pooly" <[EMAIL PROTECTED]> > To: "MySQL General" <mysql@lists.mysql.com> > Sent: Monday, March 13, 2006 5:13 PM > Subject: Re: Rollback is not take effect on MySQL 5.0.18 > > > 2006/3/11, Truong Tan Son <[EMAIL PROTECTED]>: > > Dear Sir, > > > > On RedHat Enterprise 4, and MySQL 5.0.18, I did : > > > > mysql> set autocommit=0; > > > > mysql> savepoint abc; > > > > mysql> insert ....something.... > > > > mysql> rollback to save point abc; > > > > Query OK, 0 rows affected, 1 warning (0.00 sec) > > ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > > > > RollBack is NOT take effect. But on WindowsXP, it is GOOD. > > > > > > What is wrong ? > > > Did you check if the table are innoDB ? > > > -- > Pooly > Webzine Rock : http://www.w-fenec.org/ > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Pooly Webzine Rock : http://www.w-fenec.org/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]