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]
