Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I am getting this error message whenever I try to create a new index or a new table in my mysql server. Does anyone know what the reason is? This is the ouput after I run df -a

Filesystem            Size  Used Avail Use% Mounted on
/dev/sda2              13G  7.3G  4.5G  63% /
/dev/sda1             251M   27M  212M  12% /boot
tmpfs                 3.9G     0  3.9G   0% /dev/shm
10.156.248.29:/vol/pharos_pnxd_data_01/env_empty_sbid_27133_qdcprod
                       30G   30G   32K 100% /app
share|improve this question
add comment

2 Answers

It probably means that the device is out of space:

# perror 28
OS error code  28:  No space left on device
share|improve this answer
add comment

usually the disk is full. Are you on linux or windows?

on linux see which disk is full;

$ df -h
Filesystem                                      Size  Used Avail Use% Mounted on
rootfs                                           50G   18G   33G  35% /
devtmpfs                                        3.0G     0  3.0G   0% /dev
...

check the error code;

$ perror 28
OS error code  28:  No space left on device

you can look for big log files in /var/log with find;

# find /var/log -type f -size +50M -exec ls -lh {} \; | awk '{ print $9 ": " $5 }'
 /var/log/syslog: 352M

or look in /var/ if thats the one thats full

 find /var/ -type f -size +50M -exec ls -lh {} \; | awk '{ print $9 ": " $5 }'
share|improve this answer
    
How do I see which files are taking too much space? –  cool_cs Jun 3 '12 at 16:03
    
@cool_cs: start here follow the links serverfault.com/questions/394974/… and please don't cross post questions to multiple stackexchange sites. –  Iain Jun 3 '12 at 16:05
    
Is it safe to remove the mysql log files? –  cool_cs Jun 3 '12 at 16:27
    
I can only really point you at some posts on the matter- mysqlperformanceblog.com/2007/12/09/… –  Tom H Jun 3 '12 at 17:46
    
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.