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
Evaluating Mitigations For Meltdown and Spectre: Benchmarking performance of mitigations against database management systems with OLTP workload
University of Skövde, School of Informatics.
2018 (English)Independent thesis Basic level (degree of Bachelor), 15 credits / 22,5 HE creditsStudent thesisAlternative title
Bedömining Av Mitigering Mot Spectre och Meltdown : Prestandamätningar av databashanteringssystem efter mitigering mot Spectre och Meltdown med OLTP arbetsbelastning (Swedish)
Abstract [en]

With Spectre and Meltdown out in the public, a rushed effort was made to patch these vulnerabilities by operating system vendors. However, with the mitigations against said vulnerabilities there will be some form of performance impact. This study aims to find out how much of an impact the software mitigations against Spectre and Meltdown have on database management systems during an online transaction processing workload.

An experiment was carried out to evaluate two popular open-source database management systems and see how they were affected before and after the software mitigations against Spectre and Meltdown was applied.

The study found that there is an average of 4-5% impact on the performance when the software mitigations is applied. The study also compared the two database management systems with each other and found that PostgreSQL can have a reduced performance of about 27% when both a hypervisor and the operating system is patched against Spectre and Meltdown.

Abstract [sv]

När Spectre och Meltdown tillkännagavs gjordes en snabb insats för att korrigera dessa sårbarheter av operativsystemleverantörer. Men med mildringarna mot dessa sårbarheter kommer det att finnas någon form av prestationspåverkan. Denna studie syftar till att ta reda på hur mycket av en påverkan uppdateringarna mot Spectre och Meltdown har på databashanteringssystem under en online-transaktionsbehandlings arbetsbelastning.

Ett experiment gjordes för att utvärdera två populära databashanteringssystem baserad på fri mjukvara och se hur de påverkades före och efter att uppdateringarna mot Spectre och Meltdown applicerats i en Linux maskin.

Studien fann att det i genomsnitt är 4–5% påverkan på prestandan när uppdateringarna tillämpas. Studien jämförde också de två databashanteringssystemen med varandra och fann att PostgreSQL kan ha en reducerad prestanda på cirka 27% när både det virtuella maskinhanteringssystemet och operativsystemet är uppdaterad mot Spectre och Meltdown.

Place, publisher, year, edition, pages
2018.
Keywords [en]
Spectre, Meltdown, Database, Database Management Systems, MariaDB, PostgreSQL, OLTP, Transactions Per Minute, Performance
Keywords [sv]
Spectre, Meltdown, Databas, Databashanteringssystem, MariaDB, PostgreSQL, OLTP, Transaktioner per minut, Prestanda
National Category
Computer and Information Sciences
Identifiers
URN: urn:nbn:se:his:diva-15254OAI: oai:DiVA.org:his-15254DiVA, id: diva2:1212643
Educational program
Network and Systems Administration
Supervisors
Examiners
Available from: 2018-06-03 Created: 2018-06-03 Last updated: 2018-06-03Bibliographically approved

Open Access in DiVA

fulltext(634 kB)400 downloads
File information
File name FULLTEXT01.pdfFile size 634 kBChecksum SHA-512
a8d7b28c149ed8763a6031de04be43a27d4440e6b2132b8999ec0187e5b4ec5ce7a227fea53d36cf6783e9cac0b567e1b8b63b1ac5006b65f425d01c8b08c7b3
Type fulltextMimetype application/pdf

Search in DiVA

By author/editor
Nilsson, Victor
By organisation
School of Informatics
Computer and Information Sciences

Search outside of DiVA

GoogleGoogle Scholar
Total: 401 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: 1367 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