Abstract
Present disclosure provides a method and system for adaptive lock granularity adjustment system 100 for optimizing performance of MySQL database. The method includes monitoring the incoming queries initiated by one or more users at the end of the terminal via a user device installed with an application that establishes a connection with MySQL database. Monitoring module 102 continuously monitors query patterns and lock contention levels to dynamically adjust the granularity of locks (row-level, page-level, or table-level) in real-time. Upon monitoring, the data collected and analyzed is fed to the design engine 104. The design engine 104 utilizes advanced machine learning algorithms to analyze collected data to determine the optimal lock granularity, aiming to enhance performance and minimize contention. Further, the design engine 104 transmits the predicted optimal granularity to lock manager 106 comprising the dynamic adjustment mechanism that performs changes to lock granularity on-the-fly without requiring the database to restart or downtime, ensuring continuous and efficient database operations under varying workload conditions.
Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 License.
Recommended Citation
ROY, ALOK, "METHOD AND SYSTEM FOR ADAPTIVE LOCK GRANULARITY ADJUSTMENT FOR OPTIMIZING PERFORMANCE OF MYSQL DATABASE", Technical Disclosure Commons, (October 08, 2024)
https://www.tdcommons.org/dpubs_series/7419