By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,051 Members | 1,229 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,051 IT Pros & Developers. It's quick & easy.

Optimistic locking?

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.