Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Since The database will be very read/write intensive, and there is alot of delete queries which will be executed :

  • How reliable could be PCIe SSD , and how fast will it degrade on alot of delete queries ? ( about a few hundred delete queries per second ).
share|improve this question
add comment

1 Answer 1

Certainly write-wearing remains a problem with any form of flash but things have improved a great deal over the last five years or so. The key is buy either buy a flash device with a good chunk of 'over-commit' space (storage set-aside to deal with parts of memory 'killed' by writes) - consumers SSDs typically have anywhere between zero and 7% of their space for this while high-end disks often seen this very much higher, sometimes more than 100%. Depending on a number of factors such as OS, filesystem and make/model of flash this setting may be tunable yourself and certainly setting aside, via product selection or manually, around 28% or so should pretty much ensure your flash will survive at least 3 years based on even quite heavy loads.

There is something else to consider, try really hard to pick an OS and filesystem combination that supports TRIM, this will only help a little with write-wearing but should improve and maintain overall performance with whichever flash based disk you go for.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.