ERROR: The partition with /var/lib/mysql is too full!
Solution 1
Check your disk space usage.
sudo df -h
You can mount large database to another partition through binding.
bind
is a mount option to mount directories inside directories.
Solution 2
sounds like your disk is full, your probably going to need to clean out log files or make your disk larger, without knowing the finer details of your partition setup i cant advise but you may be able to mount an EBS volume on to your server and move your /var/lib/mysql folder into it then remount that volume under /var/lib/mysql and restart mysql.
once its working you should be able carry on as normal until that drive gets full
Solution 3
Run: sudo apt-get clean
and restart MySQL process
$ sudo apt-get clean
$ sudo /etc/init.d/mysql start
Related videos on Youtube
Comments
-
alexanderzhirov over 1 year
I am running in a problem here I have a linux instance running on EC2. All was working fine till last night. Today morning it showed me some error stating that there was no disk space to write of mysql.
So I tried to stop and start mysql server. Stopping worked fine, but when i start with following command
sudo /etc/init.d/mysql start
It is showing me the error
ERROR: The partition with /var/lib/mysql is too full!
-
Decado almost 13 yearsWe're probably going to need some more information. Is /var/lib/mysql an ebs backed volume or ephemeral storage?
-
alexanderzhirov almost 13 yearsI am new to linux can you explain me more what you need to know???
-
Chopper3 almost 13 yearswe'll be running out of space if you keep duplicating your posts!
-
-
alexanderzhirov almost 13 yearsi did sudo df -h and get /dev/sda1 usage 100% so how to clean that???
-
Suku almost 13 yearsPaste the output of sudo fdisk -l and sudo df -h here.
-
rvs almost 13 years@jimy - you have two options: 1) detete something you don't want. Take a look to logs in /var/log/, temporary files in /tmp and /var/tmp. 2) extend /dev/sda1 partition. Since you are on EC2 it should not be that hard. Method how to do it depends on storage you are using (EBS/non-EBS) and filesystem type.