quote]i use virtualmin on my server as control panel. i have two hard drive in my server. the first drive have 2 partition (35G and 30GB) .The others have one (70 GB). My main partititon that system run, is full %90. So mysql and my system freeze.

Drive 1
First partiton: 35 GB (completely full)
Second partiton: 30 GB (using %2)

Drive 2:
Third partiton: 70 GB (using %2)




1. Is the fullness of the disc space, effects the mysql server?

2. To decrease the use of main partition, is it possible to move /home directory or mail directory to other drive. If is it possible how can do this?

I've seen mysql run without issues up into the 99% used disk space.

Here's a simple guide to moving /home to a different partition:
http://www.go2linux.org/how-to-move-home-directory-to-another-partition

I've seen mysql run without issues up into the 99% used disk space.

Here's a simple guide to moving /home to a different partition:
http://www.go2linux.org/how-to-move-home-directory-to-another-partition

Good sounds,Thank you,I'm very need it to finish my work for move partition!I want to know this can fit the freebsd?

The provided guide seems pretty good but it's not for FreeBSD, but Linux, so I wouldn't recommend to use the exact steps as it won't work.

There are several ways to do that, I will try to show you probably the easier one (not necessarily the most appropriate one). Assuming that:
- You have your Drive2 mounted as /hdd2
- Your homedir is /home (if you are not sure: "ls -ld /usr/home /home" as it may be /usr/home, depending O/S setup)

# Create home directory in /hdd2
mkdir /hdd2/home

# Set default home permissions (or 711 if you want to restrict listing):
chmod 755 /hdd2/home

# Copy hdd1's home to hdd2's home
cp -Rp /home /hdd2/

# Rename hdd1's home to oldhome
mv /home /oldhome

# Create symbolic link from /home to /hdd2/home
ln -s /hdd2/home /home

That should do the job and once you're sure that everything is fully functional on your new homedir, you may delete /oldhome to free up space on your first drive.

Thank you.

i use virtualmin on my server as control panel. i have two hard drive in my server. the first drive have 2 partition (35G and 30GB) .The others have one (70 GB). My main partititon that system run, is full %90. So mysql and my system freeze.

Drive 1
First partiton: 35 GB (completely full)
Second partiton: 30 GB (using %2)

Drive 2:
Third partiton: 70 GB (using %2)




1. Is the fullness of the disc space, effects the mysql server?

2. To decrease the use of main partition, is it possible to move /home directory or mail directory to other drive. If is it possible how can do this?

Please make sure you have a backup before you try anything. This is an easy recipe for data loss if you're not careful.

Big thanks for this info :)