Skip to main content
SpringerLink
Log in

MySQL vs MongoDB: A Preliminary Performance Evaluation Using the YCSB Framework

  • Conference paper
  • First Online:
Applied Technologies (ICAT 2021)

Part of the book series: Communications in Computer and Information Science ((CCIS,volume 1535))

Included in the following conference series:

  • 721 Accesses

Abstract

Information systems manage and process data for the fundamental tasks and specific requirements of each business. A database is thus an essential component of an information system. Database research involves two approaches, namely: relational and non-relational. A relational database is defined by rigid structures that provide consistency and referential integrity. However, this causes delays in response times and affects the availability of the schema. On the other hand, a non-relational database is schemaless and provides great flexibility for organizing and retrieving data; however, this characteristic does not guarantee strict consistency. An analysis of the performance of both database approaches is necessary to support the implementation of information systems. This research focuses on two datastores: MySQL (a relational database), and MongoDB (a non-relational database). Thus, the aim of this paper is to evaluate and compare the performance of both databases. For this, six evaluation scenarios were defined and executed using Yahoo! Cloud Serving Benchmark. This document highlights the best and worst performance scenarios for both databases based on three parameters: overall runtime, latency, and throughput. Finally, conclusions and future works are provided at the end of the paper.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 84.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

References

  1. Membrey, P., Plugge, E., Hawkins, T.: The Definitive Guide to MongoDB - The NoSQL Database for Cloud and Desktop Computing. Apress, New York (2020)

    Google Scholar 

  2. Alapati, S.: Expert Apache Cassandra - Install, Configure, Optimize, and Secure Apache Cassandra Databases. Apress, Berkeley (2018)

    Google Scholar 

  3. Chandra, D.G.: BASE analysis of NoSQL database. Futur. Gener. Comput. Syst. 52, 13–21 (2015). https://doi.org/10.1016/j.future.2015.05.003

    Article  Google Scholar 

  4. Chellappan, S., Ganesan, D.: MongoDB features and installation. In: MongoDB Recipes, pp. 1–24. Apress, Berkeley (2020)

    Google Scholar 

  5. MySQL: MySQL 8.0 Reference Manual (2020)

    Google Scholar 

  6. Friedrich, S., Ritter, N.: YCSB. In: Sakr, S., Zomaya, A. (eds.) Encyclopedia of Big Data Technologies, pp. 1–4. Springer, Cham (2018). https://doi.org/10.1007/978-3-319-63962-8_131-1

  7. Kitchenham, B.: Guidelines for performing systematic literature reviews in software engineering. Durham, UK (2007)

    Google Scholar 

  8. Agarwal, S., Rajan, K.S.: Performance analysis of MongoDB versus PostGIS/PostGreSQL databases for line intersection and point containment spatial queries. Spat. Inf. Res. 24(6), 671–677 (2016). https://doi.org/10.1007/s41324-016-0059-1

    Article  Google Scholar 

  9. Makris, A., Tserpes, K., Spiliopoulos, G., Zissis, D., Anagnostopoulos, D.: MongoDB Vs PostgreSQL: a comparative study on performance aspects. GeoInformatica 25, 241–242 (2021). https://doi.org/10.1007/s10707-020-00424-9

    Article  Google Scholar 

  10. Chopade, R.M., Dhavase, N.S.: MongoDB, CouchBase: performance comparison for image dataset. In: 2017 2nd International Conference for Convergence in Technology, I2CT 2017, pp. 255–259 (2017)

    Google Scholar 

  11. Cayres, L.U., de Lima, B.S., Garcia, R.E., Correia, R.C.M.: Analysis of Node.js application performance using MongoDB drivers. In: Rocha, Á., Ferrás, C., Montenegro Marin, C.E., Medina García, V.H. (eds.) ICITS 2020. AISC, vol. 1137, pp. 213–222. Springer, Cham (2020). https://doi.org/10.1007/978-3-030-40690-5_21

    Chapter  Google Scholar 

  12. Kumar Pandey, S., Kumar Pandey, S.: An approach to improve load balancing in distributed storage systems for NoSQL databases: MongoDB. In: Pattnaik, P., Rautaray, S., Das, H., Nayak, J. (eds.) Progress in Computing, Analytics and Networking, Advances in Intelligent Systems and Computing, pp. 785–793. Springer, Singapore (2018)

    Google Scholar 

  13. Chopade, R., Pachghare, V.: MongoDB indexing for performance improvement. In: Tuba, M., Akashe, S., Joshi, A. (eds.) ICT Systems and Sustainability. AISC, vol. 1077, pp. 529–539. Springer, Singapore (2020). https://doi.org/10.1007/978-981-15-0936-0_56

    Chapter  Google Scholar 

  14. Haughian, G., Osman, R., Knottenbelt, W.J.: Benchmarking replication in Cassandra and MongoDB NoSQL datastores. In: Hartmann, S., Ma, H. (eds.) DEXA 2016. LNCS, vol. 9828, pp. 152–166. Springer, Cham (2016). https://doi.org/10.1007/978-3-319-44406-2_12

    Chapter  Google Scholar 

  15. Fuad, A., Erwin, A., Ipung, H.P.: Processing performance on Apache Pig, Apache Hive and MySQL cluster. In: Proceedings of 2014 International Conference on Information, Communication Technology and System, ICTS 2014, pp. 297–301 (2014)

    Google Scholar 

  16. Grandhi, B., Chickerur, S., Patil, M.S.: Performance analysis of MySQL, Apache Spark on CPU and GPU. In: 2018 3rd IEEE International Conference on Recent Trends in Electronics, Information and Communication Technology, RTEICT 2018 – Proceedings, pp. 1494–1499. IEEE (2018)

    Google Scholar 

  17. Jogi, V.D., Sinha, A.: Performance evaluation of MySQL, Cassandra and HBase for heavy write operation. In: 2016 3rd International Conference on Recent Advances in Information Technology, RAIT 2016, pp. 586–590. IEEE (2016)

    Google Scholar 

  18. Tongkaw, S., Tongkaw, A.: A comparison of database performance of MariaDB and MySQL with OLTP workload. In: ICOS 2016 - 2016 IEEE Conference on Open Systems (ICOS), pp. 117–119 (2017)

    Google Scholar 

  19. Kumar, A.S.: Performance analysis of MySQL partition, hive partition-bucketing and Apache Pig. In: 1st India International Conference on Information Processing (IICIP), pp. 1–6 (2017)

    Google Scholar 

  20. Dawodi, M., Hedayati, M.H., Baktash, J.A., Erfan, A.L.: Facebook MySQL performance vs MySQL performance. In: 2019 IEEE 10th Annual Information Technology, Electronics and Mobile Communication Conference, IEMCON 2019, pp. 103–109. IEEE (2019)

    Google Scholar 

  21. Aboutorabi, S.H., Rezapour, M., Moradi, M., Ghadiri, N.: Performance evaluation of SQL and MongoDB databases for big e-commerce data. CSSE 2015 - 20th International Symposium on Computer Science and Software Engineering (2015). https://doi.org/10.1109/CSICSSE.2015.7369245

