DSpace Repository

A comparative study between the capabilities of MySQL and ClickHouse in low-performance Linux environment

Show simple item record

dc.contributor.author Wickramasekara, A.
dc.contributor.author Liyanage, M.P.P.
dc.contributor.author Kumarasinghe, U.
dc.date.accessioned 2022-08-25T09:10:12Z
dc.date.available 2022-08-25T09:10:12Z
dc.date.issued 2020
dc.identifier.citation Wickramasekara, A., Liyanage, M.P.P. & Kumarasinghe, U. (2020). A comparative study between the capabilities of MySQL and ClickHouse in low-performance Linux environment. 20th International Conference on Advances in ICT for Emerging Regions (ICTer 2020): 276 – 277 en_US
dc.identifier.uri http://dr.lib.sjp.ac.lk/handle/123456789/11806
dc.description.abstract Fast, reliable, and secure data processing is critical in the Information Technology (IT) sector as it is an indispensable requirement of all the growing technologies. Achieving this requires handling large amounts of data and massive computing power. Emerging technologies use devices under low-performance environments, such as raspberry-pi, which require highly efficient databases under low computing power. Inappropriate selection of databases leads to considerable resource wastage in numerous ways, such as waste of time, cost, and energy. The selection of a reliable, userfriendly database compatible with low-performance environments will downplay the energy requirement and cut down applications' carbon footprint. Thus, this study was conducted to compare the performance and query cost of using ClickHouse and MySQL databases as column-oriented and roworiented databases in a low-performance environment. The effectiveness of using column-oriented or row-oriented databases with large amounts of data at different platforms was analyzed. The study was conducted by running different queries using an automated PHP script and checking the execution time, processing power, disk I/O, and memory usage for each query. The study was conducted with a virtual Linux environment of 1024MB RAM, 1.8Ghz single processor, and 25Gb storage, representing very low computing power, even lesser than the recommended minimum requirement of ClickHouse and MySQL databases. Both databases performed well in the above mentioned environment. Our experimental results show that ClickHouse execution time and disk write speed is tremendously low compared to MySQL. To obtain this performance, ClickHouse used more CPU processing power and memory utilization than MySQL. en_US
dc.language.iso en en_US
dc.subject databases, MySQL, ClickHouse, columnoriented, row-oriented, Linux en_US
dc.title A comparative study between the capabilities of MySQL and ClickHouse in low-performance Linux environment en_US
dc.type Article en_US


Files in this item

This item appears in the following Collection(s)

Show simple item record

Search DSpace


Browse

My Account