mysql启动: Can't start server : Bind on unix socket: No space left on device

Question

mysql启动报错:

131223 19:03:24 [Note] Plugin 'FEDERATED' is disabled.
131223 19:03:25  InnoDB: Started; log sequence number 55 4050118616
131223 19:03:25 [ERROR] Can't start server : Bind on unix socket: No space left on device
131223 19:03:25 [ERROR] Do you already have another mysqld server running on socket: /var/run/mysqld/mysqld.sock ?
131223 19:03:25 [ERROR] Aborting

131223 19:03:25  InnoDB: Starting shutdown...
131223 19:03:30  InnoDB: Shutdown completed; log sequence number 55 4050118616
131223 19:03:30 [Note] /usr/sbin/mysqld: Shutdown complete

当我想做的时候

sudo mkfifo /var/run/mysqld/mysqld.sock

我有

mkfifo: cannot create fifo `/var/run/mysqld/mysqld.sock': No space left on device

df -h 的结果:

     df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/mapper/system-root
                      473M  131M  318M  30% /
tmpfs                 5.9G     0  5.9G   0% /lib/init/rw
udev                  5.9G  168K  5.9G   1% /dev
tmpfs                 5.9G     0  5.9G   0% /dev/shm
/dev/md0              472M   27M  422M   6% /boot
/dev/mapper/system-usr
                      9.2G  772M  8.0G   9% /usr
/dev/mapper/system-var
                       13G  4.5G  7.7G  37% /var
/dev/mapper/system-home
                      591G  280G  282G  50% /home
/dev/mapper/system-logs
                       15G  7.7G  6.1G  57% /logs

所以...我有可用空间，但我没有可用空间？启动mysql要做什么？

Answer 1

第 4 行告诉你你已经有另一个 mysqld 服务器在套接字上运行:/var/run/mysqld/mysqld.sock 吗？

如果 /var/run/mysqld/mysqld.sock 已经存在，这将失败。