469,286 Members | 2,393 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,286 developers. It's quick & easy.

Optimistic locking?

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

Nov 30 '05 #1
1 6035
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

Dec 1 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

16 posts views Thread by Nid | last post: by
1 post views Thread by Chris Huddle | last post: by
2 posts views Thread by John | last post: by
reply views Thread by russganz | last post: by
6 posts views Thread by shaanxxx | last post: by
1 post views Thread by =?Utf-8?B?Qi4gQ2hlcm5pY2s=?= | last post: by
1 post views Thread by =?Utf-8?B?Qi4gQ2hlcm5pY2s=?= | last post: by
8 posts views Thread by Roger.Noreply | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.