An Architecture of MySQL Storage Engines to Increase the Resource Utilization

Abstract

Big data storage and retrieval issues have been tackled in various ways. Making a robust model is challenging, requiring the architects and designers to review the requirements and decide on a solution. Relational databases still have the potential to overcome significant data processing and storage issues. An essential component of any relational database is the storage engine. It directly influences how resources are used and how well queries perform. MySQL’s Storage engine ensures that all basic operations are carried out effectively. Our primary goal in this research is to find the most appropriate storage engine in terms of memory and CPU usage. We also examine each engine’s query performance To assist the organization in selecting the best storage engine for their application, this article also examines the most widespread applications of InnoDB, MyISAM, and ARCHIVE.