Jimi,
InnoDB uses traditional pessimistic two-phase locking. This is complemented
by multiversioning (MVCC) that makes non-locking consistent reads possible.
Thus, InnoDB is similar to PostgreSQL and Oracle in its transaction
management.
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
<ji*********@hotmail.com> kirjoitti
viestissä:11**********************@g43g2000cwa.goo glegroups.com...
Hi,
Can anyone tell me if MySQL uses optimistic or pessimistic locking with
InnoDB tables? And can this be modified in any way?
When I use the search function on the mysql site, it only gives me
search results for MaxDB...
Regards
/Jimi