Hi all, can you help me please. Can someone explain, even briefly, what the differences are for concurrency control and the advantages of both? Im aware that mysql only has table locking whereas oracle has row locking, Mysql uses sessions to lock data. Can someone add to this please? Thanks
MySQL has row level locking as long as you use InnoDB or some of the other non-MyISAM engines. As far as the question I don't know enough about oracle to give any comparison.
Check this to know more about MySQL and Oracle locking mechanisms http://dev.mysql.com/doc/refman/5.0/en/table-locking.html http://www.dba-oracle.com/t_locks_row_level_locking.htm Hope this is helpful to you.