Högskolan i Skövde

his.sePublications
Change search
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • apa-cv
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf
Performance comparison between NewSQL and SQL: Sharded TiDB vs MariaDB
University of Skövde, School of Informatics.
University of Skövde, School of Informatics.
2020 (English)Independent thesis Basic level (degree of Bachelor), 20 credits / 30 HE creditsStudent thesis
Abstract [en]

Databases are used extensively for websites and a large amount of websites are built upon Wordpress. Wordpress uses MySQL compatible databases and for many larger websites itcan be imperative to have the best possible performance. Recently, NewSQL databases have been appearing that combine the features of NoSQL databases with SQL compatibility and ACID compliance that is usually not found in NoSQL databases. Due to their recency, thereis a knowledge gap in the literature regarding NewSQL databases. Therefore, this work compares the performance of the NewSQL database TiDB against the SQL database MariaDB in a performance benchmark. The benchmark includes three testing approaches with an aim of testing multiple performance aspects. These include load testing, complex queries and performance in a realistic environment.

Results from this thesis show that TiDB achieves better average response time for complex queries and in load testing where the databases and load is large but gets worse results for simple queries and small datasets. MariaDB performs better when used with a web server andwith tests that involve write-operations.

Place, publisher, year, edition, pages
2020. , p. 35
Keywords [en]
Database, Performance comparison, NewSQL, TiDB, SQL, MariaDB
National Category
Information Systems, Social aspects
Identifiers
URN: urn:nbn:se:his:diva-18712OAI: oai:DiVA.org:his-18712DiVA, id: diva2:1449822
External cooperation
Duva AB
Subject / course
Informationsteknologi
Educational program
Computer Science - Specialization in Systems Development
Supervisors
Examiners
Available from: 2020-06-30 Created: 2020-06-30 Last updated: 2020-06-30Bibliographically approved

Open Access in DiVA

fulltext(746 kB)829 downloads
File information
File name FULLTEXT01.pdfFile size 746 kBChecksum SHA-512
ba305a6b436b41ffc55c11e79da6496c33d9c29a1e38de569408d0e5f490fb9d9ac75a3dc64c90d1eeec59165e25c54390281f5ae84711eda1aa8b55f5f6c9f3
Type fulltextMimetype application/pdf

By organisation
School of Informatics
Information Systems, Social aspects

Search outside of DiVA

GoogleGoogle Scholar
Total: 829 downloads
The number of downloads is the sum of all downloads of full texts. It may include eg previous versions that are now no longer available

urn-nbn

Altmetric score

urn-nbn
Total: 3042 hits
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • apa-cv
  • ieee
  • modern-language-association-8th-edition
  • vancouver
  • Other style
More styles
Language
  • de-DE
  • en-GB
  • en-US
  • fi-FI
  • nn-NO
  • nn-NB
  • sv-SE
  • Other locale
More languages
Output format
  • html
  • text
  • asciidoc
  • rtf