Knowledgebase

Portal Home > Knowledgebase > MySQL > MySQL: Error 28 from storage engine

MySQL: Error 28 from storage engine

MySQL errors can sometimes be a bit cryptic. Fortuantely, this one is fairly easy to resolve.

     1030 Got error 28 from storage engine

This means that the the drive or disk partition MySQL resides on is out of space. 

The first step is to figure out how much disk space is left 

   [root@box ~]# df

    Filesystem 1K-blocks Used Available Use% Mounted on
    /dev/xvda 244428960 244428960 0 100% /
    devtmpfs 6230512 112 6230400 1% /dev
    none 6230720 0 6230720 0% /dev/shm
    none 6230720 52 6230668 1% /var/run
    none 6230720 0 6230720 0% /var/lock
    none 6230720 0 6230720 0% /lib/init/rw

As you can see here, the primary partition (the first line that starts with /dev/xvda)  is completely full.  It's likely other things will be throwing errors as well, since no more log files can be written.

In the above example, the webserver's log files had completely filled up the drive.  This may not always be the case, so you have to do a little detective work to find out where the problem lies. 

If you need assistance cleaning up large files, please create a support ticket.

 

Was this answer helpful?

Add to Favourites Add to Favourites Print this Article Print this Article