Change search
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • 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
SSDs påverkan på MySQL: En prestandajämförelse
Linnaeus University, Faculty of Science and Engineering, School of Computer Science, Physics and Mathematics.
Linnaeus University, Faculty of Science and Engineering, School of Computer Science, Physics and Mathematics.
2012 (Swedish)Independent thesis Basic level (degree of Bachelor), 10 credits / 15 HE creditsStudent thesis
Abstract [sv]

Solid State Drives (SSD) blir idag allt vanligare som lagringsmedium och håller på att bli ett alternativ till magnetiska hårddiskar. Denna studie+ har undersökt hur man på bästa sätt kan utnjytta SSDer i en MySQL-databas. Undersökningen genomfördes med hjälp av experiment där prestandamätningar gjordes för att få en klar bild på i vilken konfiguration av SSDs som ger bäst prestanda i MySQL. Mätverktygen som användes var sql-bench och mysqlslap.   Resultaten visar att en databas på en enskild SSD presterar lika bra som en databas med  SSD-cache  under  majoriteten  av  mätningarna  och  visar  bättre  resultat  än resterande konfigurationerna som var en databas på hårddisk och transaktionsloggen på en SSD. 

Abstract [en]

Solid State Drives (SSD) are now becoming  more common as storage and is about to  become  an  alternative  to  magnetic  disks.  This  report  studied  how  to  best  utilize SSDs in a MySQL database. This study was carried out using experiments in which performance benchmarks were made to get an accurate view on which configuration of  SSDs  that  gives  the  best  performance  in  MySQL.  The  benchmarks  where  made with sql-bench and mysqlslap.   The  results  indicate  that  a  database  using  only  SSD  storage  performs  equal  to  a database of solid-state cache under the majority of the tests and shows better results than the remaining configurations that include a database on a single hard drive and a configuration with the transaction log on a SSD. 

Place, publisher, year, edition, pages
2012. , 68 p.
Keyword [en]
Database, MySQL, OpenIndiana, mysqlslap, sql-bench, Solid State Drive, Hård drive, Performance, ZFS
Keyword [sv]
Databas, MySQL, OpenIndiana, mysqlslap, sql-bench, Solid State Drive, Hårddisk, Prestanda, ZFS
National Category
Computer Science
Identifiers
URN: urn:nbn:se:lnu:diva-21266OAI: oai:DiVA.org:lnu-21266DiVA: diva2:546578
Subject / course
Computer Science
Uppsok
Technology
Supervisors
Examiners
Available from: 2012-08-24 Created: 2012-08-23 Last updated: 2012-08-24Bibliographically approved

Open Access in DiVA

fulltext(1356 kB)236 downloads
File information
File name FULLTEXT01.pdfFile size 1356 kBChecksum SHA-512
7bd4842a90414a5c7e3761d525e3c4d1f9dcfc301b4d9700662322486abf220c6f693ae5b0f4572b2da64c198f0ea0b113ed017914db8f078fd664f5357a8e52
Type fulltextMimetype application/pdf

By organisation
School of Computer Science, Physics and Mathematics
Computer Science

Search outside of DiVA

GoogleGoogle Scholar
Total: 236 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: 422 hits
CiteExportLink to record
Permanent link

Direct link
Cite
Citation style
  • apa
  • 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