ANALISIS KINERJA DATABASE MYSQL PADA LEARNING MANAGEMENT SYSTEM (LMS)

Abstract

Learning Management Systems (LMS) are becoming increasingly popular as digital learning tools across various educational institutions and organizations. To ensure their performance, a database system capable of handling transactions quickly, stably, and efficiently is required. MySQL is a DBMS frequently used in LMS development due to its open-source nature, ease of integration, and ability to handle medium-scale data processing. However, an increase in the number of users and data load can affect MySQL's performance, including longer query execution times and the emergence of bottlenecks during concurrent access. This research investigates MySQL's performance in the LMS context by conducting a literature review of previous studies related to database optimization, table design, index usage, and tuning techniques. The results of the analysis indicate that MySQL's performance highly depends on the database structure design, InnoDB parameter configuration, caching mechanisms, as well as scalability strategies such as replication and connection management. Overall, MySQL remains effective for LMS implementation if supported by appropriate system design and optimization.