A Multi-tenant Level Lightweight Lock Mechanism for Multi-tenant Database

Abstract

For SaaS applications, tenants usually share a sparse table, and the lock is used to ensure concurrency control. With the development of the hardware upgrade, lock management is increasingly becoming a performance bottleneck. Traditional lock manager does not practical to multi-tenant database because of high concurrency. This paper discusses the provision of a new method - MLLL which is based on sparse table storage model. The method avoids appearing conflict technique among users and almost all of the overhead associated with traditional association lock manager.