High traffic in MySQL can corrupt SD ?

Mar 01, 2017 25 Replies

Samsung SSD's offer this as an over-provisioning feature when formatting.

---druck

This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus

I should have added you need to do this when the device is brand new, before you have written data to it. In some cases you might achieve the same if you do it after a format unit command, or after doing a trim/unmap over the whole device, but this is less certain and depends on the internal detail of how the device handles these commands.

Several manufacturers offer it to OEM's, but not necessarily to end-users. It's not the only variable - quality of the flash parts used is also a big factor, and the manufacturers sort their flash chips by various aspects of quality following testing, to be used in different quality/longevity/duty products.

Andrew Gabriel [email address is not usable -- followup in the newsgroup]

Real hard information presented well

Usenet at its best.

+1000
New Socialism consists essentially in being seen to have your heart in the right place whilst your head is in the clouds and your hand is in someone else's pocket.

My online web server will often under sever stress show 98%+ I/O wait, indicating that it has simply not got enough buffers.

Databases are HUGE resource hogs if the data size is big enough or the query complex enough.

New Socialism consists essentially in being seen to have your heart in the right place whilst your head is in the clouds and your hand is in someone else's pocket.

And especially if the database is mistuned, i.e. there are commonly used joins that don't have supporting indexes on the tables being joined.

martin@ | Martin Gregorie gregorie. | Essex, UK org |

o:

it also depends on the definition of "quickly".

Bye Jack

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required