Hi... As I understand mysql, Innodb provides for row level locking, as opposed to myIsam which does tbl level locking. Is this correct?
If I am correct, if I have a trigger on a Innodb tbl (foo), such that the trigger then copies a row to another innodb tbl (cat), foo should only do a lock of the row when it's being copied, right? Also, I can then do whatever operations I want to on "cat" and it want affect, or be affected by foo, unless both "cat" and "foo" are doing operations that would result in dealing with the same row on "cat", where there could be row level locking/conflicts... Is this more or less how mysql innodb/triggers/locking works? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