Download references

Author information

Authors and Affiliations

  1. Faculty of Engineering and Applied Sciences, Central University of Ecuador, Quito, Ecuador

    Julio C. Mendoza-Tello

  2. IT Consultant, N35-49 Julio Moreno Street, Quito, Ecuador

    Jenny Villacís-Ramón

Authors
  1. Julio C. Mendoza-Tello
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Jenny Villacís-Ramón
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Julio C. Mendoza-Tello .

Editor information

Editors and Affiliations

  1. Eindhoven University of Technology, Eindhoven, The Netherlands

    Miguel Botto-Tobar

  2. Universidad de las Fuerzas Armadas (ESPE), Sangolquí, Ecuador

    Sergio Montes León

  3. Universidad Técnica Particular de Loja, Loja, Ecuador

    Pablo Torres-Carrión

  4. Universidad Técnica del Norte, Ibarra, Ecuador

    Marcelo Zambrano Vizuete

  5. International University of Sarajevo, Sarajevo, Bosnia and Herzegovina

    Benjamin Durakovic

Rights and permissions

Reprints and permissions

Copyright information

© 2022 Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Mendoza-Tello, J.C., Villacís-Ramón, J. (2022). MySQL vs MongoDB: A Preliminary Performance Evaluation Using the YCSB Framework. In: Botto-Tobar, M., Montes León, S., Torres-Carrión, P., Zambrano Vizuete, M., Durakovic, B. (eds) Applied Technologies. ICAT 2021. Communications in Computer and Information Science, vol 1535. Springer, Cham. https://doi.org/10.1007/978-3-031-03884-6_14

Download citation

  • DOI: https://doi.org/10.1007/978-3-031-03884-6_14

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-031-03883-9

  • Online ISBN: 978-3-031-03884-6

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics

Search

Navigation