Sign in

MinervaDB Technology Partnership Program

Are you an systems integrator, ISV or value added reseller / distributor powering database infrastructure operations of internet / mobility, IoT and technology companies ? Then you will be interested in talking to us. We have built planet-scale internet properties for several Alexa top 5000 websites from diversified industries like CDN, mobile advertisement networks, E-Commerce, online payment solutions, social media applications / gaming and SaaS . We are an boutique private-label independent and vendor neutral MySQL, MariaDB, Percona Server and ClickHouse consulting, support and training services provider with core expertise in performance, scalability and high availability . …

The database locks exist to protect shared resources or objects, This could be Tables, Data Rows, Data Blocks, Cached Items, Connections or even the Entire Database Systems . The locks ensure reliable transaction that adhere to ACID properties of transactional systems . ACID is an acronym that stands for Atomicity, Consistency, Isolation and Durability . In this post I have explained how InnoDB locks works.

What are the different kinds of locking supported in InnoDB (MySQL 5.7) ?

  • Shared and Exclusive Locks
  • Intention Locks
  • Record Locks
  • Gap Locks
  • Next-Key Locks
  • Insert Intention Locks
  • AUTO-INC Locks
  • Predicate Locks for Spatial Indexes

MinervaDB

Independent and vendor neutral consulting, support and training for MySQL, MariaDB, Percona Server and ClickHouse

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store