var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
my site is down. It couldn't connect to MySQL DB, so I checked in Terminal and did a df
the result is:
Filesystem 1K-blocks Used Available Use% Mounted onrootfs 20317384 19341420 0 100% /
devtmpfs 4038764 200 4038564 1% /dev
tmpfs 4048600 0 4048600 0% /dev/shm
/dev/md1 20317384 19341420 0 100% /
/dev/md3 948224680 19758540 880678420 3% /home
As you can see, MD1 is full. How can I make space here?
It's using ZPanel / Joomla 2.5x and I can access the site through SFTP and Terminal.
You need to check the partition and see what is eating up. Usually these are logs.
If the log files are eating up the space, you can just crop the file keeping the last 100 or 1000 lines.
Be careful if the logs we are talking about are mysql binglogs (as that usually happens)... don't "crop" but use the official mysql commands to trim them...
Originally Posted by
Your / partition is full. It seems that mySQL data are also stored in the same partition. You will not be able to start MySQL service until you free the space in / partition. It seems that server was configured with default partition settings. You have lots of space in /home but / partition has only 20 GB.
root cause - Bad decision made when server was deployed on how the filesystem was set up.
Yep, disk is full, need to free up space.
There are a lot of posts about this exact same issue if you search
http://www.webhostingtalk.com/showthread.php?t=1300690 might get you started...
CPanel Shared and Reseller Hosting, OpenVZ VPS Hosting. West Coast (LA) Servers and Nodes
Running Linux since 1.0.8 Kernel!
Providing Internet Services since 1995 and Hosting Since 2004
you can change mysql directory
Stop MySQL using the following command:
sudo /etc/init.d/mysql stop
Copy the existing data directory (default located in /var/lib/mysql) using the following command:
sudo cp -R -p /var/lib/mysql /newpath
edit the MySQL configuration file with the following command:
Look for the entry for datadir, and change the path (which should be /var/lib/mysql) to the new data directory.
In the terminal, enter the command:
sudo gedit /etc/apparmor.d/usr.sbin.mysqld
Look for lines beginning with /var/lib/mysql. Change /var/lib/mysql in the lines with the new path.
Save and close the file.
Restart the AppArmor profiles with the command:
sudo /etc/init.d/apparmor reload
Restart MySQL with the command:
sudo /etc/init.d/mysql restart
Now login to MySQL, and you can access the same databases you had before.
First you need to check for log files size. If that doesn't help, best option would be move your mysql data directory to another partition which is having more space.
By narl in forum Hosting Security and Technology
Last Post: 04-23-2013, 04:51 AM
By sg552 in forum VPS Hosting
Last Post: 09-23-2012, 10:52 AM
By burnwire in forum Hosting Security and Technology
Last Post: 07-28-2012, 03:09 AM
By themuggle in forum Hosting Security and Technology
Last Post: 07-01-2009, 02:59 PM
By pmak0 in forum Hosting Security and Technology
Last Post: 01-16-2004, 04:13 AM
Tags for this Thread