I have to import quite a lot of data (~100 million rows, ~100 times) into a MySQL database. Currently, it is stored on my hard disk drive, and the bottleneck of my import seems to be the hard disk drive write speed.
I have heard that SSDs do not like massive continuous writes, and that it tends to damage them. What do you think? Is this really an issue on modern SSDs?
Answer
It really is not a straightforward answer to this.
SSDs do not care about continuous writes as much as how many times any particular sector is overwritten. When SSDs first came out, something like SQL was a bad word as the operating system in general treated the drive like a traditional HDD and failures were very frequent.
Since then, drives have become bigger, cheaper, more reliable, meant for more read/writes and the operating systems have become smarter.
SSDs in SQL is not only common, but often encouraged. Feel free to peruse the DBA sister site.
My thoughts are to do it, assuming the SQL server is built properly with redundant disks. If not, then expect a failure eventually anyway.
Attribution
Source : Link , Question Author : christophetd , Answer Author : Community
