MYSQL and Oracle - concurrency control differences ?

Discussion in 'Databases' started by Jamie1987, Nov 14, 2010.

0
  1. #1
    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
     
    Jamie1987, Nov 14, 2010 IP
  2. Jamie1987

    Jamie1987 Peon

    Messages:
    6
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    please anyone?
     
    Jamie1987, Nov 14, 2010 IP
  3. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #3
    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.
     
    jestep, Nov 15, 2010 IP
  4. teamaguilar

    teamaguilar Peon

    Messages:
    197
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    teamaguilar, Nov 22, 2010 IP
  5. iama_gamer

    iama_gamer Active Member

    Messages:
    404
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    60
    #5
    As far as i know Oracle uses row level locking by default
     
    iama_gamer, Dec 4, 2010 IP
  6. alexanime

    alexanime Peon

    Messages:
    39
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Mysql only the InnoDB storage engine supports row locking
     
    alexanime, Dec 5, 2010 IP