Portal Home > Knowledgebase > Articles Database > MYSQL in /var or /home
MYSQL in /var or /home
| Posted by Zenon, 04-14-2010, 07:26 PM |
| I'm assuming its by default that MYSQL uses the /var partition for storing the databases since that's the way I've always seen it setup. However do to a rogue table that was growing exponentially unknown to us we were running out of space on /var and so the databases were moved to /home. Since we have now located the culprit that was using all the space and removed it we could comfortable move all the databases back to /var.
Is there a good reason to move them back to /var, or should I just leave them where they are?
Thanks,
Zenon
|
| Posted by xerophyte, 04-14-2010, 10:23 PM |
| if /var has no special configuration (like on sas or specialize disk) you can leave it on the /home.
|
| Posted by fabin, 04-15-2010, 12:21 AM |
| Technically, it doesn't matter if its in /var/ or in /home. But, as you have fixed the problem with growing databases, you can change it to /var. So you have more space in /home for the accounts.
|
| Posted by Aun Muhammad, 04-15-2010, 02:52 AM |
| Usually /home has more size then /var. So if you think that your databases will grow in size or they are already in GB's then its good idea to move mysql to /home otherwise /var is fine.
|
| Posted by assistanz247, 04-15-2010, 04:16 AM |
| Its always good to have MySQL in /var as /home will be used for accounts.
|
| Posted by madaboutlinux, 04-15-2010, 04:40 AM |
| Doesn't matter... leave it as it is...
|
| Posted by Zenon, 04-15-2010, 12:51 PM |
| Thank for the input. I really didn't know if there was any good reason Since it doesn't matter I'll just leave it where it is.
All the best,
Zenon
|
| Posted by fwaggle, 04-15-2010, 01:02 PM |
| If I'm not mistaken, databases default to /var, because /var is historically not shared between multiple machines, whereas in some situations /home or /usr (in the case of /usr/home) can be.
There's probably no other real reason why databases live in /var, I think you'll be okay leaving them in /home, assuming permissions are okay.
|
Add to Favourites 
Print this Article
Also Read
Shared Hosting
Shared Hosting
