Hi,
I'd like to move my database to my SSD and found this link explaining how: viewtopic.php?t=140924
My question is whether this is a common thing or will I end up breaking stuff in the process? It seems strange that I can now move almost any app to a different volume but Qnap doesn't provide a way to move the databases (or do they?) which seems to me to be the most obvious thing to move.
Thoughts? Has anybody done this? If so, how'd it work out for you?
Thanks in advance.
Moving MariaDB database to SSD
-
- Starting out
- Posts: 30
- Joined: Mon Sep 14, 2015 9:18 pm
Moving MariaDB database to SSD
Last edited by WarmHeart on Mon Mar 21, 2022 8:46 am, edited 1 time in total.
QNAP TVS-471 w/ 4x4TB WD Reds (RAID1) + SSD (1 TB), 2 Storage Pools (8 TB, 1 TB), FW: QTS 4.5 (Latest...)
-
- Starting out
- Posts: 30
- Joined: Mon Sep 14, 2015 9:18 pm
Re: Moving MariaDB database to SSD
Hi, I posted this about a year ago with no replies, so I'm trying again. My concern is that the post describing how to do this -- viewtopic.php?t=140924 -- has the instruction to:
But my mysqld.sh file doesn't have this line. Does anyone know if it's still needed?
I'm using MariaDB 5.5.68, Version 1.0.1.235 (2021-10-04)
Any ideas of how to move the DB to my SSD?
Thanks!!
Code: Select all
Find "datadir_set=" and change to "datadir_set=1"
I'm using MariaDB 5.5.68, Version 1.0.1.235 (2021-10-04)
Any ideas of how to move the DB to my SSD?
Thanks!!
QNAP TVS-471 w/ 4x4TB WD Reds (RAID1) + SSD (1 TB), 2 Storage Pools (8 TB, 1 TB), FW: QTS 4.5 (Latest...)
-
- First post
- Posts: 1
- Joined: Wed Apr 20, 2022 10:31 am
Re: Moving MariaDB database to SSD
I have the same needs,found no course