Jump to content

So I recently got the idea of having an SSD database here since buying an SSD today (while much cheaper), many still consider it an investment.

 

So here's what you guys do:

 

  1. Download ATTO here http://www.techpowerup.com/downloads/1749/atto-disk-benchmark-v2-46/
  2. Post a screenshot of your benchmark in this thread.
  3. Post your 4k read/writes and maximum read/writes in this google docs https://docs.google.com/forms/d/1dkj4MtWLogf2ExLSFLEAqWDiZadajgWY3wMoY_sFvgI/viewform?usp=send_form and link your post with the benchmarks screenshot there.

 

Here's the results: https://docs.google.com/spreadsheets/d/1aCj2GKakRlTlx6HxAP0vzx5uRhHA8xiv4G60ngXrl5c/edit?usp=sharing

“The value of a college education is not the learning of many facts but the training of the mind to think”

 

Link to comment
https://linustechtips.com/topic/166772-ltt-forums-ssd-performance-database/
Share on other sites

Link to post
Share on other sites

4gSJCfx.png

My weakling m500  :lol:

Location: Kaunas, Lithuania, Europe, Earth, Solar System, Local Interstellar Cloud, Local Bubble, Gould Belt, Orion Arm, Milky Way, Milky Way subgroup, Local Group, Virgo Supercluster, Laniakea, Pisces–Cetus Supercluster Complex, Observable universe, Universe.

Spoiler

12700, B660M Mortar DDR4, 32GB 3200C16 Viper Steel, 2TB SN570, EVGA Supernova G6 850W, be quiet! 500FX, EVGA 3070Ti FTW3 Ultra.

 

Link to post
Share on other sites

-snip-

 

I'll let you add me because I'm lazy. I also don't get this shit, can somebody tell me which one of these is 4k? or do you mean just "4000" value.

It's the write speeds for a 4.0 bar on the top left. TBH that's the great thing about community submissions. It's everyone doing a small part instead of the OP/mods doing a whole bunch. So while yeah you're only one submission and I could enter you in, I'm not gonna start if it's going to be a pattern for everyone who's lazy.

“The value of a college education is not the learning of many facts but the training of the mind to think”

 

Link to post
Share on other sites

post-75677-0-38278200-1402900711_thumb.ppost-75677-0-24188300-1402901540_thumb.p
 

Samsung 840 EVO 1TB

OS drive in laptop with 24GB RAM, RAPID enabled

Overprovisioning of 10% [Default], 931GB usable

S.M.A.R.T. reported +~25GB Host writes on each of the benchmark runs (I did 3 runs just to be sure. The other looked very similar)

 

This probably shouldn't count in the database but I thought it would be interesting to share. Can someone explain what's happening with those larger transfer sizes and the write amplification indicated by S.M.A.R.T. (I doubt the benchmark intended to write ~25GB)?

 

As a suggestion, could you add a field in your database for comments about the system config? Perhaps change the "Do you RAID?" to "SATA2/SATA3/mSATA/SAS/PCIE2/3(number of lanes)/RAID controller? ... e.t.c". That would help explain odd benchmark results (e.g. ^ on SATA2?). Also having results in MB/s I think would be easier to read and compare (too many numbers, the last few are within margin of error anyway), though I guess it's not too hard to convert mentally.

post-75677-0-38278200-1402900711_thumb.p

post-75677-0-24188300-1402901540_thumb.p

Link to post
Share on other sites

o0, nice topic.

 

Will participate when I'm home (unless I forget)

Respect the Code of Conduct!

>> Feel free to join the unofficial LTT teamspeak 3 server TS3.schnitzel.team <<

>>LTT 10TB+ Topic<< | >>FlexRAID Tutorial<<>>LTT Speed wave<< | >>LTT Communies and Servers<<

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×