MySQL - Transaction/Commit Question/Issue

Hi... I'm considering the following issue: need to copy in db1 tbl_1 -> tbl_2 and in db2 cat -> dog so i need to perform copies of both tbls in the two databases. and i need them to both succeed, or to both be rolled back. the copies are in two separate databases. any thoughts on this... t

Re: InnoDB Commit question

Rob, - Original Message - From: ""Rob Brooks"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Sunday, March 12, 2006 6:02 PM Subject: InnoDB Commit question --=_NextPart_000_0033_01C645BC.03223720 Content-Type: text/plain; charset=&

InnoDB Commit question

Hi, we have a db with myisam and a single innodb table. 2 separate processes are inserting data into the myisam tables and the innodb table at the same time. We have noticed an issue where commits to the innodb table appear to be delayed until the process inserting into the myisam tables is finis

Commit question

Hi, we have a db with myisam and a single innodb table. 2 separate processes are inserting data into myisam and the innodb tables at the same time. Intermittently, we have noticed an issue where commits to the innodb table appear to be delayed until the process inserting into the myisam tables is