ERROR: The partition with /var/lib/mysql is too full!

5,957

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
Share:
5,957

Related videos on Youtube

alexanderzhirov
Author by

alexanderzhirov

Web Developer #SOreadytohelp

Updated on September 18, 2022

Comments

  • alexanderzhirov
    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
      Decado almost 13 years
      We're probably going to need some more information. Is /var/lib/mysql an ebs backed volume or ephemeral storage?
    • alexanderzhirov
      alexanderzhirov almost 13 years
      I am new to linux can you explain me more what you need to know???
    • Chopper3
      Chopper3 almost 13 years
      we'll be running out of space if you keep duplicating your posts!
  • alexanderzhirov
    alexanderzhirov almost 13 years
    i did sudo df -h and get /dev/sda1 usage 100% so how to clean that???
  • Suku
    Suku almost 13 years
    Paste the output of sudo fdisk -l and sudo df -h here.
  • rvs
    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.