• record lock - table lock
  • index gap lock - s-lock / x-lock