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="us-ascii"
Content-Transfer-Encoding: 7bit

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
finished.  Has anyone else noticed this behavior?  What could be causing
this?

which MySQL version you are using?

Please describe in detail what MySQL statement(s) you use to insert into the MyISAM tables.

Please post SHOW PROCESSLIST and SHOW INNODB STATUS\G readings when the commit is seemingly hung.

I am not aware of any mechanism that should delay the processing of a commit in this case.

Any help appreciated



Rob Brooks

The Brian Group LLC

Best regards,

Heikki

Oracle Corp./Innobase Oy
InnoDB - transactions, row level locking, and foreign keys for MySQL

InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to