4

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
cool_cs
  • 181
  • 3

2 Answers2

6

It probably means that the device is out of space:

# perror 28
OS error code  28:  No space left on device
d34dh0r53
  • 1,671
  • 11
  • 11
0

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 }'
Tom
  • 10,886
  • 5
  • 39
  • 62
  • How do I see which files are taking too much space? – cool_cs Jun 03 '12 at 16:03
  • @cool_cs: start here follow the links http://serverfault.com/questions/394974/cant-figure-out-why-hard-drive-is-full and please don't cross post questions to multiple stackexchange sites. – user9517 Jun 03 '12 at 16:05
  • Is it safe to remove the mysql log files? – cool_cs Jun 03 '12 at 16:27
  • I can only really point you at some posts on the matter- http://www.mysqlperformanceblog.com/2007/12/09/be-careful-rotating-mysql-logs/ – Tom Jun 03 '12 at 17:46
  • http://dev.mysql.com/doc/refman/5.0/en/log-file-maintenance.html – Tom Jun 03 '12 at 17:46