All Questions
5
questions
25
votes
6
answers
4k
views
Scaling databases with cheap SSD hard drives
I hope that many of you are working with high traffic database-driven websites, and chances are that your main scalability issues are in the database. I noticed a couple of things lately:
Most large ...
- 391
3
votes
3
answers
764
views
Using SSD drives in a raid in an operation involving little to no deletes
From what I've been able to understand when reading about the case with Solid State drives and raids, the problem is that TRIM cannot be used for them in a raid configuration, thus, resulting in the ...
- 33
1
vote
4
answers
4k
views
SSDs + RAID5 + Database = Fail?
I have a database running on a RAID5 array of SSDs. Could this be killing its performance? When I do many inserts in a row, the entire computer starts blocking up. Even things like firefox start ...
- 1,207
1
vote
0
answers
2k
views
What is the optimal strip size/full stripe size on a RAID 10 array for a database server?
I'm setting up a new SqlServer database server at work. The machine is a HP Proliant DL368 Gen9 with the SSD disks. When trying to create the array, I have to select the stripe/full stripe size. This ...
- 111
-1
votes
1
answer
1k
views
8 x 15k SAS hdd disk with raid 0 performance vs single SSD disk for database [closed]
Which one has a better performance for database application (e.g. postgres) if we just consider read/write operations speed and not fault tolerance
8 x 15k SAS hdd disk with raid 0
single SSD disk
- 1