Sample Header Ad - 728x90

How much changing MySQL datadir from SSD Drive "C:/.." to HDD Drive "D:/.." will slow down the query processing speed?

-2 votes
1 answer
145 views
I am working on my local device and have created a schema that makes drive "C:/" (SSD) nearly full (it took up nearly 60 GB from the available space), so I think I should move the data to drive "D:/" (HDD) to free up some space in Drive "C:/" and be able to create more schemas.. The question that comes in my mind before changing datadir value in my.ini file (MySQL Server 5.5) is that: I have many queries that take > 10 minutes to finish, so, does moving the data to an HDD Drive will make the execution time a lot longer than before?, If so, I would not move the data but look for another way to free up the space and be able to create more schemas! --- I am using [UMLS](https://www.nlm.nih.gov/research/umls/licensedcontent/umlsknowledgesources.html) and [restricted](https://www.nlm.nih.gov/research/umls/implementation_resources/scripts/README_RRF_MySQL_Output_Stream.html) to use MySQL Server 5.5 Therefore, I am intrested in the reading speed more than the writing speed.
Asked by user262207
Oct 13, 2022, 09:31 AM
Last activity: Oct 13, 2022, 03:43 PM